Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Im working on a Mac and Im having problems saving my csv file for imports—What can I do to fix this?

April 26, 2017csv file Fix Mac problems Saving working

0

Posted

Im working on a Mac and Im having problems saving my csv file for imports—What can I do to fix this?

1 Answer

0

Posted

If you created your CSV file on a Mac you will not be able to upload it. Saving a CSV on a Mac encodes special characters that come out garbled between the Mac and the import. Mac also creates ‘line endings’ issues that can be interpreted as line feeds or carriage returns in the CSV file. The solution is if you are creating CSV files in Excel, on a Mac, make sure you use the option to Save As “CSV (Windows)”, otherwise the format will not be correctly recognized by CSV Import or you can just save the file on a PC or open the Excel files on a PC.