Split and Merge Columns in Excel Online

How to use it

1. Choose your Excel or CSV file.
2. Write what to do, one step per line — see the examples in the box.
3. Press Run and download the result.

Steps you can write:

• split Name by space into First Name, Last Name
• merge City, State into Location with ", "
• upper Country (also lower, proper)
• date Joined to DD/MM/YYYY

What you get

• Transformed XLSX/CSV
• Recipe file you can reuse
• Schema and row-count checks

Good to know

• Rules are literal — no AI guessing of column meaning
• Up to 20 MB per file, 10 files at a time.
• Files are deleted from our server within an hour.

Do it yourself in Excel

• Text to Columns
• Separate first and last names
• Combine first and last names
• CONCATENATE

Questions

Does the column name have to match exactly?

Use the header exactly as it appears in the first row of your file.

Can I run several steps at once?

Yes, one per line. They run top to bottom.