Transform spreadsheet data
using plain English
Describe what you want—split columns, reformat dates, standardize names—and get clean, import-ready data in seconds. No formulas. No scripts.
Try it yourself
Here's some messy data. How would you clean it up?You have 3 tries to get the hang of it.
| id | full_name | address | phone | signup_date |
|---|---|---|---|---|
| 001 | Sarah Chen | 742 Evergreen Terrace, Springfield, IL 62701 | 5551234567 | 12/15/2024 |
| 002 | Michael Torres | 221B Baker St, Boston, MA 02101 | 555.987.6543 | Jan 3, 2025 |
| 003 | Jennifer Walsh | 1600 Pennsylvania Ave, Washington, DC 20500 | (555) 246-8135 | 2024-11-28 |
Free CSV tools — transform data in your browser
Clean, split, merge, and dedupe CSV files online with no signup. For complex csv transform jobs — messy addresses, fuzzy dedupe, plain-English instructions — use the AI app.
Remove Duplicates
Upload a CSV and instantly remove duplicate rows. Choose which columns define a duplicate, or match across every column. Your file never leaves your browser.
Remove Empty Rows
Upload a CSV and strip out every blank row in one click. Perfect for cleaning up exports with scattered empty lines. Everything runs in your browser.
Delete Columns
Upload a CSV and remove the columns you do not need. Select one or many, then download the trimmed file. Your data stays in your browser.
Merge Columns
Upload a CSV and combine several columns into a single column with the separator you choose. Great for building full names or addresses. Runs in your browser.
Split Column
Upload a CSV and split a single column into multiple columns using any delimiter. Your file is processed in your browser and never uploaded.
Trim Whitespace
Upload a CSV and clean up stray spaces in every cell: leading, trailing, and repeated spaces are all fixed. Runs entirely in your browser.
Works with exports from
How it works
Upload
Drop your CSV or Excel file
Describe
Tell us what you want in plain English
Export
Download clean, import-ready data
See it in action
Real transformations, powered by plain English
Clean up CRM exports
Example 1“Split full_name into first_name and last_name”
| full_name | company | |
|---|---|---|
| John Smith | john@acme.com | Acme Inc |
| Sarah Jane Connor | sarah@tech.io | TechCorp |
| Bob | bob@startup.co | StartupCo |
| first_name | last_name | company | |
|---|---|---|---|
| John | Smith | john@acme.com | Acme Inc |
| Sarah Jane | Connor | sarah@tech.io | TechCorp |
| Bob | — | bob@startup.co | StartupCo |
Standardize phone numbers
Example 2“Format all phone numbers as (XXX) XXX-XXXX”
| name | phone |
|---|---|
| Alice Wong | 5551234567 |
| Bob Chen | 555.987.6543 |
| Carol Davis | (555) 246-8135 |
| name | phone |
|---|---|
| Alice Wong | (555) 123-4567 |
| Bob Chen | (555) 987-6543 |
| Carol Davis | (555) 246-8135 |
Parse addresses
Example 3“Split address into street, city, state, zip”
| customer | address |
|---|---|
| Acme Inc | 123 Main St, Austin, TX 78701 |
| TechCorp | 456 Oak Ave, Denver, CO 80202 |
| StartupCo | 789 Pine Rd, Seattle, WA 98101 |
| customer | street | city | state | zip |
|---|---|---|---|---|
| Acme Inc | 123 Main St | Austin | TX | 78701 |
| TechCorp | 456 Oak Ave | Denver | CO | 80202 |
| StartupCo | 789 Pine Rd | Seattle | WA | 98101 |
Frequently asked questions
Everything you need to know about Magic CSV
Magic CSV is an AI-powered tool that transforms CSV and Excel files using plain English instructions. Instead of writing formulas or code, you describe what you want in natural language and Magic CSV does the transformation for you.
Upload your CSV or Excel file, describe the transformation you want in plain English (like "split the address column into street, city, state, and zip"), preview the results, and export your clean data.
Magic CSV can split columns, merge columns, standardize date formats, format phone numbers, clean addresses, remove duplicates, normalize text, convert currencies, and much more - all described in plain English.
Yes. Free in-browser CSV tools (dedupe, split, merge, trim) require no account. The AI app includes a monthly free token allotment; paid plans add more capacity for complex data transformation.
No coding required. Magic CSV is designed for non-technical users. You describe what you want in plain English, and the AI handles the transformation logic.
Stop wrestling with spreadsheet cleanup
Transform your first file free. No credit card.
No credit card required