Clean Up CSV & JSON Data
Clean up an export: convert between CSV and JSON, remove duplicates, sort, and test with regex. All runs in your browser.
Your progress is stored only in your own browser (localStorage) and is not transmitted to our servers. Third-party resources (e.g. advertising and analytics from Google/Cloudflare) may transfer data when loaded.
What you get at the end
A clean, deduplicated and sorted list as CSV or JSON.
Why these steps in this order
Format first, then clean, then check. Duplicates and sorting get clearer once the format is set.
This workflow guides you through the following steps:
-
1.
JSON ⇄ CSV
Convert your export between JSON and CSV if needed.
This step produces: Die umgewandelte Liste -
2.
Remove duplicates
Remove duplicate lines from your list.
This step produces: Die Liste ohne Duplikate -
3.
Sort lines
Sort the lines alphabetically ascending or descending.
This step produces: Die sortierte Liste -
4.
Check patterns
Test a regex pattern against your data to filter lines.
This step produces: Das geprüfte Muster -
5.
Format the result
Format the result cleanly at the end.
This step produces: Das formatierte Ergebnis
Your final check
- I converted JSON and CSV.
- I removed duplicates.
- I sorted the lines.
- I checked patterns.
- I formatted the result.
Interactive workflow loading …
More background
Understand formats: CSV, JSON and more
Frequently asked questions
Where is my data stored?
Your playbook progress is saved in your own browser using localStorage. Nothing you enter is uploaded to our servers. Clearing your browser data resets the workflow.