WAVESPEED AI DATA EXPLORER Your data stays on your device

100% FREE

Free Data ExplorerAnalyse big spreadsheets and data files in your browser.

Open CSV, Excel, JSON, Parquet and SQLite files with millions of rows. See every column’s type and range, then sort, filter, group, pivot and chart without writing code.
Or write SQL. Save any result as CSV, Excel, Parquet or JSON.

Millions of rowsPivot, SQL and chartsNo upload

No sign-up No upload No watermark

Loading the data explorer…

Files are read and queried in this browser tab. Nothing is uploaded.

THREE SIMPLE STEPS

How to explore a data file

Open your files

Drop CSV, Excel, JSON, Parquet or SQLite files, or paste cells copied from a spreadsheet. Each file (or sheet, or database table) becomes a table, with its columns profiled.

Sort, filter, summarise

Click headers to sort, type in the filter row, group and pivot with the builder, or write SQL. Switch any result to a chart.

Save the result

Download what you see — filters and sort included — as CSV, Excel, Parquet or JSON, or the chart as PNG or SVG.

What you can do

Open big files

CSV and TSV with the separator, header and types detected, Excel workbooks (every sheet), JSON arrays and JSON lines, Parquet and SQLite databases. Several files at once.

Know your columns

Each column’s type, how many cells are empty, roughly how many distinct values it has, and its lowest and highest value.

A grid that keeps up

Scroll through millions of rows smoothly. Sort by one or several columns, filter each column (contains, =, >, ranges, dates by year or month) and search every column at once.

Group by and pivot

Pick rows, an optional column field and values (sum, average, count, distinct count, min, max, median). Dates group by year, quarter, month, week or day. Subtotals on request. The SQL it writes is one click away.

SQL when you need it

A full analytical SQL engine: joins across your files, window functions, CTEs, PIVOT. Ctrl+Enter runs, errors are shown as they come, and your recent queries are kept.

Charts and exports

Bar, line, area, scatter, pie and histogram from any result, saved as PNG or SVG. Results download as CSV, Excel, Parquet or JSON.

Tips

Join two files

Open both, then in SQL write: SELECT * FROM orders JOIN customers USING (customer_id). Table names come from the file names.

Filter syntax

In a filter box: >1000, 10..20, !=0, =Europe (exact), !test (excludes), ^North (starts with), 2024-03 (that month), a|b (either). A lone = finds empty cells.

Convert formats

Open a file and download it in another format: CSV to Excel, JSON to CSV, Parquet to CSV, Excel to Parquet. Filters and sort apply to the download.

Chart a summary

Charts draw up to 5,000 points. For long data, group it first (for example revenue by month) and chart that result.

WaveSpeed AI

Need visuals for your report?

Turn your findings into images and video with WaveSpeed AI.

Start creating Explore 1,000+ AI Models

1,000+ AI models
Image, video and 3D
Pay as you go

$1 in free credits for eligible new accounts. No card needed. Generators have separate account and credit requirements. The data explorer is free.

Data Explorer FAQ

Is this data explorer free?

Yes. No account, no row limit set by us, no watermark and no paid tier.

Are my files uploaded?

No. Files are read and queried by an analytical database engine running inside your browser tab. The page downloads the engine once (about 7 MB); your data never leaves your device.

How big a file can it open?

There is no limit set by us: your device’s memory decides. On our test computer a 150 MB CSV with 1 million rows opened in about 3 seconds and a group by over it took 0.2 seconds; a 1.2 GB CSV with 8 million rows opened in about 15 seconds, and a 300,000-row Excel file in about 2. A browser tab gives the engine at most about 4 GB, so CSV, Excel or JSON files of several GB will not fit; Parquet is read on demand, so larger Parquet files can still be browsed and summarised. Phones and older laptops are slower and have less memory.

Which file types can I open?

CSV and TSV (any separator), Excel .xlsx and .xls (every sheet), JSON arrays, JSON lines (.ndjson, .jsonl), Parquet and SQLite (.sqlite, .db). You can also paste cells copied from a spreadsheet.

Can I combine several files?

Yes. Every file, sheet or database table you open is a table. Join, union or compare them in SQL, for example SELECT * FROM sales JOIN targets USING (region).

What SQL does it support?

A complete analytical SQL dialect (it is the same as DuckDB’s): joins, GROUP BY with ROLLUP, window functions, CTEs, PIVOT and UNPIVOT, regular expressions, date functions and more. Tables you create in SQL appear in the table list.

Can I save my work?

Your SQL and query history are kept in this browser. The data itself is not stored: after a reload, open your files again. Download results you want to keep.

What does it not do?

It is a single-user analysis tool, not a dashboard server: there are no scheduled refreshes, live database connections, shared dashboards or formulas that recalculate like a spreadsheet. Charts draw up to 5,000 points; summarise bigger data first. Excel files lose their formatting, formulas (values are kept) and charts when opened.

All Free Tools

Your data, answered in seconds.

Free, private and fast — nothing to install.

Open a file

Free Data ExplorerAnalyse big spreadsheets and data files in your browser.