SEPARATION AND REDUCTION OF DATA
Extract columns from delimited text
Select columns from CSV, TSV, or other delimited text. Choose a separator, specify column numbers, and set the output format.
Quoted fields and text in Russian or English are supported. Copy the selected columns or save them as a file.
Hides additional parsing options
01 / ORIGINAL DATA
Insert a table or list
02 / DISASSEMBLY PARAMETERS
How is data divided?
In delimiters, you can enter characters directly or use \t - tabulation, \n — LF, \r\n — CRLF, \s —space. The column separator must not coincide with the row separator.
03 / RESULT
Extracted data
TEXT OVERVIEW
Text statistics
Characters are counted as Unicode graphemes. The “Without spaces” count excludes whitespace, including tabs and line breaks.
TOOL FEATURES
Extracting Columns from CSV, TSV, and Plain Text
The tool parses strings at specified delimiters and extracts only the required fields. It is suitable for CSV tables with quotes, TSV files, lists and text data with a custom delimiter. Column numbers can be specified individually or in ranges, for example 1, 3, 5-7.
- Collect the result in separate columns, save the original rows, or output selected values in one list.
- Customize row and column separators, handling of CSV quotes, empty cells, headers and captions.
- Copy or download the result in TXT; edit it and see a summary of characters, words and lines.
- Correct parsing of quotes, line breaks, Russian and English text.
For a normal task, just leave the comma delimiter, specify the numbers of the required columns and select the result format. Additional options can be opened in full mode.