pdfpix

Copy a table from PDF to Excel

Selecting a PDF table and pasting into Excel gives one column of run-together text, because the clipboard carries lines, not cells. Four routes do better: Paste then Text to Columns, Excel's Get Data from PDF on Windows, a detour through Word, and PDF to Excel in this browser tab, which detects the table from alignment and checks the workbook it writes. Each is here, with the number checks.

PDF to Excel

How to copy a PDF table into Excel with Text to Columns

  1. Select and copy in the PDF reader

    Drag from the first cell to the last. Some readers have a column-select mode under the Edit menu; Alt-drag in Acrobat selects a rectangle.

  2. Paste as text

    In Excel, right-click a cell and choose the Match Destination Formatting paste, or Paste Special, Text. Each PDF line becomes one row in a single column.

  3. Split the column

    Select the column, then Data, Text to Columns. Choose Delimited with Space if values are single words, or Fixed width and drag the break lines to the column positions.

  4. Fix numbers and check the total

    Cells that stayed text are left-aligned; run Text to Columns again on that column with no delimiter, or use VALUE. Sum the amounts and match the PDF's printed total.

Why a plain paste gives one column

A PDF page has no cells. When a reader copies a selection, it writes the words in reading order with a line break at the end of each visual row and spaces between the words. Excel pastes a line per row into one column. A description with several words in it is indistinguishable from three columns, which is why Text to Columns needs a delimiter the description does not contain, or fixed positions.

Fixed width works when the PDF used a monospaced font or strict alignment, which most statements and reports do. Delimited with Space works only when every cell is a single word. Two rows of mixed content are enough to see which applies.

PDF table to Excel with Get Data on Windows

Excel for Windows in Microsoft 365 imports a PDF directly: Data, Get Data, From File, From PDF. The Navigator lists each table and each page as an item with a preview. Choose a table and Load, or Transform Data to open Power Query, where you set column types, remove header rows and filter before loading. The connection refreshes if the PDF is replaced, which suits a monthly report.

Excel for Mac lacks the From PDF connector. Windows Excel 2019 and earlier lack it too. The other routes cover those machines.

Through Word

Word 2013 and later open a PDF and rebuild ruled tables as real Word tables. Open the PDF in Word, click into the table, choose Table, Select, Table, copy, and paste into Excel. Cells arrive as cells. The detour takes a minute and works on Mac as well as Windows. Tables without ruled lines may come through as tab-separated text, which Text to Columns splits with the Tab delimiter.

A table that spans pages arrives in Word as one table per page. Paste each below the last in Excel and delete the repeated header rows.

Turn a PDF table into Excel in the browser tab

PDF to Excel detects tables by looking for repeated alignment in the PDF's native text, shows each one beside a preview of the source page, and writes a workbook with a worksheet per table and every value as text. It then reopens the XLSX and compares sheet names, rows and every cell string with what it detected before offering the download, and rejects the file if it carries any formula, macro, external link or hidden sheet.

The PDF never leaves this tab, and no account is needed. It works the same on a Mac, a Windows machine or a Chromebook. Full steps and what the check does and does not prove are in Convert PDF to Excel. For one table as plain text, PDF to CSV uses the same detector.

How to import a PDF into Excel and get numbers, not text

All four routes can leave numbers as text, most often when there is a currency sign, a thousands separator or a trailing minus. Text numbers sit on the left of the cell and do not add up. The quickest repair is to select the column and run Data, Text to Columns with no delimiter and Finish, which re-parses every cell. =VALUE() in a helper column does the same one cell at a time. Strip currency signs first with Find and Replace.

Dates need the same treatment and a consistent format in the source. A column that mixes 01/02/2026 and 1 Feb 2026 needs the rows made consistent before Excel will read them as dates.

Checking the paste and keeping the source

Count the rows against the PDF page. Sum the column that has a printed total and compare. Look at the first and last rows for a header or a footer that came in as data. These take a minute and catch the errors that matter.

When the sheet needs the original PDF beside the numbers, for an audit trail or a reviewer, Insert a PDF into Excel covers embedding or linking it. The remaining spreadsheet guides are under PDF, Word and Excel help.

Questions people ask

Why does pasting a PDF table into Excel put everything in one column?
The clipboard carries lines, not cells. Excel makes one row per line. Split the column with Data, Text to Columns, using Fixed width or a delimiter.
Can Excel open a PDF file directly?
Excel for Windows in Microsoft 365 imports a PDF through Data, Get Data, From File, From PDF. Excel for Mac and older versions cannot.
Is there a way to copy a PDF table on a Mac without Get Data?
Yes. Open the PDF in Word for Mac and copy the rebuilt table, or use PDF to Excel in this browser tab, which detects the table and checks the workbook.
Why do the numbers not add up after the paste?
They arrived as text. Select the column, run Text to Columns with no delimiter, or wrap each in VALUE, then sum again.
Can I copy a table from a scanned PDF?
Not by selecting; a scan has no text. Run OCR first, or on a Mac use Preview's Live Text to select the recognised words and paste them.

Do it now

The tool runs in this browser. Your file never leaves the machine, and the result is checked before you download it.

PDF to Excel

Where to go next