https://magiccsv.app/

>_Magic CSV
Use cases

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.

No credit card requiredWorks with CSV & ExcelPreview before export
Interactive Demo

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     742 Evergreen Terrace,         5551234567   12/15/2024
    Chen      Springfield, IL 62701
002 Michael   221B Baker St, Boston, MA      555.987.6543 Jan 3, 2025
    Torres    02101
003 Jennifer  1600 Pennsylvania Ave,         (555)        2024-11-28
    Walsh     Washington, DC 20500           246-8135

[                    ]Transform
Split full_name into first_name and last_nameSplit address into
street, city, state, zipFormat all phone numbers as (XXX) XXX-XXXX

Works with exports from

Salesforce
HubSpot
QuickBooks
Shopify
Google Sheets
Excel
Airtable
Notion

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

What teams use it for



Sales & CRM

Standardize company names, clean up lead imports



Finance

Reformat dates and currency for QuickBooks imports



E-commerce

Merge SKU data across platforms



Marketing

Clean campaign exports, merge UTM data

[?][?]

Operations

Normalize data across tools and vendors



HR

Format employee records for payroll systems

Stop wrestling with spreadsheet cleanup

Transform your first file free. No credit card.

Start Transforming Free

No credit card required

Magic CSV
Sign in