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.
This workflow guides you through the following steps:
- 1. JSON ⇄ CSV Convert your export between JSON and CSV if needed.
- 2. Remove duplicates Remove duplicate lines from your list.
- 3. Sort lines Sort the lines alphabetically ascending or descending.
- 4. Check patterns Test a regex pattern against your data to filter lines.
- 5. Format the result Format the result cleanly at the end.
Interactive workflow loading …
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.
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.