LibreOffice Calc CSV: Import, Export, and UTF-8 Without Excel Traps

LibreOffice Is Free — CSV Still Needs the Text Import Dialog

Students, NGOs, public sector teams, and freelancers in the US, UK, Australia, Canada, and especially Europe rely on LibreOffice Calc instead of Microsoft Excel. Double-clicking a CSV often “works” until delimiters, UTF-8, or decimal commas silently corrupt the sheet. The Text Import dialog is the difference between a clean dataset and a one-column mess.

Open vs Save — Two Different Dialogs

Master both.

Step-by-Step: Import CSV Correctly

Do not skip the dialog.

• In Calc: File → Open (or Insert → Sheet from File) and select the CSV.
• When Text Import appears, set Character set to UTF-8 for modern files (or the known source encoding).
• Choose Separated by: comma, semicolon, tab, or other — match the file.
• Check the preview grid; fix separator until columns align.
• Select ID/ZIP/phone columns and set Column type to Text so leading zeros survive.
• OK → archive a note of the settings you used for recurring files.

Bestellnr;Kunde;Betrag;Datum
1001;Müller GmbH;19,90;2026-05-03
1002;Société Dupont;120,00;2026-05-03

Step-by-Step: Export / Save as CSV

Make the next person thank you.

• File → Save As → choose Text CSV (.csv).
• Open Edit filter settings (wording varies by version).
• Set Character set to UTF-8.
• Choose field delimiter (comma for US/UK tools; semicolon if your partners expect EU Excel).
• Decide on quote character and “save cell contents as shown” carefully — displayed formats can bake locale into values.
• Keep a .ods master if you need formulas; CSV is values only.

UTF-8, BOM, and Excel Interop

Cross-suite sharing.

• UTF-8 without BOM is ideal for most tools and the web.
• Some older Microsoft Excel on Windows want UTF-8 with BOM to detect encoding — see the CSV UTF-8 BOM guide.
• If Excel users struggle, convert CSV → .xlsx with Convert CSV Online and send the workbook.
• Never assume “CSV UTF-8” from Calc matched what Excel auto-detected.

Dates, Decimals, and Locales

Calc respects locale — that cuts both ways.

• Decimal comma vs point: set column type / locale so 19,90 does not become nineteen ninety.
• Prefer ISO dates in shared CSVs (YYYY-MM-DD).
• UK/AU DMY vs US MDY: same slash-date trap as Excel.
• See European Excel CSV and CSV date formats guides for deeper locale playbooks.

When to Use an Online Editor Instead

Calc is great; it is not always the fastest scalpel.

• Quick delimiter or encoding fixes without installing anything.
• Protecting IDs before someone opens the file in Excel.
• Converting to JSON/Markdown/Excel for other pipelines.
• Working on a locked-down machine where you cannot change Calc defaults.

Common Mistakes

Free-software foot-guns.

• Accepting Text Import defaults without checking the preview.
• Saving CSV with the wrong delimiter for the destination country.
• Losing leading zeros by leaving columns as Standard/Number.
• Editing a CSV, saving as .ods by habit, then emailing the wrong file.
• Assuming formulas round-trip through CSV.

Best Practices

Make Calc settings intentional.

• Document delimiter + encoding for each recurring partner feed.
• Keep .ods as the working file; export CSV as a snapshot.
• Type ID columns as Text on every import.
• Validate UTF-8 with a known accented character after save.
• Use Convert CSV Online when collaborating with Excel-only teammates.

Why Use Convert CSV Online?

Convert CSV Online is free, browser-based, and requires no account for everyday conversions. Fix delimiter and encoding issues before opening in Calc, or convert Calc CSV exports to Excel for Microsoft-centric colleagues — useful for US, UK, AU, CA, and EU users.

Conclusion

LibreOffice Calc handles CSV well when you use Text Import and Save filter settings deliberately. Set UTF-8, pick the right delimiter, force IDs to text, and keep an .ods master for anything with formulas.