SmartQueryTools

Parquet File Inspector

Drop a Parquet file to instantly view its schema, column types, row count, and a data preview. Uses DuckDB-WASM — runs entirely in your browser with no upload required.

Loading DuckDB engine…

Drop your .parquet file here

or click to browse · max 50 MB

How to use the Parquet File Inspector

  1. Drop a .parquet file onto the drop area, or click it to browse. Files up to 50 MB are supported.
  2. Wait a moment while the file is read. Nothing is uploaded, so the time depends on your device and the file size.
  3. Read the File Overview cards for the total row count, the number of columns, and the file name.
  4. Check the Schema table. It lists every column in order with its data type and whether it allows nulls.
  5. Scroll to the Data Preview to see the first 5 rows and confirm the values look right.

Worked example

A sales export saved as Parquet by a data pipeline. You want to confirm the columns and types before loading it somewhere else.

Input (sales.parquet, shown as a table)

sales.parquet  (1,250 rows, 4 columns)

order_id  order_date  region  amount
1         2024-03-01  North   120.00
2         2024-03-01  South   85.50
3         2024-03-02  North   42.25
...

What the inspector shows

File Overview
  Total Rows: 1,250    Columns: 4    File: sales

Schema
  #  Column Name  Data Type      Nullable
  1  order_id     BIGINT         YES
  2  order_date   DATE           YES
  3  region       VARCHAR        YES
  4  amount       DECIMAL(10,2)  YES

Data Preview (first 5 rows)
  order_id  order_date  region  amount
  1         2024-03-01  North   120.00
  2         2024-03-01  South   85.50
  3         2024-03-02  North   42.25
  ...

The row count comes from counting every row in the file. The schema shows the logical type of each column, so the amount column appears as DECIMAL(10,2) rather than as raw bytes. Parquet columns are usually optional, which is why Nullable reads YES.

Why inspect a Parquet file first

Parquet is a binary, column-based format. You cannot open it in a text editor to see what is inside. The schema is stored in the file itself, so every column already has a fixed type.

That makes a quick inspection useful before you load a file into a database or a notebook. You can confirm the column names match what your code expects, check that dates are real DATE or TIMESTAMP columns and not text, and see whether money is stored as DECIMAL or as floating point.

The row count also helps you spot a truncated export. If a daily file normally holds about a million rows and this one holds a few thousand, the job that wrote it may have failed partway.

Frequently Asked Questions

How do I open a Parquet file without Python or Spark?

Drop it on this page. The file is read in your browser, so you do not need to install pandas, pyarrow, Spark or any desktop app. For a full scrollable table, use the Parquet Viewer. To get a spreadsheet, use Parquet to CSV or Parquet to Excel.

How do I check the schema of a Parquet file?

The Schema table on this page lists each column name, its data type, such as BIGINT, DOUBLE, VARCHAR, DATE, TIMESTAMP or DECIMAL, and whether it allows nulls. Nested columns appear as STRUCT or LIST types.

Does it show row groups, compression or file metadata?

No. The inspector shows the row count, column count, schema and a 5 row preview. It does not list row groups, compression codecs, page sizes or key-value metadata stored in the file footer.

Can I see more than 5 rows?

Not on this page. Open the file in the Parquet Viewer to browse the rows, or load it into the SQL Query Tool to filter and sort it.

Is my Parquet file uploaded?

No. The file stays on your computer and is read inside the browser tab.

Related tools