PowerTrove
EN
Get PowerTrove

Data tools

Convert Excel File to CSV

Exports the first or all worksheets as separate CSV files, using stored cell values without recalculating formulas.

Illustration · Change the representation

At a glance

Input
Select local .xlsx workbooks in File Explorer; Microsoft Excel is not required.
Selection
At least 1 item
Result
Exports the first or all worksheets as separate CSV files, using stored cell values without recalculating formulas. Source files stay unchanged.
Before it runs
You see the options and a preview first.
Pack
Data tools · Included in the full edition

How it works

  1. Select local .xlsx workbooks in File Explorer; Microsoft Excel is not required.
  2. Press Alt + Space and type “Convert Excel File to CSV”.
  3. Choose the first sheet or all sheets. Formatting and workbook features are not retained in CSV.
  4. Start the action and check the result.

A practical example

Export each worksheet of a workbook for a CSV-based import.

All actions in Data tools →
Convert CSV to Excel FileCreates an Excel workbook from each CSV or TSV file without requiring Microsoft Excel.Convert CSV to JSONConverts rows from CSV or TSV into a new JSON file for use in scripts and data imports.Convert CSV to MarkdownTurns a CSV or TSV table into a Markdown table in a new .md file, ready for documentation.Convert CSV to SQLCreates a .sql file with INSERT statements from CSV or TSV data; it does not connect to a database.Convert JSON to CSVConverts tabular JSON into a new CSV file that can be opened in spreadsheet software.Convert Excel File to JSONExports worksheet rows as JSON arrays in new files, without guessing headers or recalculating formulas.