Table to List

The input box accepts several common formats that people paste when moving data between tools. If you copy cells from a spreadsheet, most apps paste them as tab-separated values (TSV). If you export from a system like a CRM, analytics tool, or scraper, you will often get comma-separated values (CSV). And if you copy a rendered table from a web page, your clipboard might contain an HTML table.

This converter tries to detect which format you pasted and then parses it into rows and columns. Once the data is in a simple row structure, the tool extracts one column and outputs it as a list. The goal is not to be a perfect data import engine. The goal is a fast, predictable way to pull out the one field you actually need.

After parsing, the converter computes how many columns exist in the pasted data and exposes a column selector. By default it extracts the first column because that matches common workflows: pulling the left-most field like IDs, domains, or primary keys from an export.

The output is produced by reading each row, taking the selected column, optionally trimming whitespace, and then joining the results with newline characters. When the "Ignore empty" option is on, blank values are skipped. That is helpful when your table has empty cells, trailing delimiters, or header/footer rows that do not include the selected field.

• Trim cells

  Removes leading and trailing whitespace around each extracted value. Good for pasted data that includes padding or odd spacing.
• Ignore empty values

  Skips empty or whitespace-only cells in the chosen column so you do not get blank lines in the final list.
• Keeps row order

  The output list keeps the original row order. If you need sorting or de-duplication, do that with a dedicated tool.
• No rewriting

  The converter only extracts values. It does not normalize casing, remove punctuation, or clean content beyond trimming.

Real-world exports are rarely perfect. CSV files can contain quoted fields, commas inside quotes, or inconsistent row lengths. Copied web tables can include hidden whitespace, multiple spaces, or header cells mixed with data cells. This tool uses a best-effort parser that covers common cases without trying to implement a full spreadsheet engine.

For CSV, it supports basic quoting rules: text inside double quotes is treated as a single field, and a doubled quote inside a quoted field becomes a literal quote. For TSV, parsing is straightforward because tabs are unambiguous. For HTML tables, the converter reads the visible text content of each cell and collapses repeated whitespace.

If you run into a file with advanced CSV edge cases (multi-line quoted fields, unusual delimiters, or embedded newlines inside cells), the safest approach is to open it in a spreadsheet, copy the column you need, and paste the resulting single-column selection. That reduces parsing ambiguity and makes the extraction step deterministic.

Table-to-list extraction is a small step that unlocks a lot of workflows. It is useful when you are cleaning up exports, preparing bulk actions, or creating a list of values to feed into another tool.

• Pull email addresses from a CRM export to build a contact list.
• Extract URL paths from a log table so you can run a quick normalization or decode step.
• Copy a spreadsheet column of SKUs into a vendor portal that requires one per line.
• Take scraped product names from a table and convert them into a clean list for de-duplication.
• Extract IDs from an analytics report to use in a filter or a follow-up query.

If your job is more complex than a single column, do the transformation in a spreadsheet first. This tool is optimized for speed and clarity when the goal is one field, one line, ready to copy.