Convert Excel to Parquet
Convert Excel to Parquet
Parquet is a compact, columnar format that's much faster to read than Excel and keeps column types. Converting takes two nodes.
You'll use: File Input → File Output.
File Input
data.xlsx
File Output
data.parquet
Steps
- Upload your
.xlsxfile on the Datasets page. - File Input — select the dataset (Ciaren reads Excel via
openpyxl). - File Output — set
format: parquetand a name likedata. - Run. Download the
.parquetfrom the run output.
Exported Python
import pandas as pd
df_data = pd.read_excel('data.xlsx')
df_data.to_parquet('data.parquet', index=False)
Tips
- Pick a specific sheet on the Datasets page when uploading — the import dialect options include a sheet name/index for workbooks with several sheets.
- Going the other way? Swap the formats — Parquet in, Excel or CSV out.
- Large files? Parquet output plus the polars engine (and lazy export) is much faster than CSV. See Engines.