Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.