How to use the Data Studio
- 1 Drop one or more files on the studio, or paste text. CSV, TSV, TXT, Markdown, JSON, XML and Excel (.xlsx) are supported.
- 2 Check how the file was read under Source – the encoding and delimiter are detected, and you can change them.
- 3 Add steps such as removing duplicates, merging files or flattening JSON. The preview shows the data before and after every step.
- 4 Export as CSV, Excel, JSON, XML, Markdown or text. Save the steps as a recipe to run the same clean-up next time.
One workspace instead of ten tools
Cleaning a file usually takes several small jobs: fix the encoding, drop the empty rows, remove duplicates, merge it with another file, convert the result. In the Data Studio these are steps in one pipeline. Each step works on the result of the one before it, so you never download an intermediate file and upload it again.
Every step has a preview. Select a step to see the data before and after it, how many rows changed, and anything the step could not keep – for example a null that became an empty cell. Steps only connect when their data fits: a table step cannot be added after a JSON step until you have converted the JSON into a table.
What it can do
- Tables and CSV: detect and change the delimiter and character encoding, clean column names, select, rename and reorder columns, remove blank rows and columns, remove duplicates, filter, sort, split and combine columns, convert European number formats, restore leading zeros.
- Several files: merge files with different columns, join on a key, compare two tables.
- JSON and XML: format, flatten into a table, rebuild nested JSON, validate against a JSON Schema, compare ignoring volatile fields, convert between XML and JSON.
- Text: clean spaces and line breaks, turn text into a table, extract fields from text, compare two texts, convert plain text to Markdown.
Private by design
The files are read and transformed by code that runs in your browser, in a background worker. Nothing is uploaded. Only the steps you choose are remembered, on this device, and – if you turn it on in your account – on your other devices. The files themselves are never synced.
Limits
Files can be up to 25 MB each and 100 MB in the workspace. PDF and Word files are not supported yet. Everything is converted exactly as far as the target format allows; when a step cannot keep something, it says so.
Frequently asked questions
Are my files uploaded?
No. The studio reads and transforms your files in your browser. There is no upload and no server-side copy.
What file types can I open?
CSV, TSV, TXT, Markdown, JSON, XML and Excel (.xlsx). PDF and Word files are not supported yet.
Do I need an account?
No. Everything works without one. An account only adds saving results to My files and syncing your saved recipes between devices.
Can I repeat the same clean-up on next month’s file?
Yes. Save the pipeline as a recipe and load it again; add the new file and the same steps run on it.
Last updated: