Free tool, runs in your browser

SQL Studio.

Attach an extract of your database, or any spreadsheet, and get exactly the output you need. Choose what you want; SQL Studio writes the SQL and shows the result instantly.

Nothing uploadedNothing storedFree, no sign-up
CSVXLSXTSVXLS

Drop your CSV or Excel files here

An extract from your database, or any spreadsheet you want in a better shape. Add two files to join them.

Your files are read on this device. Nothing is uploaded or stored.

Your tables

Each file becomes a table you can query.

Build your output

Choose what you need. The SQL writes itself and the result updates instantly.

Quick recipes:
1Table and joinsStart from a table, optionally join anotherOn
2ColumnsPick, order and rename the columns you wantOn
3Calculated columnsTotals, ratios, year or month of a date, textOn
4Filter rowsKeep only the rows you needOn
5Group and summariseTotals, averages and counts by groupOn
6ReshapeRows to columns, or columns to rowsOn
7Sort and limitOrder, remove duplicates, top NOn

Your SQL

Readable SQL, written for you. Copy it into your own database.

Ctrl or ⌘ + Enter runs your edited SQL

Result

1
Drop a fileCSV or Excel, from anywhere
2
Choose what you needColumns, filters, totals, pivots
3
Download or visualiseCSV, Excel or Data Canvas

What you can do.

Six everyday jobs, each a couple of taps away. Mix them freely.

Choose and rename columns

Keep only what you need, in the order you want, with clear names.

Filter rows

Only London, only this year, only orders over £100: any rule you like.

Totals by group

Sum, average, count or find the highest and lowest, for every region, product or month.

Rows to columns

Pivot a long list into a tidy table, like one column per month.

Columns to rows

Turn a wide spreadsheet into a long list, ready for charts and databases.

Join two files

Match orders with customers, or sales with targets, on a shared column.

Why it's useful.

The output you need, in seconds

Pick columns, filters, totals and pivots from simple menus. No formulas and no database to set up.

Learn SQL as you go

Every choice writes clean, readable SQL you can copy into Snowflake, PostgreSQL, BigQuery or your own database.

Reshape anything

Turn rows into columns and back, join two files on a key, add calculated columns, and keep only the rows that matter.

See it in action.

A real example, from messy input to the output you need.

Your file

dateregionproductunits
2026-01-04NorthEspresso3
2026-01-09LondonCroissant5
2026-02-02NorthCroissant2
2026-02-11LondonEspresso4

“Total units per region, with one column per month.” Recipe used: Rows → columns.

Your result

region2026-012026-02
London54
North32

Private by design.

Your data never leaves your device. There is no server to send it to, no account and nothing to store it in.

  • Nothing is uploadedFiles are opened by your own browser, on your own device. They never travel over the internet.
  • Nothing is storedClose the tab and your data is gone. There is no database, no account and no copy kept anywhere.
  • No tracking, no AINo analytics scripts, no cookies and no AI services see your data. The engines run locally.
  • Safe for work filesBecause nothing leaves your device, you can use it with confidential spreadsheets and database extracts.

Better together.

Every tool can send its result straight to the others. Clean it, query it, then see it.