Table cleaner — merge CSV/Excel files, remove duplicates, fix phones, e-mails and dates

1. Files

One or several CSV / XLSX files (customer lists, orders, exports from different systems). The header row is found automatically, columns are recognised by name and content. Files are deleted after 24 hours.

Choose files or try the samples: CRM export + shop orders (messy) crm_export.csv shop_orders.xlsx

2. Columns and rules

Remove duplicates by e-mail phone id similar names (+ company) Keep Phones without country code are from fix NAME CASE

3. Result

Download clean.xlsx Download clean.csv XLSX sheets: Clean (flagged cells highlighted), Duplicates, Issues, Report

Clean data (first rows)

Removed duplicates

Flagged values

API for your systems

curl -F files=@crm.csv -F files=@orders.xlsx https://clean.2-29-27-177.sslip.io/api/analyze          # → {"job":"…","files":[{"columns":[…]}]}
curl -X POST https://clean.2-29-27-177.sslip.io/api/run -H 'Content-Type: application/json' \
     -d '{"job":"…","dedupe_by":["email","phone"],"country":"UA","keep":"merge"}'  # → {"stats":{…},"xlsx":"/files/…/clean.xlsx"}

Add API_TOKEN to .env to protect the API. Limits: 50000 rows per file, 10 files per job.