CSV2ODS(1)

🌸 NAME 🌸

okay so bestie, welcome to the csv2ods(1) page from the User commands manual — this is the main character energy for turning CSVs into OpenDocument spreadsheets, no cap. csv2ods — Create OpenDocument spreadsheet from comma separated values. periodt 💅

🌈 SYNOPSIS 🌈

csv2ods -i file.csv -o file.ods

✨ DESCRIPTION ✨

Okay so this program reads a file in CSV format — table of columns delimited by commas, tabs, or any other character. Then it creates a spreadsheet. If a value looks like a number, the cell is formatted as a number as well. Lowkey iconic behavior, fr fr. 🦋

💅 OPTIONS 💅

here’s the full options menu, bestie — every flag is invited to the party 🎀

• --version — shows the program’s version number and exits. 👋
• -h, --help — shows the help message and exits. 🫶
• -i INPUT, --input=INPUT — file input in csv. 📥
• -o OUTPUT, --output=OUTPUT — file output in ods. 📤
• -d DELIMITER, --delimiter=DELIMITER — specifies a one-character string to use as the field separator. It defaults to ",". 💬
• -c ENCODING, --encoding=ENCODING — specifies the encoding the file csv. It defaults to utf-8. 🧚
• -t TABLENAME, --table=TABLENAME — the table name in the output file. 🏷️
• -s SKIPINITIALSPACE, --skipinitialspace=SKIPINITIALSPACE — specifies how to interpret whitespace which immediately follows a delimiter. It defaults to False, which means that whitespace immediately following a delimiter is part of the following field. 🫧
• -l LINETERMINATOR, --lineterminator=LINETERMINATOR — specifies the character sequence which should terminate rows. 🚧
• -q QUOTING, --quoting=QUOTING — can take on any of the following module constants:
  • 0 = QUOTE_MINIMAL means only when required, for example, when a field contains either the quotechar or the delimiter.
  • 1 = QUOTE_ALL means that quotes are always placed around fields.
  • 2 = QUOTE_NONNUMERIC means that quotes are always placed around fields which do not parse as integers or floating point numbers.
  • 3 = QUOTE_NONE means that quotes are never placed around fields. The default is QUOTE_MINIMAL.
• -e ESCAPECHAR, --escapechar=ESCAPECHAR — specifies a one-character string used to escape the delimiter when quoting is set to QUOTE_NONE. 🪄
• -r QUOTECHAR, --quotechar=QUOTECHAR — specifies a one-character string to use as the quoting character. It defaults to ". 🎀

🍓 EXAMPLE 🍓

try this exact example, bestie:

csv2ods -i /etc/passwd -o accounts.odt -d:

👑 AUTHOR 👑

Agustin Henze <agustinhenze at gmail.com> — Original author of csv-ods.py. 💜

this page is from odfpy, dated 01/04/2009 — mwah 💋