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.

  • The data is null anyway, what's the issue? You want there to be 0s? Feb 19, 2012 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, 2012 at 14:06

1 Answer 1


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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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