TabLab

Convert Parquet to Excel

Convert your parquet files to excel format with our free online converter. No installation required.

Files

Click anywhere to select filesor drag and drop files here
Accepts Parquet files

Trusted by over 40,000 every month

How to convert Parquet to Excel

  1. Upload all of the Parquet files you want to convert

    You can select multiple files at once or drag and drop a batch of files. All files will be converted simultaneously.

  2. Wait for the conversion process to complete
  3. Download your converted Excel files
  4. Process hundreds of files in a single batch

    Our converter handles large batches efficiently, saving you time compared to converting files one by one.

Converter Features

Fast conversion
Convert your parquet files to excel in seconds, even with large datasets
Batch processing
Upload and convert hundreds of files at once with no file size limitations
Downloadable results
Get all your converted files immediately after conversion
Data integrity
Preserve your data structure and types during conversion with high-fidelity transformations
Format optimization
Automatically optimize output files for size and performance based on the target format
No code required
Convert files without writing a single line of code, perfect for data analysts and business users

How to convert Parquet to Excel in Python

We can convert Parquet to Excel in Python using Pandas, DuckDB, or ClickHouse

How to Convert Parquet to Excel using Pandas

First, we need to install pandas

pip install pandas

Then we can load the parquet file into a dataframe

df = pd.read_parquet('path/to/file.parquet')

Finally, we can export the dataframe to the xlsx format

df.to_excel('path/to/file.xlsx', index=False)

How to Convert Parquet to Excel using DuckDB

First, we need to install duckdb for Python

pip install duckdb

The following duckdb query will copy the contents of a single Parquet file to a xlsx file

duckdb.sql("""COPY (select * from 'path/to/file.parquet') TO 'path/to/file.xlsx' (FORMAT 'xlsx')""")

If you have more than one Parquet file with the same schema (e.g. your Parquet files are partitioned) then you can use the following

duckdb.sql("""COPY (select * from read_parquet(['path/to/file1.parquet', 'path/to/file2.parquet'])) TO 'path/to/file.xlsx' (FORMAT 'xlsx')""")

How to Convert Parquet to Excel using ClickHouse

First, we need to install the ClickHouse client for Python

pip install clickhouse-connect

Then we can use ClickHouse to convert from Parquet to Excel

Start by importing the necessary libraries and connecting to ClickHouse:

import clickhouse_connect
import os
# Connect to ClickHouse
client = clickhouse_connect.get_client(host='localhost', port=8123)

Define your input and output file paths:

# Define input and output file paths
input_file = 'path/to/input.parquet'
output_file = 'path/to/output.xlsx'

Now perform the direct conversion from Parquet to Excel:

# Direct conversion from parquet to xlsx
client.command(f'''
INSERT INTO FUNCTION file('{output_file}', 'xlsx')
SELECT *
FROM file('{input_file}', 'parquet')
''')

Confirm the conversion was successful:

print(f'Successfully converted {input_file} to {output_file}')

For more complex conversions or when you need to transform the data during conversion, you can use a table:

First, create a table from the input file:

# Create a table from the input file
client.command(f'''
CREATE TABLE IF NOT EXISTS conversion_data AS
SELECT * FROM file('{input_file}', 'parquet')
''')

Then, perform any transformations and export to the destination format:

# Now you can perform transformations if needed
client.command(f'''
INSERT INTO FUNCTION file('{output_file}', 'xlsx')
SELECT * FROM conversion_data
# Add WHERE, GROUP BY, or other clauses as needed
''')

Finally, clean up by dropping the temporary table:

# Clean up
client.command('DROP TABLE IF EXISTS conversion_data')
print(f'Successfully converted {input_file} to {output_file}')
by @scottpaulin