LibreOffice Calc CSV Export Options Explained

LibreOffice Calc provides powerful configuration tools to convert spreadsheet sheets into precisely structured Comma-Separated Values (CSV) files. When saving a spreadsheet as a CSV, Calc allows users to define character encoding, choose custom delimiters, handle text quoting, and preserve formatting. Understanding these export options ensures seamless data exchange between Calc, relational databases, data pipelines, and third-party software.

Accessing the CSV Export Settings

To configure custom CSV export options in LibreOffice Calc:

1. Open your document and navigate to File > Save As.
2. Set the file type dropdown to Text CSV (.csv).
3. Check the box labeled Edit filter settings.
4. Choose your destination folder, name the file, and click Save.
5. The Field Options (Export Text File) dialog will appear with the configuration settings.

Core Export Options in LibreOffice Calc

The Field Options dialog presents several parameters that dictate how data rows and cells are formatted in the resulting text file:

1. Character Set (Encoding)

• Function: Specifies the character encoding format for the output file.
• Common Choices: Unicode (UTF-8) is the recommended standard for modern applications and cross-platform compatibility. Other options include Western Europe (Windows-1252/WinLatin 1), ISO-8859-1, and region-specific encodings for legacy systems.

2. Field Delimiter

• Function: Defines the character used to separate columns within each row.
• Options: Common separators include the standard comma (,), semicolon (;), tab ({Tab}), and space ({Space}). You can also type any custom character directly into the field.

3. String Delimiter (Text Qualifier)

• Function: Specifies the character used to enclose text data within cells.
• Options: Double quotes (") are the default standard. Single quotes (') or no delimiter are also selectable. String delimiters prevent errors when cell contents contain the chosen field delimiter or line breaks.

4. Quote All Text Cells

• Function: Controls when string delimiters are applied.
• Behavior: When unchecked, Calc only wraps cells containing the field delimiter, string delimiter, or line breaks in quotes. When checked, every text cell is strictly enclosed within the string delimiter regardless of its content. Numeric values remain unquoted.

5. Save Cell Content as Shown

• Function: Determines whether to export formatted data or raw underlying values.
• Behavior:
  • Enabled: Exports numbers, currencies, and dates exactly as they appear visually on the screen (e.g., $1,250.00 or 12/31/2024).
  • Disabled: Exports the raw underlying values (e.g., 1250 or standard numeric date values).

6. Save Cell Formulas Instead of Calculated Values

• Function: Determines whether to output the formula syntax or the evaluated result.
• Behavior: When enabled, cells containing formulas export the text formula itself (e.g., =SUM(A1:B1)) rather than the calculated numerical outcome.

7. Fixed Column Width

• Function: Converts the sheet into a fixed-width formatted text file instead of a delimited CSV.
• Behavior: Columns are exported with exact character widths matching the column sizes configured in Calc, padding empty spaces where necessary.

Multi-Sheet Export Considerations

By default, the standard CSV export in LibreOffice Calc only outputs the currently active sheet. To export multiple sheets to CSV: * Manually switch to each sheet and repeat the Save As process with distinct filenames. * Use a LibreOffice Basic macro or automated command-line scripts (soffice --headless --convert-to csv) to batch-export individual sheets programmatically.