CSV Data Cleaner & Profiler
Pricing
Pay per usage
CSV Data Cleaner & Profiler
Clean and profile your own CSV/JSON: normalize emails, phones, dates and amounts, remove duplicates, flag bad rows, and get a quality report plus an XLSX file.
Pricing
Pay per usage
Rating
0.0
(0)
Developer
Clean Cell Co.
Maintained by CommunityActor stats
0
Bookmarked
2
Total users
1
Monthly active users
6 days ago
Last modified
Categories
Share
Clean and profile your own CSV or JSON data: trim and normalize text, standardize emails, phones, dates and currency amounts, remove duplicates, flag bad rows, and get a column-by-column quality profile.
Works only on data you supply. It doesn't crawl, scrape or log in to anything.
Input
csvText: paste a CSV (header row required), orrows: an array of JSON objects, orcsvUrl: a direct public http(s) link to your own file. One single download: no redirects followed, no crawling, 50 MB cap, 60-second limit. Private, local and internal addresses are blocked, including the address actually connected to.- Options:
dedupeKeys,requiredColumns,normalizeColumns,columnTypes,dateFormat,delimiter,dropEmptyColumns,xlsxOutput.
Output
| Where | Content |
|---|---|
| Dataset | Cleaned rows |
Key-value store CLEANED_CSV / CLEANED_XLSX | Cleaned file |
REJECTED | Rejected rows with reasons |
REPORT | Column profile before/after, normalization stats |
OUTPUT | Summary counts |
Spreadsheet-safe output. In CLEANED_CSV, any text cell (header included) that starts with =, +, -, @, a tab or a carriage return gets a single leading ', so Excel, LibreOffice and Google Sheets show it as text instead of running it as a formula. Plain numbers such as -20.5 or +15551234567 are not changed. If you need the exact raw text, strip a leading ' from those cells, or use the dataset or CLEANED_XLSX. In CLEANED_XLSX, text is always stored as literal text (never a formula), and currency amounts and number columns stay real numbers, negatives included.
Privacy and data retention
Your data stays only in this run's own Apify storage (its default dataset and key-value store). The Actor keeps no copy anywhere else and sends your data nowhere. Apify's standard data retention for your plan applies to that run storage; delete the run's storage yourself if you want it gone sooner. Don't include data you aren't allowed to process.
Pricing
Free during launch; pricing may be added later with notice.
Disclaimer
Automated cleaning can be wrong. Review the report and rejected rows before using the output.
