INDEPENDENT SOFTWARE JOURNAL
TrebuchetJOURNAL
EST. 2026 · DIGITAL EDITIONExplore guides
LIBREOFFICE · CALC · HOW-TO GUIDE

Import CSV into LibreOffice Calc Without Broken Columns

Control separators, encoding, and column types when opening data files in Calc.

Control separators, encoding, and column types when opening data files in Calc. This tutorial focuses on a repeatable real-world task you can test on a sample file, not an unverified performance claim. LibreOffice is a desktop office suite; application menus and options may differ by operating system and release.

Actual LibreOffice Calc 25.2 CSV import dialog with example data
Actual screenshot of LibreOffice Calc 25.2 on Linux: CSV Import dialog with original demonstration data. Settings may vary by locale.
Real LibreOffice desktop interface with original example data
Original screenshot of a sample table in LibreOffice Calc 25.2 on Linux. Import-dialog steps are explained in the text; the screenshot itself shows the worksheet after import.

How to do it: a practical workflow

Work on a copy of your files when learning a new application. The sequence below gives you a testable outcome and a way to verify the result.

  1. Step 1. Open a copy of the CSV and look for the delimiter: comma, semicolon or tab.
  2. Step 2. Use the Text Import dialog to select the correct separator and review the live preview.
  3. Step 3. Choose a suitable character encoding and inspect accented characters or non-Latin names.
  4. Step 4. Explicitly treat identifiers or ZIP codes as text so leading zeros are preserved.
  5. Step 5. After import, check the row count and totals before converting to ODS for continued work.

Worked example you can recreate

Try this on a sample file

A CSV contains account ID 00125, date 2026-10-01 and amount 19.95. Set the ID column to Text in the import dialog so it does not become 125; then save an ODS working copy and retain the untouched source CSV.

Common problems and what to verify

CSV has no inherent formatting, sheet styles or rich formula metadata. Saving back to CSV can lose information that an ODS keeps.

Before handing a document to someone else, open the output in the format that person will use. Check the content and key calculations rather than relying on an export-success notification.

Quick answer

Why are all CSV values in one column?

The wrong delimiter was selected. Reopen Text Import and choose the separator matching the file.

Official reference and download

These instructions draw on documentation from The Document Foundation. For current user-interface details, refer to the official guide for this topic ↗. Download installation files only from LibreOffice's official download page ↗.

Keep learning

Each of these related guides answers a different task, so you can move from basic setup to a more specific workflow without repeating the same overview.

Independent educational coverage. Trebuchet is not affiliated with or endorsed by The Document Foundation. This article describes documented workflows and illustrative examples; it is not a report of hands-on benchmarking or testing.