Map Extract
Free tool

Turn a plain list into a CSV

Paste a list separated by new lines, commas, tabs or spaces and get a properly quoted CSV back. Set the number of columns to regroup a list that repeats in a pattern, such as name, town, phone, into one row per record.

Runs in your browser. Nothing you enter is uploaded.

A copied directory page, regrouped

Copying a list of businesses from a web page or a PDF often gives one long column where every third line starts a new record. With Columns per row set to 3 and a header of business,town,phone, the list becomes a table.

The last business had no phone number in the source, so its row has only two values. A spreadsheet treats the missing cell as empty. If one record in the middle is missing a line, every row after it shifts, so scan the result before you rely on it.

Input
Kiln & Co Pottery
Frome
01632 960410
Marlow Print Works
Bath
01632 960411
Pip & Parsnip Deli
Wells
Result
business,town,phone
Kiln & Co Pottery,Frome,01632 960410
Marlow Print Works,Bath,01632 960411
Pip & Parsnip Deli,Wells

Converting a list

  1. Paste the list

    Put your items in the input box. Blank lines are ignored.

  2. Say how items are separated

    Choose New lines, Commas, Tabs or Spaces under Items are separated by. A comma list such as Frome, Bath, Wells becomes one item per row.

  3. Set columns per row

    Leave it at 1 for a single-column CSV. Use 2, 3 or more when the list repeats the same fields in order, and each group of that many items becomes one row.

  4. Add a header and quoting

    Type column names, comma separated, for an optional header row. Tick Quote every value if the destination wants every field in double quotes; otherwise only values that need it are quoted.

  5. Copy or save

    Copy the CSV or download it as list.csv and open it in a spreadsheet or import it.

Which separator to pick

Your list looks likeSeparated byColumns per row
One email per lineNew lines1
Frome, Bath, Wells, Shepton MalletCommas1
Name, then town, then phone on separate linesNew lines3
Cells copied from one spreadsheet rowTabsHowever many cells per record
Keywords typed with spacesSpaces1 (multi-word items will split)

Why quoting matters

A business name such as Smith, Jones & Co contains a comma. Written into a CSV without quotes, it would be read as two columns. The converter wraps such values in double quotes and doubles any quote marks inside them, which is what spreadsheet apps and import tools expect, so the name stays in one cell.

Spaces as a separator are the risky choice: a town like Shepton Mallet becomes two items. Use it only for lists of single words, such as postcodes without spaces or keywords.

Questions people ask

How do I convert a list into CSV format?

Paste the list, choose how the items are separated, and leave columns per row at 1. Each item becomes its own row in a single-column CSV. Add a header name if your destination needs one, then copy the result or download it as a .csv file to open in Excel or Google Sheets.

Can I turn a vertical list into rows with several columns?

Yes. Set columns per row to the number of fields each record has. A list that runs name, town, phone, name, town, phone becomes rows of three. This only works if every record has the same fields in the same order, because one missing line shifts every row after it.

Will it handle commas inside my values?

Yes. When the list is split by new lines, tabs or spaces, any item containing a comma is put in double quotes in the CSV so it stays in one cell. If you split by commas, the comma is treated as the separator instead, so choose the separator that does not appear inside your values.

Does it remove duplicates or sort the list?

No. Items keep their original order and repeats are kept. Remove duplicates or sort the lines first with a separate tool if you need to, then convert. That way the CSV matches the list you checked, and the regrouping by columns is not thrown off by removed lines.

Where your data goes

Conversion is a few lines of code running on this page. The list you paste and the CSV it produces never leave your browser.

Checked against the tool on

Top