Working with csv (comma-separated value) file types is a common practice, particularly for people dealing with large data processing projects or preservation. In fact we, VTechData repository administrators, highly recommend the use of open file formats when publishing research data for the sake of preserving and making that research more easily accessible.
Because the csv file format is so common, we wanted to make note of a common error that can occur when creating a csv file within a Macintosh Operating System. Csv files that are created by exporting data from Microsoft Excel within a Mac OS get corrupted. This issue does not present any obvious issues when using the csv in most applications. However, there are several applications that do have issues interpreting this type of csv including VTechData, our research data repository. The issue that arises in VTechData is once a file has been uploaded to the repository, a user becomes unable to download that file.
Our current recommendation to resolve this issue is to either use a Windows Operating System when dealing with Excel csv files or to export files as tab delimited txt files when possible.
For more information about this issue see here and here.
© 2017 Virginia Polytechnic Institute and State University
University Libraries (0434)
Carol M. Newman Library, Virginia Tech
560 Drillfield Drive
Blacksburg, VA 24061
Art & Architecture Library
Veterinary Medicine Library
NVC Resource Center
Library Service Center
Feedback & Comments