# Extract a Single Column from PDF to Excel Fast

- Author: FastBankConvert (https://fastbankconvert.com)
- Published: 2026-10-17
- Category: Tables and data from PDFs
- Canonical: https://fastbankconvert.com/blog/extract-a-single-column-from-pdf-to-excel

> Extract a single column from a PDF to Excel without the rest: block select in a reader, convert and delete, or a pattern that keeps only it.
To extract a single column from a PDF to Excel, either select just that column in a reader that supports rectangular selection, convert the whole table and delete the columns you do not need, or paste the lines and use a formula that keeps only the one field. Then count the values against the PDF.

## Selecting one PDF column in a reader

Most PDF readers select text line by line, so dragging down one column picks up every column beside it. Some readers offer a rectangular or column selection mode that copies only the words inside a box. Where your reader has one, it is the quickest way to take one column.

### Testing your reader

Open the PDF and try a selection that starts at the top of the column and ends at the bottom of the same column. If the highlight spreads across the full width of each line, your reader is selecting by line. Look through its menus and help pages for a rectangular, column or area selection option, and if there is one, try the same drag with it switched on. The highlight should then form a neat box.

### What comes across

A rectangular selection copies whatever text falls inside the box, one line per row. Paste it into column A of an empty sheet. Two things to watch for:

- **Values at the edge.** A long value that pokes past the box edge may be cut, or dropped, depending on the reader. Draw the box with a little room on each side.
- **Wrapped cells.** In a description column, a wrapped entry arrives as two rows. In a number column this rarely happens, which is one reason a single-column copy works best on dates and amounts.

## Convert the whole PDF table, then delete the other columns

Converting the whole table and then deleting every column except the one you want sounds slower, but it is usually faster and safer. A converter keeps each value on the same row as its neighbours, so you can check the column against the others before you throw them away.

### Why the long way is safer

A single column taken on its own has no context. If one value went missing, the rest shift up by a row, and nothing in a lone column of numbers shows it. In a full table, a missing amount leaves a visible gap beside its date and description. Check the table first, then delete. The reasoning behind how converters decide where one column ends and the next begins is set out in [how table detection works on a PDF](/blog/extract-table-from-pdf).

### Deleting in one step

Select the column you want to keep, then press Ctrl+Space to select the whole column, and copy it to a new sheet. That is quicker than deleting the others one at a time, and the full conversion is still on the first sheet if you need it.

### Subtotal rows

Tables that print subtotals after each group put extra numbers in the column you are extracting. A subtotal looks exactly like an amount once its label column is gone. Remove subtotal rows while the label column is still there. The patterns for spotting them are in [handling a PDF table with subtotal rows](/blog/pdf-table-with-subtotals-to-excel).

## Can a pattern pull one PDF column out of pasted lines?

A pattern can pull one column out of pasted lines when that column sits in a fixed position, such as first or last, or has a fixed shape, such as a date. Paste the lines into column A, then use a formula that takes the piece before the first space or after the last space.

### Worked example: keeping only the amounts

These five example lines were copied from a PDF and pasted into A2:A6. The values are invented. Each line ends with an amount:

| Cell | Pasted line |
| --- | --- |
| A2 | 04/01 Window cleaning 85.00 |
| A3 | 04/03 Printer ink, black 42.99 |
| A4 | 04/08 Monthly software plan 30.00 |
| A5 | 04/12 Refund, returned cable -14.50 |
| A6 | 04/15 Courier to Leeds office 18.20 |

In B2, the formula `=VALUE(TEXTAFTER(A2," ",-1))` returns 85, the piece after the last space, as a number. Fill it down to B6. Column B now holds only the amounts: 85.00, 42.99, 30.00, -14.50 and 18.20.

To keep only the dates instead, use `=TEXTBEFORE(A2," ")`, the piece before the first space. To keep the description in the middle, take the text after the first space and before the last one: `=TEXTAFTER(TEXTBEFORE(A2," ",-1)," ")`.

### When the column is in the middle

A field in the middle of a line, with text of any length on both sides, has no fixed position. Count from whichever end has the fixed number of fields. If each line ends with an amount and a balance, the amount is the second piece from the right: `=TEXTAFTER(TEXTBEFORE(A2," ",-1)," ",-1)`.

### Signs and brackets

Amounts printed with a trailing minus, as 14.50-, or in brackets, as (14.50), will not convert with VALUE. Replace those markers first. The different ways a negative amount can be written, and which ones software reads, are covered in [negative numbers in CSV and Excel files](/blog/negative-numbers-in-csv). When the text is not table-shaped at all, the approach in [extracting PDF text that is not a table](/blog/extract-text-from-pdf-to-excel) fits better.

## Did the single extracted PDF column lose any values?

A single extracted column loses values silently, so check it with two numbers from the PDF: the count of rows and, for amounts, the printed total. If the count and the sum both match, nothing went missing or got doubled. If either is off, find the gap before using the column.

### The count check

Count the data rows on the PDF page, or use the line count the document prints if it has one. In Excel, `=COUNTA(B2:B6)` counts filled cells, and `=COUNT(B2:B6)` counts only real numbers. In the worked example both should return 5. A COUNT lower than COUNTA means some values are still text, usually because of a stray space or an unconverted minus sign.

### The sum check

If the PDF prints a total for the column, sum yours and compare. For the example, `=SUM(B2:B6)` returns 161.69. A difference equal to one of the values points to a missing row. A difference of twice a value points to a sign that went the wrong way.

### A spot check by position

Pick three rows, the first, one in the middle and the last, and compare them to the PDF by position. A column that is right at both ends but wrong in the middle has usually lost or gained a row at a page break.

For bank statements, FastBankConvert is built to give you every column at once, already split into dates, descriptions, amounts and balances, and to tell you before download if the balances do not add up. It is not open yet; [sign up on the get-started page](/get-started) to hear when it is.