>_Magic CSV

How-To Guides

Step-by-step guides for common CSV transformations.
No formulas. No code. Just plain English.

Splitting Data

Break single columns into multiple fields

Split Address into Columns

Split any address format into clean, separate columns

Split Full Name into First and Last

Automatically separate first, middle, and last names

Formatting

Standardize phone numbers, dates, and currency

Format Phone Numbers

Standardize any phone format to your preferred style

Standardize Date Formats

Convert any date format to your standard

Format Currency Values

Standardize currency with proper symbols and decimals

Cleaning

Fix messy data and remove unwanted rows

Clean Up Messy CSV Data

Fix multiple data quality issues at once

Remove Duplicate Rows

Find and remove exact duplicates instantly

Remove Empty Rows

Remove all empty and blank rows instantly

Merging

Combine multiple columns into one

Merge Columns Together

Combine any columns with custom separators

Merge First and Last Name

Combine first, middle, and last names

Expanding Rows

Turn one row into many based on cell content

Expand Comma-Separated Values

Turn one row with multiple values into multiple rows

Expand Numbered Lists into Rows

Parse numbered lists (1., 2., 3.) into individual rows

Expand Multi-Value Cells

Handle any separator: commas, semicolons, pipes, newlines

Import Prep

Prepare data for CRM and database imports

Prepare CSV for Import

Rename columns to match your system's requirements

Convert and Transform Columns

Transform values based on your rules

Ready to transform your CSV?

Try Magic CSV Free
How-To Guides | Magic CSV | Magic CSV