Tools84

TEXT TOOLS, MADE SIMPLE

Extract Column from Text

Extract a specific column from delimited text or CSV using a delimiter and column number

Runs in your browser Free to use Editable results
Advertisements
or drop your text file here

Advertisements
BlogHow to extract one column from delimited text Read the guide

Read one field from each delimited line

Extract a chosen column from each line of simple delimiter-separated text.

Source text, a reviewed result and a reusable copy
QUICK VIDEO TUTORIAL Extract a text column Extract a text column English narration Watch the video

Extract a text column

Practical ways to use this tool

Everyday work

Simple tables

Collect one field from consistently delimited rows.

Focused tasks

Contact lists

Separate one column of a basic text list for another task.

Text preparation

Data checking

Keep row positions visible when some records lack the selected field.

Features and how to use them

Count columns from one

Column number identifies the field after splitting each line by Column separator.

How this transformation works

A comma is the initial separator and column 1 is selected initially. Multi-character separators are matched literally. The selected field is trimmed at its beginning and end. If a line does not have that column, its result is blank, so the remaining rows keep their relative positions.

Set the available controls

Choose the options before applying the transformation.

Options and initial settings

Column separator: initially ",". Column number: initially 1. Accepted range: 1 to 10000.

See a small example

A short input makes the transformation easier to inspect.

View input, options and result

This example was checked with the current tool. The options shown apply only to this example; your editor keeps the settings you select.

Input
Ada,London,42
Lin,Paris,37
Result
London
Paris

Example settings: Column separator: ,; Column number: 2.

Start with your own text

Upload a text file, write directly, or try the sample.

Opening and applying the tool

The entry screen accepts one UTF-8 TXT, CSV, JSON, XML, HTML or HTM file and opens the editor. Imports are text content, not a PDF or Word conversion. Review the source and choose Extract Column from Text when ready. Editing or importing alone does not apply the transformation.

Review, save or continue

Check the report before saving or continuing with the text.

Using the finished text

Result overview shows a one-column table, row totals and Rows with missing columns. A missing source field produces a blank extracted value while retaining its row position. Use the table to check the selected field before exporting. Select TXT for the editable text or CSV for the full table, then use the download icon. Editing the result hides the table and disables CSV until you rerun the tool; TXT and copy still use your edits. Continue to offers compatible next tools for the current text and their limits. Review the transferred text before running the next operation.

Files, limits and privacy

Input
Pasted text or one UTF-8 TXT, CSV, JSON, XML, HTML or HTM file
Output
Editable text, UTF-8 TXT and a complete CSV table

Maximum input and editable TXT result: 1 MB of UTF-8 text, with a 1,048,576-character input ceiling. Expanding transformations must also fit the TXT result limit. CSV files can be larger because they include column headings, quoting and separators. The table shows 50 rows per page and at most 12 columns. Long cells are shortened after 160 Unicode code points on screen; CSV retains all rows, columns and complete values.

This text operation runs in your browser; its source and result are not sent for conversion. A draft may be kept in this browser tab when session storage is available. Clear removes the current draft; download important work before closing the tab.

See the Privacy Policy for file and data handling.

FAQ

Good to know

Does Extract Column from Text send my text to a server?

No. This tool processes text in your browser. Text-file imports and downloads stay on your device.

Can I edit and download the result?

Yes. The result remains editable. Copy it or download a UTF-8 .txt file from the result page.

How much text can I process?

Text input and generated output are limited to 1 MB to keep your browser responsive. Split larger documents into smaller parts.

Advertisements

Language38

English العربية Français Italiano Deutsch Español Português Nederlands Русский Türkçe 日本語 中文 हिन्दी Bahasa Indonesia Bahasa Melayu 한국어 Tiếng Việt ไทย Polski Svenska Українська Norsk বাংলা Ελληνικά فارسی اردو Čeština Dansk Magyar Română Suomi Български Filipino ქართული Slovenčina Azərbaycanca עברית Slovenščina

Choose from 38 interface languages.