How do I get a CSV file to display properly?
April 13, 2010 7:35 AM Subscribe
I suspect I have a problem using OS X to upload a CSV file to a webform, and I suspect I’ll need an XLS guru to help me figure it out.
posted by digitalprimate to computers & internet (7 answers total)
Here’s the problem: I have to upload a CSV file to a webform. When I do this at the office (more on this in a moment) I have no problems, but when I do it from home, the file does not display properly. The file is supposed to display as a typical table with seven columns and any number of rows. Instead of displaying a table, I get one long row with as many columns as there were supposed to be rows + columns x rows.
I have two sources for downloading the CSV file in question: from the webform itself and from a website where I download a regular XLS file then convert it to CSV. It doesn’t matter from which source I originally get the file or how I edit it: it never displays properly when upload it from home. Also, it doesn’t appear to matter which browser I use to download or upload the file (FF, Safari, IE).
So, I suspect this is an OS X vs. Windows problem. At work I use a machine running XP SP2. At home, I use a machine running OS X 10.6.3. I’ve read a couple of places that the OS X version of Excel handles cell ends differently for CSV files, but that’s about as far as I’ve gotten. If it makes any difference (I don’t think it does at this point), the webform to which I upload the CSV file can only be accessed from IE.
Any advice welcome. I’m about to call an exorcist.