01 · Query
Turn the file into a working answer.
Write browser-supported DuckDB SQL with multi-tab queries, schema autocomplete, and one-click execution. Use joins, CTEs, and window functions, then export results to Parquet, CSV, or JSON.
Private by default. No account required.
Inspect rows, schema, and metadata, then query with browser-supported DuckDB SQL or optional BYOK AI. Open local files, S3 objects, and URLs with no install or account.
Local file contents are not uploaded to viewparquet for viewing or SQL
How to view a Parquet fileOne dependable path from file to answer
Verified bundled sample
The included flights-200k.parquet file is committed with the site. We inspected its Parquet metadata and decoded it locally, then used the query shown here to check the row counts and averages. You can open or download that exact file.
Last verified . DuckDB types: delay SMALLINT, distance SMALLINT, time FLOAT.
See the public dataset verification notes and how viewparquet verifies product claims.
SELECT
CASE WHEN distance < 500 THEN 'short'
WHEN distance < 1500 THEN 'medium'
ELSE 'long' END AS haul,
ROUND(AVG(delay), 2) AS avg_delay,
COUNT(*) AS flights
FROM data
GROUP BY 1
ORDER BY 2 DESC;| haul | avg_delay | flights |
|---|---|---|
| short | 8.96 | 157,291 |
| medium | 6.20 | 67,015 |
| long | 1.31 | 6,777 |
01 · Query
Write browser-supported DuckDB SQL with multi-tab queries, schema autocomplete, and one-click execution. Use joins, CTEs, and window functions, then export results to Parquet, CSV, or JSON.
02 · Inspect
Move through large result sets in a virtualized grid, inspect types and column statistics, find values in loaded rows, or filter the complete dataset with DuckDB. Practical limits depend on browser memory, the query, and result size.
03 · Ask
Describe what you need and the assistant drafts queries, explains your schema, and suggests fixes using the context you allow. Bring your own OpenRouter key, review sharing controls in Settings → AI, and verify generated SQL before using its results.
04 · Control
Local file processing runs in your browser with DuckDB-WASM, and remote object data is not proxied through viewparquet. Open from disk, S3, or a URL with keys that stay local. Optional AI is explicit and BYOK goes browser-to-provider.
See the privacy proofRemote data
Open a public HTTPS link, presigned URL, or s3:// object without proxying it through viewparquet. When the endpoint supports HTTP range requests, DuckDB can fetch portions of the Parquet object directly while private-bucket credentials stay in this browser. Actual transfer depends on the query, file layout, codecs, and endpoint.
Parquet guides
Direct, practical guides for opening, inspecting, converting, and querying Parquet files.
Browse rows, inspect column names and types, and run SQL without an install.
ConvertFilter the rows and columns you need, then export a spreadsheet-friendly CSV.
ConvertPreserve nested structs and lists in a local JSON Lines export.
ExcelExport the rows you need as CSV, then open that file in Excel. No .xlsx export.
S3Read public, presigned, or private objects directly from your browser.
SpatialInspect the attribute table, schema, and raw geometry column values.
Need a quick answer? Browse the Parquet FAQ.
Formats
Purpose-built for columnar files, with CSV and JSON supported when you need them, all processed locally in DuckDB-WASM.
Native columnar
First-classWith geometry
First-classAuto-detected schema
SupportedTab-delimited
SupportedObjects or arrays
SupportedOne record per line
SupportedFAQ
Got questions? Here are the most common ones about viewparquet.
Local datasets are processed with DuckDB WASM and are not uploaded to viewparquet. Remote reads go directly from your browser to the bucket or URL. Optional AI sends your messages and applicable context directly to your configured BYOK provider; sharing controls cover preloaded schema, profile fields, and samples, while chat tools and saved AI context may also provide structural metadata or SQL.
Yes. The SQL editor supports browser-available DuckDB syntax with multi-tab queries, schema autocomplete, and exports. The AI assistant can draft queries, explain schema, and suggest fixes using the context you allow. Review generated SQL before using its results.
Add your own OpenRouter/provider key for BYOK mode. Data-sharing presets control preloaded column names, types, metadata, and sample values. Your messages are always sent, and chat tools or saved AI context may also provide structural metadata or SQL.
Parquet and GeoParquet are first-class formats for the fastest path. CSV, TSV, JSON, and JSON Lines are also supported as secondary formats.
There is no fixed product cap, but browser and WebAssembly memory, your device, the file format and layout, codecs, and the query all affect what will open successfully. Parquet uses a view-based loading path and a paginated grid to avoid an intentional full-table copy up front; CSV and JSON still need more materialization.
Yes. Open data from a public HTTPS or presigned URL, a public s3:// object, or a private bucket using in-browser access keys (or temporary STS tokens), plus S3-compatible stores like Cloudflare R2, Google Cloud Storage, and MinIO. When the endpoint supports HTTP range requests, DuckDB can fetch portions of Parquet directly; actual transfer depends on the query, file layout, codecs, and endpoint. Credentials stay in your browser and never pass through viewparquet servers.
Working with Parquet files? See the full Parquet FAQ : how to open, view, query, and convert Parquet.
Learn & Explore
AI data pipelines, Parquet for LLM workloads, DuckDB, and columnar analytics.
A field guide to grounding generated SQL in the real Parquet schema, DuckDB dialect, read-only code gates, privacy contr…
Read moreA hands-on guide to separating wrong bytes, missing footers, damaged pages, reader incompatibility, remote access failur…
Read moreQuery Parquet on AWS S3, Cloudflare R2, GCS, or MinIO without proxying object data through viewparquet. Compatible endpo…
Read more