Extract Column


About


Use this tool to get a specific column from a delimited text. It works by splitting the list by comma, spaces or any delimiter, grabs the only column that you want and deletes the rest. This is useful when you are trying to separate a concatenated list or when unmerging a single cell in a spreadsheet. You can extract any column as long as it follows the same format (using the same delimiter).

Delimiter


Delimiter is the character/s that sepates each column. In the given example below, space is the delimiter.
Column1 Column2 Column3

Column1 Column2 Column3

Column1 Column2 Column3

Basic Example


Extract first names - column number 2, delimited by comma followed by space.
Collins, Maria Ann

Doe, John

Garcia, James

Smith, Nancy

Wright, Charles Henry

Young, Allen
Result
Maria Ann

John

James

Nancy

Charles Henry

Allen

To extract surnames instead of first names, extract column number 1 using comma as a delimiter.

Revert Changes


Did you put the wrong column number and/or delimiter? No worries, you can use the undo/redo function under Edit button to reverse the extraction.

Related Tools


  • Split Text - Split a text into individual columns, or by a new line.
  • Concatenate Text - Combine or merge two lists/columns line by line.
  • Swap Columns - Swap two columns from a delimited text.