Spreadsheet and data tools for analysts and ops teams
Two exports that should match but don't? A messy list you need to tidy before a report? These tools compare, clean and reconcile spreadsheet data right in your browser — no formulas, no scripts, and nothing you paste ever leaves your computer.
Compare two spreadsheets → Run the CSV cleaner →
Launch a tool
Tip: press 1–8 to open one- 1CSV Join / MergeJoin, merge, and compare CSV files by key.
- 2CSV ViewerPreview, auto-detect delimiter, trim, export.
- 3List ComparatorDiff two lists, find unique / common items, duplicates.
- 4SQL IN BuilderBuild and chunk large SQL IN(...) clauses safely, with dialect-aware quoting.
- 5CSV → SQLGenerate INSERT / UPSERT statements from CSV.
- 6JSON ↔ CSVBidirectional conversion with auto-format detection.
- 7SQL FormatterFormat SQL with indentation and keyword casing.
- 8Line ToolsTrim, dedupe, sort, filter, wrap, prefix / suffix, join — filter before or after transforms.
Run a workflow right here
Runs locally — nothing is uploadedCSV Cleaner to JSON
Trim cells, drop empty rows, normalize headers, and export the CSV as JSON records.
csv-viewer 1 step · Runs automaticallyCSV Export Secret Scan
Turn a CSV export into JSON records and scan it for tokens, keys, and credentials.
csv-viewer → secrets-scanner 2 steps · Runs automaticallyCSV Fingerprint (SHA-256)
Normalize a CSV to JSON records, then hash it to a stable SHA-256 digest for comparison.
csv-viewer → hash-generator 2 steps · Runs automaticallyTrack a checklist
Progress is saved on this deviceDaily tasks, guides & FAQ
Common daily tasks
- Compare last month's export with this month's and see exactly what changed
- Find which rows are in one file but missing from the other
- Clean up a messy list — remove blanks, trim spaces and drop duplicates
- Turn a column of IDs into a filter you can paste into a database query
- Open a large CSV and sort or search it without Excel choking
- Reconcile two reports before you send the numbers upstairs
Recommended workflows
- CSV cleaner — tidy up a spreadsheet export in one step.
- JSON to spreadsheet — turn a JSON export back into a CSV you can open in Excel.
- Column to database filter — clean a column and build a ready-to-paste IN (...) filter.
Top tools
CSV Compare
Compare two spreadsheet exports by a shared column and see which rows were added, removed or changed.
Compare spreadsheets →CSV Viewer
Open, sort, search and filter a large CSV in a clean table — no spreadsheet app needed.
Open a CSV →List Comparator
Paste two lists and instantly see what is unique to each and what they share.
Compare two lists →Database Filter Builder
Paste a column of values and get a ready-to-use IN (...) filter for a query.
Build a filter →See all the data cleanup tools →
Why "in your browser" matters for your data
Analyst and ops work often means handling exports full of real customer names, emails and account numbers. Tool input is processed in this browser and is not sent by DDT tools. DDT runs no browser analytics scripts, sets no tracking cookies, and collects no browser product events. The CDN handles ordinary page requests and provides aggregate traffic counts. That means you can compare and clean sensitive reports without uploading them to an online converter or a third-party site.
FAQ
Do I need to know how to code to use these?
No. Everything here is paste-and-click. You paste in a spreadsheet or a list, pick an option, and copy the result — there are no formulas to write and nothing to install.
Is my spreadsheet uploaded to a server?
No. Tool input is processed in this browser and is not sent by DDT tools. DDT runs no browser analytics scripts, sets no tracking cookies, and collects no browser product events. The CDN handles ordinary page requests and provides aggregate traffic counts. Your exports and customer data stay on your own computer.
How do I see what changed between two exports?
Open CSV Compare, paste both files and pick the column they share (like an ID or email). It shows you the rows that were added, removed or changed between the two.
My export is too big for Excel - can I still open it?
Yes. The CSV Viewer opens large files in a searchable, sortable table right in the browser, so you can inspect them without Excel slowing down.
Related
- Data / QA engineers — the same tools with a more technical framing.
- CSV reconciliation checklist — a step-by-step review before you trust the numbers.
- Data cleanup tools — the full set.
- Compare two CSV files by key