About ETL Studio
ETL Studio is a free, browser-based data preparation tool powered by DuckDB WASM. Clean, filter, transform, and analyze your data entirely in your browser — 100% private, with nothing ever uploaded to any server.
Key Features
- 100% private — your data never leaves your device. No upload, no server, no account needed.
- Powered by DuckDB WASM — a full SQL analytics engine running in your browser via WebAssembly.
- No installation — works in any modern browser. Open the page and start working immediately.
- Multiple data sources — load CSV, Parquet, JSON, and other formats directly from your local files.
- SQL transformations — filter, aggregate, join, and reshape your data using standard SQL.
- Visual data exploration — browse, sort, and preview your datasets before and after transformations.
- Export results — download cleaned and transformed data in your preferred format.
- Open source — built with DuckDB WASM and modern web technologies.
Use Cases
- Data cleaning — remove duplicates, handle missing values, standardize formats.
- Data transformation — pivot, aggregate, join datasets, and create calculated fields.
- Quick analysis — run ad-hoc SQL queries on your data without setting up a database.
- Prototyping — explore and prepare data before moving to production pipelines.
- Privacy-sensitive work — handle sensitive data that cannot be uploaded to cloud services.
How It Works
ETL Studio loads DuckDB — a high-performance, embeddable SQL OLAP database — directly in your browser via WebAssembly. When you load a file, it's read locally and imported into an in-memory DuckDB database. All SQL queries and transformations run on your machine. Nothing is sent over the network. When you're done, export your results as a file download.
Privacy
Your data never leaves your device. There is no server, no analytics, no accounts, no tracking. ETL Studio is a purely client-side application — all processing happens in your browser's WebAssembly runtime.
License
MIT — do whatever you want. Attribution appreciated.