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 |
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.
Magic CSV offers free tries to get started. You can test transformations without signing up. Sign up for free to transform your own files.
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