CSV Cleaner
See what Excel would break in your CSV, then clean it once and every month
See the cells Excel would change, then clean CSV exports on your PC: every change listed, and an .xlsx that keeps 00123 as written.
What it does
CSV Cleaner opens the CSV exports that shops, CRMs, banks and newsletter tools produce and profiles every column: what it holds (dates and their order, numbers and their decimal mark, phone numbers, email addresses) and what is wrong with it, including the cells Excel would change when it opens the file: 00123 becomes 123, an 18-digit order number loses its last digits, MARCH1 becomes a date. It suggests the clean-up from that profile, and every step can be changed, reordered or switched off. Every changed cell is listed before anything is saved. The cleaned file is a new CSV, or an Excel file in which every cell stays exactly as written, with a change log next to it. The steps can be saved as a recipe and run on next month's export or a whole folder of exports; a file that does not fit the recipe is stopped before anything is written.
Screenshots
No public screenshots yet. Screens from evaluation builds are not published.
The problem it solves
Excel changes a CSV export when it opens it (leading zeros dropped, long order numbers cut, codes turned into dates), and cleaning the same export by hand every month is slow and error-prone.
Who it is for
Shop owners, marketers, bookkeepers and analysts.
Features being evaluated
- Names the cells Excel would change: 00123 to 123, long order numbers cut, MARCH1 to a date
- Saves an Excel (.xlsx) file that keeps every cell exactly as written
- Every column profiled; clean-up suggested: spaces, garbled characters, dates, phones, emails, duplicates
- Date order decided once per column, never guessed per cell; invalid dates kept and listed
- Split, merge, rename and reorder columns
- Every changed cell listed before saving, with a change log CSV
- Recipes for next month's export or a folder of exports, checked before anything is written
- The original is only read and nothing is overwritten
More in this category
Follow AGI TOOLS on Telegram
The store will open in the Telegram bot first. Today it is a closed preview with no sales.