Convert Parquet to JSON

Convert Parquet to JSON in seconds with this free online Parquet to JSON converter

Accepts parquet


Parquet

Apache Parquet (.parquet) is a format that was designed for storing tabular data on disk. It was designed based on the format used in Google's Dremel paper (Dremel later became Big Query).

Parquet files store data in a binary format, which means that they can be efficiently read by computers but are difficult for people to read.

Parquet files have a schema, so means that every value in a column must have the same type. The schema makes Parquet files easier to analyse than CSV files and also helps them to have better compression so they are smaller on disk.

JSON

Java Script Object Notation (JSON) is a format that was designed for use with the Javascript Programming Language.

JSON files do not have a schema or required columns. Each row can have different field names and types. This can

make JSON files difficult to analyze.


Supercharge your data exploration

Open csv, parquet, arrow, json and tsv files straight from your desktop

Or


Share and embed

Share your graphs and data sets.

Share your graphs and data sets. Or embed them directly into web pages.


Work straight from Google Drive

Open csv, parquet, arrow, json and tsv files directly from Drive, Gmail and Classroom by installing the Google Workspace App


How to Convert Parquet to JSON

Viewing converted data
  1. Select your input Parquet file
  2. Your Parquet file will be converted to JSON
  3. Download your JSON file
  4. Click the View button to view your file

How to Convert Parquet to JSON in Python

We can convert Parquet to JSON in Python using Pandas or DuckDB

How to Convert Parquet to JSON 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 JSON format

df.to_json('path/to/file.json', index=False)

How to Convert Parquet to JSON 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 JSON file

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

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.json' (FORMAT 'json')""")