List Dedupe
Paste messy rows from spreadsheets, tickets, exports, or notes, then keep the first copy of each item and remove repeated lines.
Matching rules
These controls map directly to the list-dedupe API options.
Sample lists
Load a realistic paste shape without changing the selected matching rules.
Cleaned output
Waiting for the current dedupe result.
Dedupe totals
Counts come from the API response.
Input rows
7
8 pasted lines
Kept items
-
Output updates after the API run.
Duplicate rows
-
Rows repeated after matching.
Removed items
-
Run dedupe to see which repeated values were removed.
Kept items
Unique items will appear after dedupe runs.
No kept items to show yet.
Removed items
Run dedupe to see which repeated values were removed.
Duplicate items will appear after dedupe runs.
What gets removed
The API normalizes Windows and Unix newlines, applies the selected whitespace and case rules, ignores empty rows after that cleanup, keeps the first matching item, and skips later matches. Sorting only changes the final kept output order.
CSV to JSON
Convert CSV rows into formatted JSON records.
openCSV Summary
Profile CSV data with row counts, column stats, missing values, unique counts, and numeric summaries.
openJSON to CSV
Convert JSON objects or arrays into copy-ready CSV, semicolon, or TSV output.
openJSON Path Extractor
Extract a nested value from JSON with simple dot and bracket paths.
open