SheetSense

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.

Result in two new columns
Name              First name   Last name
ada LOVELACE      Ada          Lovelace
Grace  Hopper     Grace        Hopper

The 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

  1. 01Upload a CSV or Excel file, up to 15 MB. The first 5,000 rows and 50 columns are kept.
  2. 02Select the column and choose the clean action.
  3. 03Describe the change and pick in place, new column, or split.
  4. 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.