Excel Financial Statements to Parquet for Analysis

Years of statements in Excel files are slow to analyse together. Parquet keeps them compact and typed.

Open the Excel to Parquet converter

Prepare each sheet with one header row, no titles, merged cells or subtotals. Open the Excel to Parquet converter and drop the workbook. Only the first sheet of an .xlsx file is read, and old .xls files must be saved as .xlsx first.

Parquet keeps a type for every column, so set numbers, dates and text before you export, and read the file back to check it.

Keep account codes as text, amounts as numbers and dates as dates. Convert each period the same way, so the files have the same columns and can be loaded together. Compare a column total with Excel.

Everything runs in your browser and nothing is uploaded.

Open the Excel to Parquet converter

Related tool pages

  • JSON, CSV, Parquet and Excel Converter: Convert between JSON, CSV, Parquet and Excel online for free, one file or a whole folder. It runs in your browser, so nothing is uploaded.
  • JSON to CSV Converter: Convert JSON to CSV in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.
  • CSV to JSON Converter: Convert CSV to JSON in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.
  • CSV to Parquet Converter: Convert CSV to Parquet in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.
  • JSON to Parquet Converter: Convert JSON to Parquet in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded.
  • Parquet to CSV Converter: Convert Parquet to CSV in seconds. Drop a file or paste data and download the result. Private: it runs in your browser and nothing is uploaded. Large files too.

How to use the Excel to Parquet converter: step by step

  1. Prepare the sheet.
  2. Open the Excel to Parquet converter.
  3. Check types and a total.
  4. Download Parquet.

When to use the Excel to Parquet converter

  • Analyse several years together
  • Archive statements compactly
  • Load a ledger into a warehouse
  • Speed up reporting

Example

Input: report.xlsx

Output: report.parquet

Frequently asked questions

Why convert Excel to Parquet?

Parquet is smaller and faster to load in tools like pandas, Spark, DuckDB and BigQuery.

Are numbers and dates kept as types?

Yes. Turn on type detection and numbers, dates and booleans are written as real column types.

How big can a file be?

It depends on your device. A few hundred MB usually works.

Which conversions does the Format Converter support?

Any direction between JSON, CSV, Parquet and Excel (.xlsx), for one file or a whole folder. Nested JSON is flattened into columns such as address.city. For Excel, the first sheet is read; old .xls files are not supported.

Tip: Use the same columns every period so files can be loaded together.