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.
Kiln & Co Pottery Frome 01632 960410 Marlow Print Works Bath 01632 960411 Pip & Parsnip Deli Wells
business,town,phone Kiln & Co Pottery,Frome,01632 960410 Marlow Print Works,Bath,01632 960411 Pip & Parsnip Deli,Wells
Converting a list
Paste the list
Put your items in the input box. Blank lines are ignored.
Say how items are separated
Choose New lines, Commas, Tabs or Spaces under Items are separated by. A comma list such as
Frome, Bath, Wellsbecomes one item per row.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.
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.
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 like | Separated by | Columns per row |
|---|---|---|
| One email per line | New lines | 1 |
| Frome, Bath, Wells, Shepton Mallet | Commas | 1 |
| Name, then town, then phone on separate lines | New lines | 3 |
| Cells copied from one spreadsheet row | Tabs | However many cells per record |
| Keywords typed with spaces | Spaces | 1 (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