Table CSV problems

I suspect it is a problem with converting an Excel file to csv, but I can’t get Table CSV to display properly -
http://www.thegourmetmerchant.com/csvtest/
The file looks exactly as it should in Resources Quicklook.


Thanks

There is a known problem with MS Excel on the Mac creating proper CSV files. If you have Apple Numbers then bring in the XLSX file and export as CSV. Numbers does the export correctly.

2 Likes

Thanks for pointing that out. Should stop me going round in circles.

1 Like

That was amazing mitchellm So easy. Worked first off. Never really used Numbers before, but it was so fast and looks so good it will be my go-to spreadsheet from now on

1 Like

Glad it worked! It’s not like MS Excel is a bad app! But it does have a few small quirks and CSV export is one of them. I don’t use Numbers all the time, but it is very nice for some things.

1 Like

But if you work with foreing languages, such as Spanish, there are problems with punctuation, such as accents, letter “ñ”, etc. LibreOffice (free), solves those problems very efficiently.