I opened a csv file in numbers, added some data, then exported the content back to a csv format (UTF-8), but when I did so it added BOM to it. That is according to a software developer. And because of that the file does not load on my wordpress site correctly. How can I have numbers export the csv correctly?
MacBook Pro 15", macOS 10.15
I don't think you can change the behavior of numbers. If a BOM really is the problem, then you could open the file with a text editor like bbedit and save again as utf-8.
If you open the file with the encoding set to MacRoman you should also be able to see the BOM as odd characters right at the beginning of the file and remove it.
Where did your file come from? Usually windows adds a BOM but Mac does not.
I obtained a csv file from a developer that works but the data is not relevant. It served as a file I could use for comparison. So what I ended up doing was opening that csv file with "textEdit" then took a duplicate file which I first added necessary data to in Numbers and exported it to a csv which I intern opened with "textEdit" then I compared to two. That's when I discovered one problem which was easily fixed with a find and replace. The correct csv had ";" to separate and the csv saved from Numbers had "," to separate. Once that was fixed it helped a great deal in getting the plugin to accept it. Of course there were some other items that needed correcting too, but with the use of "textEdit" all was resolved.
Tested with Numbers v6.2.1, it does not export UTF-8 with BOM into a .csv. Neither does LibreOffice v6.3.4.2 Calc. Checked both with hexdump. Microsoft applications, or PHP would be a more likely source though.
Good news! Sounds like the problem was likely not a BOM but the old delimiter issue:
https://stackoverflow.com/questions/10140999/csv-with-comma-or-semicolon
Good that you got this solved. CSV ordinarily implies comma-separated-values, though other unique delimiters can be used.
CSV export
