Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Let's say I have 5 column headings and I only complete the first 2 values. I then save the file as CSV (Windows). It ends up looking like this:


Which is no good because it missed 3 commas.

If I create the same CSV in Excel on a Windows PC it looks ok:


Unfortunately I don't have access to a MAC. This problem has been experienced by a client of mine which needs CSV for a site.

share|improve this question
The data is null anyway, what's the issue? You want there to be 0s? – Raystafarian Feb 19 '12 at 14:04
Problem is that the CSV needs to have all the commas otherwise the CSV doesn't work for importing the products for an online shop... – user649482 Feb 19 '12 at 14:06

Tell the client to try save as - windows csv OR save as - ms-dos csv

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .