Data from OpenOfficeLibreOffice Calc, Microsoft Excel, Google Sheets, and other spreadsheet programs can be saved in the .csv format.
Tip: If you used the GitHub generated template, be sure to delete Rows 1-7 and Column A before saving as CSV / uploading to the CSV Importer.
Open Office LibreOffice Calc (recommended)
From an open spreadsheet, select File > Save As > Text CSV
If you have more than one sheet, only the active sheet will be saved as CSV
Tip: OpenOffice LibreOffice is a free open-source application, and it handles international character sets and CSV files much better than Excel. It also does not “helpfully” change the format of your dates, change non-dates to dates, remove “decimals” from identification number strings, or convert ISBNs to scientific notation number format.
If you’re not a regular user of Open OfficeLibreOffice, you can always create spreadsheets in the program of your choice, save, open in Open OfficeLibreOffice Calc, and then convert to CSV from there.
Microsoft Excel
From an open spreadsheet, select File > Save As > Comma Separated Values (.csv)
You may choose CSV UTF-8 or Microsoft CSV
If you have more than one sheet, only the active sheet will be saved as CSV
Google Sheets
From an open spreadsheet, select File > Download > Comma Separated Values (CSV)
If you have more than one sheet, only the active sheet will be downloaded as CSV