Workflow

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.

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. 1. JSON ⇄ CSV Convert your export between JSON and CSV if needed.
    This step produces: Die umgewandelte Liste
  2. 2. Remove duplicates Remove duplicate lines from your list.
    This step produces: Die Liste ohne Duplikate
  3. 3. Sort lines Sort the lines alphabetically ascending or descending.
    This step produces: Die sortierte Liste
  4. 4. Check patterns Test a regex pattern against your data to filter lines.
    This step produces: Das geprüfte Muster
  5. 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

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.