Updated November 1, 2026
Seven column operations, all free
Rename, reorder and split spreadsheet columns
Rename headers to match your CRM schema, drag to reorder, and drop what you don’t need. Split, merge, duplicate, and add new columns in the same job, on every plan.
Doing it in Excel instead? See how to use Text to Columns to split a column, or how to combine text from two columns.
No credit card required. Your first file is ready quickly.
What it does
Seven operations, one pass
Rename columns
Change any column header to a new name. Match your CRM's expected field names, fix typos, or standardize naming conventions across files.
Reorder columns
Drag columns into the order you need. Put the most important fields first, or match the exact layout your import tool expects.
Remove columns
Drop columns you don't need. Internal IDs, unused fields, and sensitive data can be excluded from the output in one click.
Split columns
Break one column into several. Split "Full Name" into "First Name" and "Last Name", or separate addresses by a delimiter. Pick what to split on and how many parts (Auto or a number). The new columns are named for you, and you can rename any of them.
Merge columns
Combine two or more columns into one with your choice of separator (comma, space, dash, and more). Merge first and last name into a full name, or join city, state, and postcode into a single address field.
Duplicate columns
Copy a column to a new name while keeping the original. Useful when you want to reshape a value without losing the source, or when your target schema needs the same data under two different field names.
Add columns
Add a column and fill it three ways: one fixed value in every row, values from your own rules (Enterprise over 1,000 employees, otherwise SMB), or a value derived from another column.
How to use it
Three steps, one clean file
Upload your file
Drag and drop any CSV or Excel file. Operelio reads every column and shows them in a list.
apollo_prospects_export_
592 rows, 12 columns
Configure your changes
Rename, reorder, remove, split, merge, duplicate, or add columns. Every operation is on every plan. Preview updates live as you work.
Download the result
Click Apply changes to download the finished file. Your row data is untouched. Only the column layout changes.
Doing it yourself
How to rearrange columns in Excel
Select the column, hold Shift and drag its edge to where it should go. Or cut it with Ctrl+X, right-click the column it should sit before, and choose Insert Cut Cells. Renaming, splitting and merging are separate jobs, one column at a time.
In Excel or Google Sheets
Error-prone for files with many columns. Cut-paste can break formulas and references.
With Operelio
One pass, one download. Your row data is never modified. Undo any change before you run.
Wrong columns might not be the only problem in that file
Upload it and Bridgeant reviews the file before you commit to a tool. It reports what it finds, orders the problems by how much they actually matter, and points you at the tool for each one. That is on every plan including Free, and it works from a summary of your file rather than the contents.
On Starter and up it stops advising and starts doing. Describe the job in a sentence and Bridgeant plans the steps, shows you the plan, and runs them in the right order once you approve. You are not running four jobs by hand and trying to remember which came first.
Bridgeant, the agent inside OperelioPricing
Every column operation is on every plan.
Split, merge, duplicate, rename, reorder and add columns, including a column worked out from another, on every plan. Row limits: 2,000 on Free, 50,000 on Starter, 75,000 on Pro, 150,000 on Agency. Each run uses one job: 5 a month on Free, 300 on Starter, 1,000 on Pro, 3,000 on Agency. Starter from $29.25 a month, Pro from $74.25, Agency from $224.25, billed annually.
It can be a step on a trail on any plan. From Starter, it runs on its own on every file or lead that reaches the trail's folder, with the push into your CRM at the end.
Common questions
Column Manager FAQ
Does this change my data or just the column headers?
Only the column layout changes: names, order, and which columns are included. All row data is preserved. Split and merge create new columns from existing data but never delete row values.
How do I split a name column into first and last name?
Point at the column, click Split, and split on Space. "John Smith" becomes "John" in one column and "Smith" in another. Choose Auto or a number of parts, then rename the new columns in the list.
How do I merge two columns?
Click Merge columns, pick the columns in the order to join them, and choose what they are joined with (comma, space, dash, and more). Name the new column. Merge "First Name" and "Last Name" with a space to get a full name column.
Can I duplicate a column?
Yes, on every plan including Free. The duplicate operation copies a column to a new name while keeping the original. Useful when your target schema needs the same data under two different field names.
How do I add a new column?
Adding a column is on every plan, including Free. Each run uses one job from your plan's jobs a month. Click Add column, name it, and choose how to fill it: One value (the same for every row), By rule (values from your own rules), or From another column, like a seniority level from job titles or the domain from an email address. Your existing rows are never changed.
Can I run multiple changes in one job?
Yes. Rename, reorder, remove, split, merge, duplicate, and add columns can all be configured at once and applied in a single job with one download at the end.
What file formats does it support?
Upload .csv, .xlsx, or .xls files. A CSV comes back as CSV, and an Excel file as .xlsx.
Does it work with multi-tab workbooks?
Yes. The tool reads the workbook's first tab by default, and a Sheet picker next to the file name switches to any other. To reshape columns across every tab at once, combine the tabs into one list in Merge Files first.
What plan do I need?
All seven operations are on every plan, including Free: rename, reorder, remove, split, merge, duplicate, and add. Each run uses one job. Row limits apply: up to 2,000 on Free, 50,000 on Starter, 75,000 on Pro, and 150,000 on Agency.
Works well with
Want the full walkthrough? Read the Column Manager guide →
Your columns, sorted in one pass.
Upload a file, configure every change, and download the finished result. All seven operations are on every plan.