« Des Moines' New Year's resolutions | Main | Learn about marketing lagniappe »

File formats matter

What do .csv, .xls, .xlsx, and .ods all have in common?

They're all different ways to represent spreadsheet information. However, they're not all created equal.

I recently had a client that was working on a large analysis piece. He downloaded a data set in a CSV format, and proceeded to add multiple tabs of equations into it over the course of many, many hours. The entire time, he thought that autosave was storing these equations.

Excel crashed.

Pressure...

He then opens his (still csv) spreadsheet. All of the tabs are missing. He goes to the recovery files. All of the tabs are missing. He goes to his backup. All of the tabs are missing. It is like they never existed in the first place.

The problem is that csv is a very simple format. It doesn't support multiple tabs. It doesn't support much of anything. However, it is really easy to write, really efficient in storage space, and able to be imported into virtually any spreadsheet or database program, so it is a popular format for data sets.

Excel translated this file internally into it's own formats (.xsl or .xslx) which do support these formats. However, the autosave down-converted it back to csv, stripping all of the analysis out of the file.

All of this would have been avoided if he would have initially saved a verson as an .xslx format file, then made the changes.

C'est la Vie.

Jon Thompson

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d83452ceb069e20162ff8039d1970d

Listed below are links to weblogs that reference File formats matter:

Comments

File format should be in proper manner, by this work can be easily done.

The comments to this entry are closed.

« Des Moines' New Year's resolutions | Main | Learn about marketing lagniappe »

Technorati Bookmark: File formats matter

This site is intended for informational and conversational purposes, not to provide specific legal, investment, or tax advice.  Articles and opinions posted here are those of the author(s). Links to and from other sites are for informational purposes and are not an endorsement by this site’s sponsor.