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.