Map Extract
Free tool

Pull one column out of a CSV

Paste or open a CSV, choose a column by its header, and get just those values, ready to paste into a verifier, a suppression check or a search box. Duplicates and empty cells are left out unless you say otherwise.

Runs in your browser. Nothing you enter is uploaded.

Getting a column out

  1. Load the data

    Paste straight from a spreadsheet or press Open a file for a .csv, .tsv or .txt. The separator is detected, or set it to comma, semicolon, tab or pipe yourself. The counter confirms how many rows and columns were read.

  2. Choose the column

    The Column list shows your header names. If the file has no header row, untick First row is a header and the columns are listed by number instead.

  3. Decide what to drop

    Remove duplicates keeps each value once, in the order it first appears. Skip empty cells leaves blank rows out. Both are on by default.

  4. Pick the output shape

    One per line suits most tools that take a list. Comma separated puts everything on one line, which is handy for a search filter or an email BCC field you are filling by hand.

  5. Copy or download

    The output box shows how many values there are. Copy them, or save them as a text file.

Emails and towns from a merged lead list

The file below has six rows for four businesses, with one repeat, one email in different capitals and one blank email.

Choosing email with the defaults gives three values: the blank is skipped and the exact repeat is dropped. Repeats are spotted regardless of capitals, so Hello@ and hello@ would count once, with the first spelling kept; spaces around values are trimmed too. Choosing town with duplicates removed gives Frome, Bath, Wells, which is a quick way to see which places a list covers.

Input
business,town,email
Kiln & Co Pottery,Frome,hello@kilnandco.example
Marlow Print Works,Bath,info@marlowprint.example
Oak Lane Joinery,Frome,
Marlow Print Works,Bath,info@marlowprint.example
Pip & Parsnip Deli,Wells,shop@pipparsnip.example
Result
email (3 values)
hello@kilnandco.example
info@marlowprint.example
shop@pipparsnip.example

town (3 values): Frome, Bath, Wells

Why take one column at a time

Most of the next steps in prospecting want a single list, not a table. An email verifier takes addresses, a suppression check takes emails or domains, a map search takes town names, and a CRM import of tags takes one value per line. Copying a column out of a spreadsheet works until the sheet has blanks, repeats and a header in the middle; this does the same job with those already handled.

It is also a fast way to answer simple questions about a file. How many distinct towns does this list cover? How many rows actually have a website? Extract the column with duplicates on and empty cells skipped, and the count above the output is your answer.

Questions people ask

How do I get a list of unique values from a CSV column?

Choose the column, leave Remove duplicates and Skip empty cells ticked, and the output lists each value once in the order it first appears. The count above the box is the number of distinct values. Matching ignores upper and lower case and surrounding spaces, and the first spelling found is the one kept.

Can I extract a column from a file without a header row?

Yes. Untick First row is a header and the column menu switches to Column 1, Column 2 and so on. The first row is then treated as data and included in the output, so nothing is lost from files exported without column names.

Will it open semicolon or tab separated files?

Yes. The separator is detected from the data by default, and you can force comma, semicolon, tab or pipe if the guess is wrong. Spreadsheets saved in European locales often use semicolons, and many database exports use tabs; both work the same way once the separator is right.

Can I extract several columns at once?

This tool takes one column at a time, which keeps the output a simple list. Run it again for each column you need. To keep several columns together as a smaller table, open the file in the CSV viewer, filter it, and download the rows you want instead.

Where your data goes

Parsing, filtering and the text download all run in this browser tab. The CSV you paste or open is not transmitted to any server.

Checked against the tool on

Top