CSV cleaner for messy columns
Exports from CRMs, payment tools, and forms come with inconsistent capitalization, stray spaces, mixed date formats, and full names in one cell. SheetSense cleans one column at a time from an instruction written in plain English, and shows a before and after diff of the rows it would change.
Nothing is written until you click Apply. You can rewrite the column in place, write the result to a new column next to it, or split one column into two to four columns. The last apply can be undone.
Worked example: split a full name
Column Name holds values such as ada LOVELACE and Grace Hopper (with a doubled space). The instruction is: split into first name and last name, proper case.
Name First name Last name
ada LOVELACE Ada Lovelace
Grace Hopper Grace HopperThe preview lists each row that would change, with the original value beside the new values, and you can include unchanged rows if you want to check them. Review a few rows with unusual names before applying, since a rule that works for two-word names can misplace middle names and suffixes.
How it works
- 01Upload a CSV or Excel file, up to 15 MB. The first 5,000 rows and 50 columns are kept.
- 02Select the column and choose the clean action.
- 03Describe the change and pick in place, new column, or split.
- 04Read the before and after preview, then click Apply. Download the result as CSV.
Common questions
- Is my file uploaded to a server?
- The file is parsed in your browser. When you run an action, the selected column is sent to the AI service. Stored sheets are private to your account.
- Does it work on the whole file at once?
- One column per action. Run it again for the next column.
- How many cleanups are free?
- A free account includes 10 AI actions and a sample dataset. After that you need a paid plan, shown on the pricing section of the home page.
Try it on your own formula
The Formula Translator is free for 5 formulas a day, with no account.