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.