CSV column editor: reorder, rename, delete and add columns
In short: Lists every column with its first value; move it up or down, rename it, delete it or restore it, add a new column with one value for every row, rename all headers to snake_case, Title Case or lower case, and put the email column first. Warns about blank and repeated column names. Limit: It works on one file at a time; joining files is a separate tool.
Load the CSV and each column appears in a list with its first value. Move columns up or down, type a new name, delete what the importer doesn't need, or add a column such as source with one value for every row. Repeated or blank names are flagged, and the download keeps the file's delimiter.
Price: this tool is free. Checking a whole email list is from $9/mo, and the first 100 checks are free with Google, no card. See pricing
Sample result
7 columns in, 7 out: email first, Notes deleted, headers in snake_case, lead_source added.
- Columns out
- 7
- Deleted
- 1
- Added
- 1
What this means for you
The file now matches what the importer expects; no blank or repeated column names.
- Move up or down
- Rename one or all
- Delete and restore
- Add a fixed-value column
- Columns
- Import prep
- CSV
By SimpleVerifier Team · Last updated · Runs in your browser; nothing you paste is sent to us
Also in: Português (Brasil) · Español
How do I check the addresses before the import?
- Set the columns here and download the file.
- Upload it at /verify. Every address gets a live mailbox check, and valid, risky and invalid download as separate files with your columns kept. The first 100 email checks are free with a Google sign-in, no card.
- Import the valid file.
How do I change the column order in a CSV file?
- Paste or upload the CSV and press Load the columns.
- Use the arrows to move columns, the name box to rename, and the cross to delete. Deleted columns can be restored from the list underneath.
- Optional: rename every header to snake_case or Title Case, move the email column first, or add a column with a fixed value.
- Check the preview and download the CSV.
Example
- You enter
- A 3-row lead export with Company Name, First Name, Last Name, Work Email, Phone, LinkedIn URL and Notes columns; Move the email column first, Notes deleted, headers set to snake_case and a lead_source column added.
- You get
- 7 columns out in the new order:
work_email,company_name,first_name,last_name,phone,linkedin_urlandlead_sourcewithexpoon every row. No blank or repeated names; the download keeps the comma delimiter. - Limits
- Runs in your browser with no row cap; an uploaded file can be up to 25 MB.
Why do importers care about column names and order?
Most importers map columns by header name, and a few by position. A file with E-mail Address where the tool expects email, or with the email in column F when the uploader reads column A, imports blank or not at all. Sequencers also turn every header into a merge field, so First Name (Primary) becomes a variable nobody can type.
Renaming everything to snake_case gives first_name, company_name, linkedin_url: the form most tools accept and the easiest to use in merge tags. For a named target such as Instantly, Smartlead or lemlist, the CSV import formatter maps the headers for you.
What if two columns end up with the same name?
Most importers keep one and silently drop the other, so the tool warns before you download. It also warns about a blank header, which importers either reject or call column_7.
Who uses this tool, and for what?
- Marketing ops
- Put a CRM export into the column order and names an ESP import template expects.
- Cold emailers
- Delete the 40 columns a lead database exports and keep the six the sequence uses, with clean merge-field names.
- Agencies
- Add a client or source column to every row before files from several clients are combined.
What can’t this tool tell you?
- It works on one file at a time; joining files is a separate tool.
- Column moves are one step at a time with the arrows, not drag and drop.
- The preview shows the first 100 rows; the download has all of them.
- It shapes the file, not the contacts in it. Whether the addresses work needs a mailbox check.
Common questions
- Can I add a column?
- Yes. Add a column, name it, and type the value every row should have, such as
webinar-novin a lead_source column. - Does it change the values?
- No. Only which columns appear, in what order and under what name. For values, use find and replace in CSV.
- Can I merge two columns into one?
- Not here. To join files on a shared column, use CSV merge.
- Is my file uploaded?
- No. It's read in your browser.
A tidy list can still be full of dead addresses.
Extracting, deduplicating and syntax checks all work on the text of an address. None of them can tell whether the mailbox exists. Only the server that hosts it can answer that, through an SMTP check, and that is what the paid product does.
- Upload the cleaned file as it is: CSVs up to 100,000 rows
- A real SMTP mailbox check on every row, with catch-all detection
- Small list? Starter at $9/mo covers 2,500 emails a month, cancel anytime
Plans from $9 a month, cancel anytime, no contract. Sign in with Google and your first 100 email checks are free, no card. The free tools stay free either way.