Skip to main content
Sourcetable’s AI can clean and transform messy data in seconds. Instead of manually finding and fixing issues, describe the problem and let the AI handle it.

Cleaning data with AI

Open the AI chat or command bar and describe what needs cleaning:
  • “Remove all duplicate rows”
  • “Fix inconsistent date formats in column B”
  • “Trim whitespace from all text columns”
  • “Standardize country names (US, USA, United States should all be ‘United States’)”
  • “Fill missing values in the revenue column with the average of adjacent rows”
  • “Remove rows where the email column is empty”

Common cleaning tasks

Using the command bar

For quick cleaning actions, use the command bar (Cmd+K / Ctrl+K):
  1. Select the cells or columns you want to clean
  2. Press Cmd+K / Ctrl+K
  3. Type your cleaning instruction
  4. The AI applies the changes directly

Bulk operations

The AI handles large-scale cleaning operations efficiently. You can clean entire columns or datasets with a single instruction, and the AI processes all rows using optimized Python scripts under the hood.