Delimited Text Extractor

What it does

The extractor breaks delimited text into individual values and puts each on its own line. Paste something like a,b,c on one line and 1,2,3 on the next, click Run, and you get six lines: a, b, c, 1, 2, 3. Commas, tabs, semicolons and pipes are all treated as separators, and surrounding spaces are trimmed.

Typical uses

The reverse job, joining lines back into one comma-separated string, is done by remove line breaks with a custom separator.

Limits

This is a quick splitter: quotes are not interpreted, so a value like "Hopper, Grace" is split at its comma. For real CSV files with quoted fields, use the CSV converter, which follows RFC 4180.

FAQ

Can I split on spaces?

Spaces are trimmed but not used as separators, so multi-word values stay together. To split every word onto its own line, use the text cleaner or a find-and-replace of spaces with new lines.

Is my text uploaded?

No. Everything runs in your browser.