What Is the Extract Column Tool?
Pull one numbered field from each processed record. For an identifier list, that means keeping values such as 00123 as text instead of converting them to numbers. Choose Plain text values for a simple list, or One-column CSV when empty values and embedded newlines need explicit field boundaries.
How to Use the Extract Column Tool
- Paste a small representative sample, or use Sample to try quoted names and identifiers.
- Choose Quoted mode for CSV-style fields. Use Literal mode only when the separator should match exactly and quotes are ordinary characters. Tab inserts a real tab.
- Choose one 1-based column number. Enable Skip first record only if that record is a header you want to omit.
- Inspect the complete result. Copy or Download it; if Copy fails, select the output manually. Clear restores empty input and the default settings.
How the Extract Column Tool Works
Quoted fields are decoded: surrounding quotes are removed and doubled internal quotes become one quote. Spaces and leading zeros stay. Plain text joins selected values with LF. One-column CSV quotes every value, doubles its internal quotes and joins records with CRLF, so a newline inside a value remains distinguishable from the next record.
The parser recognizes CRLF, LF and lone CR record endings and treats an initial U+FEFF as a marker rather than field data. A final record ending does not add an extra record. Only records after an enabled header skip are checked for the selected field. Neither parsing mode guesses a header or converts values to numbers.
Extract Column Tool Example
The code cells below use JSON string notation: \n is LF, \r is CR and escaped quotes are part of the value. An empty string is different from a quoted empty CSV field.
| Input and settings | Complete output | What to check |
|---|---|---|
"Name,ID\r\nAsha,00123\r\nRavi,9007199254740993". Quoted comma, column 2, plain text, skip header | "00123\n9007199254740993" | Both identifiers remain text |
"1,\"first\nsecond\"\n2,plain". Quoted comma, column 2, CSV | "\"first\nsecond\"\r\n\"plain\"" | Two records; the first value contains its own newline |
A,. Quoted comma, column 2, CSV | "\"\"" | One empty selected field is represented by two quotes |
A,. Quoted comma, column 2, plain text | "" | Valid empty text; Copy and Download stay disabled |
Header. Quoted comma, column 1, CSV, skip header | "" | No remaining records; CSV does not create a replacement record |
" a :: b \r\nc::d". Literal ::, column 2, plain text | " b \nd" | Meaningful spaces are retained |
When to Use the Extract Column Tool
Use it when the result should contain only one selected field: IDs for a lookup, a notes column for review or an explicitly header-free export. To keep the whole table and exchange two positions, use Swap Columns instead. Keep the original export beside the extracted result.
| Source or task | Choice | Limitation |
|---|---|---|
| Values with quoted delimiters or newlines | Quoted mode; One-column CSV | Quoted mode requires one UTF-16 code unit as delimiter, excluding quotes/line breaks |
| An exact multi-character separator | Literal mode | Quotes have no special meaning; physical line endings separate records |
| A one-value-per-line list | Plain text values | Embedded newlines make record boundaries ambiguous |
| Empty selected fields | One-column CSV | Removing the only record with Skip first record still leaves no output |
Common Mistakes
A missing selected field in any processed record blocks the entire result with its record number. Empty, fractional or unsafe column numbers are rejected. Quoted mode rejects unclosed quotes, unexpected text after a closing quote and quotes inside an unquoted field. Do not switch modes merely to hide an error if you still need CSV quoting.
Input is limited to 1,000,000 UTF-16 code units and 20,000 records. Incomplete Unicode characters in input or delimiter are rejected rather than exported as replacement characters. Well-formed supplementary characters occupy two units, so they require Literal mode as separators. Typing backslash-t is also two literal characters; use Tab for TSV.
Copy and Download use the complete displayed string. Files are named extracted-column.txt or extracted-column.csv. These text operations do not make spreadsheet formulas inert or check a target import schema. The component processes input in the browser; that is not a privacy guarantee for every site service or browser extension.
Tips for Better Results
Test quotes, a blank field, a multiline value and an ID with leading zeros before processing a full export. Check the target application's interpretation after saving; parser checks concern the received string, not the bytes of an original file. Informational RFC 4180 describes common CSV quoting. Alternative delimiters and line endings here are explicit extensions, not universal CSV validation.