Extract CSV Column

Tags:

Form for extract column from CSV file

This form allows you get any column from CSV data, paste or upload your CSV file below:

browse fullscreen sample copy clear

CSV Separator:

Column number or name:

If the CSV separator can occur in the field between double quotes:

Your result can be seen below.

Result of extract CSV column

download fullscreen copy clear

Move to "Paste Code" for Save it

About extraction of CSV column

About exports columns from CSV files

The Extract CSV Column was created for online exports columns from CSV(Comma Separated Values) data. You can extract columns by their number or by their name and also it supports custom CSV column delimiters.

How it Works?

Just select the options you need and paste your CSV data to the textarea above and click to the button "Convert" and you will instantly get column.

Example of extraction CSV column

Before:

"LatD", "LatM", "LatS", "NS", "LonD", "LonM", "LonS", "EW", "City", "State"
   41,    5,   59, "N",     80,   39,    0, "W", "Youngstown", OH
   42,   52,   48, "N",     97,   23,   23, "W", "Yankton", SD
   46,   35,   59, "N",    120,   30,   36, "W", "Yakima", WA
   42,   16,   12, "N",     71,   48,    0, "W", "Worcester", MA
   43,   37,   48, "N",     89,   46,   11, "W", "Wisconsin Dells", WI

After extract first column:

"LatD"
41
42
46
42
43

After the conversion, you can apply your column to your project or use it for some other purpose.

Donate

Did you like this tool? You can donate to us. This will help us improve our free web tools.

Paypal

Tools