Text-column extractor
Extract numbered columns from delimited lines without damaging quoted fields.
Bookmark this page
Keep this page handy for next time.
- On a computer
- Press Ctrl + D, or Command + D on a Mac.
- On a phone or tablet
- Open your browser's menu or Share menu and look for Add Bookmark, Bookmark or Add to favourites.
A bookmark saves the page link. Save any tool results separately.
How to use this tool
- Choose the single-character column separator.
- Enter column numbers such as 1,3 in the desired output order.
- CSV quote escaping and embedded newlines are preserved.
Things to know
- Processing happens on your device. Check the result before replacing your original data.
- Each text input accepts up to 5 MiB. Output is limited to 25 MiB and combined text settings to 1 MiB.
- Line-based modes accept up to 100,000 lines, including a trailing empty line.
- At most 10,000 selected indexes and 1,000,000 output cells are accepted, including repeated columns.
- Generated CSV text is limited to 25 MiB in total, including all split files.
- Column selection supports at most 10,000 indexes, including any repeats.
You might also need
More in text & listsText-between extractor
Extract each piece of text between a pair of delimiters.
Delimiter converter
Turn lines or separated values into SQL lists, arrays and custom delimited text.
Sort a list
Sort lines alphabetically, naturally or as numbers.
Text diff
Compare two texts and produce a readable unified line diff.
Text repeater
Repeat text a chosen number of times, with line breaks, spaces or your own separator.
Word and character counter
Count words, Unicode characters, graphemes, lines and UTF-8 bytes.
Bold, small and styled text generator
Make copyable bold, small, circled, strikethrough or upside-down text using Unicode characters.
Remove extra spaces
Trim lines, collapse repeated spaces and remove blank lines.
Line filter
Keep or remove lines containing text, matching a pattern or meeting a length.