XLS2CSV(1)

📦 version 1.6.4, in fedora 43, fedora 44

✨ XLS2CSV(1) ✨

okay bestie, welcome to the xls2csv page from the General Commands Manual 💖 yes it's a section 1 command, yes it's iconic, let's get into it 🎀

🌸 NAME 🌸

xls2csv — convert binary Excel (.xls) files to CSV 🦋

💅 SYNOPSIS 💅

xls2csv input-file [-l] [-v] [-e encoding] [-t sheet] [-q quote char]
[-f field separator]

like. that's the whole vibe. one input file, a lil pile of optional flags. slay ✨

👑 DESCRIPTION 👑

xls2csv converts binary Excel files (.xls) to comma-separated values (CSV), and it sends the plain-text output to standard out. no cap, it just prints and dips 🫶

Unless you say otherwise, all sheets in the workbook are processed, and the output values are double-quoted, separated by semicolons, and encoded as UTF-8. like that's the default fit it's wearing 💅

This behavior may be customized with the options below. and bestie, we're about to go through every single one, because we do not skip ✨

🎀 OPTIONS 🎀

  • -l — List sheets contained in the file but do not output their contents. it's giving "just show me the menu, i'm not eating yet" 🙈
  • -t sheet — Only process the named sheet. main character sheet energy, everyone else can wait 💖
  • -e encoding — The iconv output encoding (default "UTF-8"). want something else? the iconv girlies have you covered 🌈
  • -q quote char — The character used to quote strings (default '"'). yes it's literally a double quote by default, she's classic for a reason 🎀
  • -f field separator — The character used to separate strings (default ';'). semicolon supremacy, periodt ✨
  • -v — Verbose mode. she talks more. we love a chatty icon 💬

💀 BUGS 💀

The conversion tool has not been tested on big-endian machines. so like... if that's your situation, proceed with caution bestie, nobody's verified this and we are NOT gonna pretend otherwise 😭

🌟 AUTHOR 🌟

Copyright (C) 2004-2019 the libxls authors 💜 absolute legends, respect the lineage.

fr fr, that's the whole page. every flag, every default, every warning — nothing got dropped, we just made it cute 🫶

XLS2CSV(1) 🌸 31 January 2019 🎀 bye bestie, go convert some spreadsheets, you've got this 💅✨

📦 where this page comes from