Ask Your Question

Revision history [back]

Save Calc sheet to csv won't import into database

Hello,

I get an Excel spreadsheet, open it in a Calc sheet, and then Save As a csv file. Then I open it in the BBEdit text editor on my Mac and examine it to make sure it's properly delimited. Next I try to import it into a MySQL database using the LOAD DATA INFILE. This works well if I use Excel to do the Save As to csv file but not LIbre Calc sheet. It does save it as a UTF-8 file.

I'd love to get away from Excel if possible so looking for suggestions. Thanks.

Save Calc sheet to csv won't import into database

Hello,

I get an Excel spreadsheet, open it in a Calc sheet, and then Save As to a csv file. Then I open it in the BBEdit text editor on my Mac and examine it to make sure it's properly delimited. Next I try to import it into a MySQL database using the LOAD DATA INFILE. This works well if I use Excel to do the Save As to csv file but not LIbre Calc sheet. It does save it as a UTF-8 file.

I'd love to get away from Excel if possible so looking for suggestions. Thanks. Thanks.