ods2csv: Convert Open Document Spreadsheet ODS to CSV

[ bsd3, csv, program, text ] [ Propose Tags ]

Usually you would convert ODS to CSV via libreoffice --headless but this conflicts with running GUI instances of libreoffice and requires a full libreoffice installation and has incomprehensible CSV export command-line options and selection of individual tables is inferior.

This program quickly scans through a FODS or ODS document using a XML parser and watches only the necessary data. It does not interpret or evaluate the formula data, instead it assumes that the contained evaluated values are correct. This is true, if the file was saved from LibreOffice but might not be true if generated or manipulated by other tools.

You can feed generated CSV files to LaTeX datatool.sty, csvmidi, or csvreplace from Haskell package spreadsheet.

Example runs of the program:

ods2csv --list-tables input.ods
ods2csv --sheetnumber=1 input.ods >output.csv
ods2csv --sheetname="Table 2" --separator=TAB input.ods >output.tsv
ods2csv --sheetnumber=2 input.fods >output.csv
ods2csv --sheetnumber=2 <input.fods >output.csv

The program supports UTF-8 encoding for FODS/XML input, and applies Latin1 decoding otherwise. For writing CSV it uses the system's default encoding.

ToDo: Provide FODS parser as library function, maybe in spreadsheet.


Maintainer's Corner

Package maintainers

For package maintainers and hackage trustees


  • No Candidates
Versions [RSS] 0.0, 0.1
Dependencies base (>=4.5 && <5), bytestring (>=0.10 && <0.13), non-empty (>=0.3.4 && <0.4), optparse-applicative (>=0.11 && <0.19), shell-utility (>=0.1 && <0.2), spreadsheet (>=0.1.3 && <0.2), tagchup (>=0.4 && <0.5), utf8-string (>=1.0.2 && <1.1), utility-ht (>=0.0.10 && <0.1), xml-basic (>=0.1.1 && <0.2), zip-archive (>=0.4.3 && <0.5) [details]
License BSD-3-Clause
Author Henning Thielemann
Maintainer haskell@henning-thielemann.de
Category Text, CSV
Home page https://hub.darcs.net/thielema/ods2csv
Source repo this: darcs get https://hub.darcs.net/thielema/ods2csv --tag 0.1
head: darcs get https://hub.darcs.net/thielema/ods2csv
Uploaded by HenningThielemann at 2023-09-17T08:14:50Z
Distributions LTSHaskell:0.1, NixOS:0.1, Stackage:0.1
Executables ods2csv
Downloads 91 total (14 in the last 30 days)
Rating (no votes yet) [estimated by Bayesian average]
Your Rating
  • λ
  • λ
  • λ
Status Docs not available [build log]
Last success reported on 2023-09-17 [all 1 reports]