CSV - Microsoft office for mac 2008 doesn't add all the commas?

Question

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:

ID,Product,Name,Value,Interest
1,PC

Which is no good because it missed 3 commas.

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

ID,Product,Name,Value,Interest
1,PC,,,

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? — Raystafarian, 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

Raystafarian · Accepted Answer · 2012-02-20 15:57:01Z

0

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

answered Feb 20, 2012 at 15:57

Raystafarian

21.4k11 gold badges59 silver badges90 bronze badges

Add a comment |

1 Answer 1