Text · Made a little simpler
Text Column Extractor
Extract selected columns from quoted, delimited text. Keep positional headings, choose what to do with missing fields, then export CSV, TSV or JSON arrays.
Extract the Second Note Column
Free to useNo account neededProcessed on your device
Your workspaceProcessed on your device
Text Column Extractor: how to use it
- Paste delimited text or open a UTF-8 file. Choose its separator and whether the first record is a header.
- Enter the column numbers in the order you want them. Choose how to handle any record missing a selected field.
- Review the selected column preview, then copy or download the result.
Limits and notes
Up to 200,000 input code units, 5,000 records, 100 source columns and 30 selected positions. Supports quoted fields and built-in or custom separators. The preview shows up to 12 data records and exports the full selection.
How your privacy works →Text Column Extractor: common questions
How do I export the third field followed by the first?
Enter 3, 1 under Columns in output order. The output follows your list.
What if two columns have the same heading?
Enter the position of the column you want. JSON arrays and delimited outputs keep selected headings in position without renaming them.
How can I distinguish a missing field from an empty field?
Choose JSON arrays and keep records with empty cells. A missing field becomes null and an explicit empty field remains an empty string.