DriversRecommendedOutdated drivers can make a good PC feel brokenScan driver issues before chasing fixes manually.Scan NowOctober DealsAmazon USOctober deal check: compare before you payAmazon US: current deals, useful picks and tech finds.Check DealsPC HealthRecommendedCrashes, freezes, slowdowns? Check your PC nowSpot repairable issues before they interrupt work.Check PC×
Skip to content
World desk4 min

How to Batch-Convert Excel Spreadsheets on Linux with csvkit, Miller, or Gnumeric

Use csvkit’s in2csv or Gnumeric’s ssconvert for direct Excel-to-CSV conversion on Linux. Learn safe per-file loops, sheet selection, and output checks; Miller handles the records afterward.
Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

For direct Excel-to-CSV conversion on Linux, use csvkit’s in2csv or Gnumeric’s ssconvert. Miller’s mlr is for processing the CSV or other supported text-format records after conversion; its documented formats do not include Excel workbooks. The examples below create a separate output for each workbook and show how to handle multiple sheets deliberately.

Choose the right tool

Need Use What it does
Convert an XLS or XLSX workbook to CSV and select worksheets in2csv from csvkit Its current reference documents XLS/XLSX input and worksheet options.
Script conversions across spreadsheet formats supported by Gnumeric ssconvert Gnumeric documents scripted file conversion and options for listing importers and exporters.
Filter, reshape, sort, or transform tabular records after conversion mlr from Miller Miller handles documented delimited and JSON-style formats, not Excel workbook input.

For separate CSV files, run a conversion once per workbook. Miller can instead read multiple CSV files as a single record stream, which is useful for aggregation but does not preserve a one-workbook-to-one-output result.

Install and check the commands

csvkit

csvkit documents installation with pip install csvkit and recommends using a virtual environment. Package names and versions can vary by Linux distribution, so confirm that in2csv is available in your environment. The current csvkit documentation is version 2.2.0: csvkit documentation.

Gnumeric

Install Gnumeric through your distribution’s package manager, then confirm ssconvert is installed. The Gnumeric homepage reports version 1.12.62, released in September 2026: Gnumeric. Availability and command options depend on the installed package.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
#1 Best Overall
Lenovo IdeaPad Slim 3 Linux Laptop, 15.6" FHD Touchscreen Laptop, 8-Core AMD Ryzen 7 5825U, 16GB RAM, 512GB SSD, Keypad, SD Card Reader, Stylus Pen + External Portable SSD + USB Hub, Linux Ubuntu OS
  • Powerful Linux Laptop: This IdeaPad Slim 3 Laptop comes pre-installed with Ubuntu Linux, offering fast performance, robust security, and a clean, user-friendly experience. Enjoy full customization, seamless hardware compatibility, and access to thousands of open-source apps. Whether you're working, creating, or coding, it's built to keep up with everything you do.
  • A Multitasking Master: The latest AMD Ryzen 7 5825U processor (up to 4.5 GHz) delivers powerful performance with 8 cores and 16 threads for smooth multitasking. Integrated AMD Radeon Graphics provide crisp visuals for streaming, browsing, photo editing, and casual gaming. With smart machine intelligence, it adapts to your needs for a fast, responsive experience.
  • 15.6" Full HD Display: The IdeaPad Slim 3 boasts an 88% screen-to-body ratio for a floating, edge-to-edge visual experience. TÜV Low Blue Light certification reduces eye strain, making it perfect for long work or study sessions.
  • Military-Grade Durability: The smart IdeaPad Slim 3 combines portability and durability, letting you work, study, and play on the go. With a profile 10% slimmer than the previous generation, it's lightweight yet military-grade rugged, ready for anything, anywhere.
  • Versatile Connectivity: Enjoy the security of a built-in webcam with a privacy shutter. Connect effortlessly with multiple ports: 2x USB A, 1x USB C, 1x HDMI, 1x SD Card Reader, 1x Headphone/Microphone combo. Bundle comes with Stylus Pen, 256GB Portable SSD and 5-in-1 Docking Station.

Miller

Miller 6.22.0 documents CSV, TSV, JSON, JSON Lines, PPRINT, XTAB, NIDX, and DKVP formats. Check the installed command’s help or manual if its options differ from the examples: Miller documentation.

Batch-convert one workbook per CSV

These shell loops assume the input files are in the current directory. Quoted variable expansions preserve spaces in filenames, and the existence check makes an unmatched glob skip cleanly instead of creating a file from the literal pattern.

With csvkit

for f in ./*.xlsx; do
  [ -e "$f" ] || continue
  in2csv "$f" > "${f%.xlsx}.csv"
done

For legacy .xls files, use a separate loop and change the suffix:

Rank #2
HP 17 Business Laptop - Linux Mint Cinnamon - Intel Quad-Core i5-10210U, 32GB RAM, 1TB PCIe NVMe SSD + 1TB Storage HDD, 17.3" Inch HD+ (1600x900) Display
  • Intel Core i5-10210U (up to 4.2GHz) - 1TB PCIe NVMe + 1TB HDD - 32GB DDR4 SDRAM
  • 17.3" HD+ (1600x900) Display, Intel UHD Graphics 620
  • Built in HD 720p Webcam with Microphone - Bluetooth Version4.2
  • I/O Ports: 2x USB 3.1 (Data Only), 1x USB 2.0, 1x HDMI, 1x Headphone/Microphone Combo Jack
  • Linux Mint Cinnamon 64-Bit - 6-Row Keyboard w/ Full Numberpad
for f in ./*.xls; do
  [ -e "$f" ] || continue
  in2csv "$f" > "${f%.xls}.csv"
done

The redirection writes each command’s output to a CSV with the matching basename. For reruns, consider writing outputs to a dedicated directory so later input globs cannot include previous results.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

With Gnumeric

for f in ./*.xlsx; do
  [ -e "$f" ] || continue
  ssconvert "$f" "${f%.xlsx}.csv"
done

Use the equivalent ./*.xls glob and ${f%.xls}.csv suffix for legacy files. Gnumeric documents the ssconvert input output form and scripted conversion, but the opened manual is an archive copy for version 1.12.57 from May 2020. Check the installed options when behavior matters: run ssconvert --list-importers, ssconvert --list-exporters, and consult man ssconvert. The project’s conversion guidance is at Gnumeric: Converting Files.

Handle worksheets deliberately

A workbook may contain several sheets. With csvkit, list sheet names before choosing one:

Rank #3
Lenovo Business Laptop - Linux Mint (Cinnamon) - Intel i5-1335U, 16GB RAM, 256GB SSD, 15.6" FHD 1920x1080 Display, Full Keyboard, Fast Charging
  • Intel Core i5-1335U Processor (12M Cache, 12 Threads, up to 4.6 GHz) - 256GB Solid State Drive - 16GB DDR4 SDRAM
  • 15.6" FHD (1920x1080) Non-Touch Anti-Glare Display - Intel UHD 620 Integrated Graphics - Stereo Speakers
  • 720p HD Webcam with Privacy Shutter. Integrated Microphone - Intel Dual Band Wireless-AC (2x2) 8265, Bluetooth Version 4.2
  • I/O Ports: 2x USB 3.0, 1x USB 3.1 Type-C 3.1, Headphone/Mic Combo Port, 4-in-1 Card Reader, HDMI, Kensington Mini-Lock Slot
  • Linux Mint (Cinnamon) 64-Bit - Keyboard with Full NumberPad - Fast Charging
in2csv --names "workbook.xlsx"

Convert a named worksheet with:

in2csv --sheet 'Sheet Name' "workbook.xlsx" > "workbook.csv"

To write all sheets, csvkit documents --write-sheets -; --use-sheet-names lets output filenames use worksheet names. Check the generated filenames and destination directory with a sample workbook before running this across a folder. See the in2csv reference for the available options.

If you use Gnumeric, inspect the installed importer and exporter list and its manual for worksheet-related options. Do not assume that a simple workbook-to-CSV command exports every sheet: test the specific workbook and command behavior.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

Use Miller after conversion

Miller is useful once the spreadsheet data is in a supported record format. For example, convert a CSV to TSV with:

mlr --icsv --otsv cat input.csv > output.tsv

To process several same-schema CSV files as one stream and count records:

mlr --csv stats1 -a count input-*.csv

Miller treats the input files as one stream and avoids repeating CSV header lines. That behavior suits a combined analysis or transformation; use the per-file loops above when you need one output for each workbook. Miller’s formats and stream behavior are described in its documentation.

Check the output before converting a whole directory

  1. Pilot representative files. Convert at least one XLS and one XLSX if both types are present, then inspect the resulting CSV before processing the full batch.
  2. Verify the worksheet. List sheet names or choose a sheet explicitly; if exporting all sheets, confirm which files the command created.
  3. Compare important values. Check dates, identifiers with leading zeros, decimals, formulas, blank cells, and non-ASCII text against the workbook. The documentation does not claim that any converter preserves every spreadsheet feature or display choice.
  4. Inspect CSV quoting and delimiters. Fields containing commas, quotation marks, or newlines need to be represented correctly for the CSV consumer. Miller’s documentation distinguishes RFC-4180-style CSV from CSV-lite and describes their handling of embedded delimiters and line endings: Miller documentation.
  5. Keep inputs and outputs distinct. A separate output directory helps prevent reruns or broad globs from treating earlier CSVs as new inputs.
  6. Make failures visible. Check command exit statuses and record which input failed; do not treat a completed loop as proof that every file converted correctly.
Independent reader supportYour contribution helps us test, update, and keep practical guides available for everyone.Support on Ko-Fi

Why Excel files that look alike can produce different CSVs

CSV contains tabular values, not the full workbook experience. A conversion can differ in numeric representation or formatting even when two workbooks appear identical in Excel. csvkit warns: “If an XLS looks identical to an XLSX when viewed in Excel, they may not be identical as CSV.” Its example notes that an integer in an XLSX may be emitted without decimals while a visually similar XLS value may be emitted with decimals. See the in2csv reference.

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.
Best Value
Sale
GMKtec G3S Mini PC Intel N95 Processor (Up to 3.4GHz) 8GB RAM 256GB M.2 SSD
  • 12th Intel Alder Lake N95 Processor – The GMKtec G3 S Mini PC is powered by the 12th Gen Intel N95 processor with 4 cores, 4 threads, 6MB cache and a burst frequency up to 3.4GHz. Compared with N100/N5105/N5100/N5095, the N95 delivers up to 36% overall performance improvement. Perfect for routine tasks, office work, and home entertainment, this compact mini desktop is more convenient than traditional bulky PCs.
  • 8GB RAM & 256GB SSD Storage – Pre-installed with 8GB DDR4 memory and a fast 256GB M.2 2242 SSD, the G3 S mini desktop offers quicker startup, smoother multitasking, and faster file transfers. Enjoy seamless performance whether you’re working on multiple applications, browsing, or streaming content.
  • Rich Interfaces & Connectivity – The G3 S mini computer comes equipped with USB 3.2 (up to 10Gbps), dual HDMI 2.0 (4K@60Hz), and a 3.5mm audio jack. With support for WiFi 5, Bluetooth 5.0, and Gigabit Ethernet (RJ45 1000MbE), it connects easily with monitors, projectors, printers, office equipment, and other peripherals, making it versatile for both home and business use.
  • Dual 4K Display Support – Featuring upgraded Intel UHD Graphics (up to 1000MHz), the G3 S supports 4K video playback and AV1 decoding for a smooth viewing experience. With dual HDMI outputs, you can connect two 4K@60Hz displays simultaneously, enabling efficient multitasking for work and entertainment.
  • GMKtec WARRANTY - GMKtec offers a 1-year limited GMKtec's warranty for each mini PC, starting from the date of the purchase. All defects due to design and workmanship are covered. With a professional after sales team always ready to attend to your needs, you can simply relax and enjoy your mini PC.

csvkit also documents CSV dialect sniffing and type inference, with occasional inference errors. If you do not need those features for csvkit’s CSV handling, its documentation recommends --snifflimit 0 and --no-inference. These settings concern csvkit’s CSV handling; they do not make Excel conversion semantics identical.

Gnumeric’s archived manual describes exporter formatting choices including format=raw and format=preserve. Their outcome can affect dates and number formatting, so check your installed version’s exporter options before relying on either. The manual copy is for Gnumeric 1.12.57 from May 2020; use the installed man ssconvert and exporter list for current behavior.

Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.

Leave a Reply

Your email address will not be published. Required fields are marked *

Special offer. See more information about Outbyte and uninstall instructions. Please review EULA and Privacy policy.

More from the Wire

  1. World desk4 min
    How to Spot an AI Voice Scam Before Sending MoneyDon’t rely on how a caller sounds. Pause, call back through a known number, and verify the emergency with another trusted person before sending money.
  2. Mountain View desk4 min
    Google’s SynthID Detector: How to Check AI-Generated Images, Video and AudioGoogle’s SynthID Detector looks for an embedded watermark in supported images, video and audio. Here is what its results do—and do not—show.
  3. Redmond desk20 min
    How to create a link to File or Folder in Windows 11Windows 11 gives you several ways to point to a file or folder without moving or duplicating it. You can create a desktop shortcut,…
Recommended PC Tool
Recommended PC Tool
PC Slower Than It Used to Be?Free scan - under a minute
Crashes, No Sound, or Screen Glitches?Free driver scan

Two free Windows tools

One Free Minute Could Fix That PC

Before you go - each of these free tools takes about a minute and tackles what quietly slows a Windows PC down.

Special offer. View Outbyte info, uninstall instructions, EULA, and Privacy Policy.