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.

Free to useNo account neededProcessed on your device
Your workspaceProcessed on your device

Number columns from 1. Separate positions with commas and list them in the order you want to export them.

Add this tool to your website

Paste this code into your page to add the tool and a visible ToolMellow credit link.

HTML embed code
Preview embed

Text Column Extractor: how to use it

  1. Paste delimited text or open a UTF-8 file. Choose its separator and whether the first record is a header.
  2. Enter the column numbers in the order you want them. Choose how to handle any record missing a selected field.
  3. 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.

Guides