About CSVFiddle- CSVFiddle is a free tool to explore and share insights from CSV files using SQL
- You can import data, write SQL, then instantly share it with anyone
- Everything runs 100% in-browser, so the data you import and the queries you write are never sent to a web server
Features- Fast, Flexible Querying - CSVFiddle querying is powered by DuckDB-Wasm, a WebAssembly implementation of the popular OLAP database, DuckDB. Any SQL you can run in DuckDB should be able to run in CSVFiddle.
- Assisted Editing - The SQL editor features autocomplete for common SQL keywords/snippets and the table names/columns imported into a workspace.
- Instant Sharing - Click 'Share Workspace' in CSVFiddle to generate a link you can share with anyone. Queries and references to CSV data are encoded in the URL fragment, so the data are never sent to CSVFiddle servers.
Frequently Asked Questions- How do I save my work? - Because the queries you write and the references to CSV data are encoded in the URL fragment, you can just bookmark the page to come back to it later.
- Why didn't my CSV file get parsed correctly? - Currently, CSVFiddle relies on DuckDB's autoparse feature, which makes an educated guess about how to parse a file. This may not work well for CSV files that deviate from a "typical" format.
- Can I use it on mobile? - CSVFiddle is designed to be a desktop experience, so not all features are guaranteed to work well on mobile browsers.
- What analytics data do you collect? - CSVFiddle uses Plausible Analytics to collect basic web traffic data. Note that only host and pathname from URLs are logged, so workspace data encoded in the URL fragment are excluded from logging.
- Why is it called CSVFiddle? - The name is inspired by JSFiddle, a popular tool to write HTML/CSS/Javascript snippets in a sandbox environment. CSVFiddle is like JSFiddle for CSV/SQL.
- Who made this? - CSVFiddle was made by @shubroski in NYC.