You've cleaned your list — removed duplicates, trimmed whitespace, sorted it. Now you need to get it into a spreadsheet or database as structured data. Here's how to go from a plain list to columnar data.

One List = One Column

The simplest case: paste your list directly into Excel or Google Sheets column A. Each line becomes a row. If your lines contain a delimiter (comma, tab, pipe), you can split them further.

Splitting Delimited Lines

If your list contains lines like john@example.com,John,Smith,+1-555-0100, use Text to Columns in Excel:

  1. Select the column with your data
  2. Data → Text to Columns
  3. Choose Delimited → set the delimiter (comma, tab, etc.)
  4. Finish

Converting to CSV Format

A line-by-line list where each line IS one column of data is already valid single-column CSV. To add it to a multi-column CSV, paste it as column A and populate other columns from other sources.

Python: List to CSV

import csv

with open('input.txt') as f:
    lines = f.read().splitlines()

with open('output.csv', 'w', newline='') as f:
    writer = csv.writer(f)
    writer.writerow(['value'])  # header
    for line in lines:
        writer.writerow([line])

Pre-Processing Before Splitting

Always clean your list before converting to columnar format. Use remove-lines.com to remove duplicates, blank lines, and trim whitespace first. Importing messy data into a spreadsheet is much harder to fix than cleaning the source list.

Clean your list before importing

One click — remove duplicates, blank lines, and whitespace.

Clean my list →