Copy Table From PDF to Excel: Copy and Paste Tables With Formatting
Try to copy a table out of a PDF and paste it into Excel and the whole grid usually drops into a single column, with the numbers arriving as text. PDFXLSX reads the table the way it sits on the page, keeps the rows and columns in place, and hands back a spreadsheet you can total. Drop your PDF on the right to see it.
Works in any browser. Your first conversion is free and files are deleted after processing.
Drop your PDF here or click to browse
PDF files up to 50MB
Rows and columns kept, numbers ready to total. First file free.
Real grid
Not one column
Numeric
Numbers you can total
OCR
Copies scanned tables
No retyping
Skip the cleanup
Why a PDF table paste goes into one column
The table you see in a PDF is not stored as a table. A PDF places each piece of text at a fixed point on the page, and the rows and columns you read are just characters that happen to line up. There is no grid behind them. So when you select a table, press Ctrl+C, and paste into Excel, Excel has no column boundaries to follow. It drops the whole selection into one column, or sometimes one cell, and the structure you were trying to keep is gone.
Then the cleanup starts. You split the text apart with Text to Columns, fix the rows that wrapped onto two lines, and convert amounts that came in as text back into numbers before a SUM will work. Paste Special as text or as Unicode sometimes helps, but on a tight financial layout it still misreads where one column ends and the next begins. For a handful of rows it is a nuisance. For a long statement it is half an hour you did not plan to spend.
PDFXLSX skips the paste step entirely. Instead of copying characters and hoping Excel guesses the columns, it detects the actual table structure in the PDF, maps every value to the cell it belongs in, and runs OCR when a page is a scan. You get the rows and columns you copied, the numbers stay numeric, and you download a ready spreadsheet instead of fighting a paste.
| Item | Qty | Unit price | Total |
|---|---|---|---|
| Widget A | 12 | 9.50 | 114.00 |
| Widget B | 5 | 24.00 | 120.00 |
| Service | 1 | 300.00 | 300.00 |
| Credit | 1 | -45.00 | -45.00 |
Four columns stay four columns, and the price and total columns are real numbers, so a SUM works without a Text to Columns step.
Ways to copy a table from a PDF into Excel, compared
An honest look at which methods keep the grid and which leave you reformatting.
| Method | Keeps the grid? | Numbers stay numeric? | Notes |
|---|---|---|---|
| Ctrl+C then paste | Rarely | No | The table lands in one column or one cell. The quickest route to a long manual cleanup. |
| Paste Special as text | Sometimes | Often not | A little better on simple tables, but tight or wrapped rows still split and merge in the wrong spots. |
| Excel From PDF (Power Query) | Sometimes | Sometimes | Needs Microsoft 365, has no OCR on scans, and pulls the whole file rather than the one table you wanted. |
| Retype it by hand | Yes | Yes | Accurate but slow, and a fresh chance to fat-finger a figure on every row. |
| PDFXLSX in your browser | Yes | Yes | Reads the real table, keeps every column, runs OCR on scans, and shows the result before you download. |
If you only need the grids out of a longer document, the PDF table extractor pulls just the tables, and the accurate PDF to Excel converter uses the same structure-aware engine for whole files.
What you get instead of a broken paste
The details that decide whether the table arrives clean or as a column of text.
Keeps the rows and columns
The table you copied keeps its grid. Each value lands in its own cell, so a four column table is still four columns in Excel rather than one long stack of text you have to split apart.
Numbers stay numbers
Amounts with commas, dollar signs, or negatives in parentheses come through as real numbers, not text. You can SUM and sort straight away, with no Convert to Number warning to clear cell by cell.
Formatting that holds
A cell that wrapped onto two lines in the PDF stays one row, headers stay with their columns, and merged labels do not shove everything sideways. The shape of the table you copied is the shape you get back.
Copies scanned tables too
You cannot select text on a scan, so copy and paste is a dead end there. Built-in OCR reads the table out of a scanned PDF or a photo of a printout and turns it into rows you can edit.
Several tables at once
When a report has the same table on page after page, you do not copy each one. Send the whole file, or several PDFs, and get one clean spreadsheet back.
Private and secure
Uploads are encrypted in transit and at rest, processed in isolation, and deleted automatically once your spreadsheet is ready. Nothing is kept or reused, so even a sensitive financial table stays private.
How to copy a table from a PDF into Excel
Three steps, and the grid stays put instead of collapsing.
Upload the PDF
Drag the file into the box at the top or pick it from your computer. You do not need to select the table by hand. Digital and scanned PDFs both work.
It reads the table
The tool finds the table structure, applies OCR where a page is a scan, and maps each value to the right row and column instead of guessing from the spacing.
Check, then download
Review the converted table, then download it as XLSX or CSV, ready to total and filter. Your file is deleted right after.
When copy and paste is not enough
Anyone who pulls numbers out of a PDF runs into the one-column paste sooner or later. It matters most where the table feeds a total someone signs off on.
-
Accountants and bookkeepers copying line items off statements and invoices that have to tie out to the cent. See the workflows for accountants and bookkeepers.
-
Finance and FP&A teams dropping a table from a report into a model, where one column of text breaks every formula downstream. See PDF to Excel for finance teams.
-
Analysts and researchers lifting a data table out of a report or filing so they can sort and chart it instead of eyeballing a PDF.
-
Operations and admin staff moving price lists, order tables, and rosters into Excel without retyping a column that already exists in the file.
Worried about losing the formatting?
Keeping the grid and keeping the formatting are the same job. A copy that holds the columns and number types is one that did not lose the formatting on the way over.
See how to convert PDF to Excel without losing formatting for the full walkthrough, or how to extract tables from a PDF.
Copying a table from a PDF: common questions
Use a converter that reads the table structure instead of pasting characters. Upload your PDF into the tool at the top of this page, let it detect the rows and columns and run OCR if the file is a scan, then check the preview and download a clean XLSX. The grid stays intact and the numbers come through ready to total, with no Text to Columns step.
Yes, but a plain Ctrl+C and paste rarely keeps the layout, because a PDF has no real columns behind the table. The reliable way is to run the PDF through a converter that maps the table and exports a spreadsheet. That gives you the same rows and columns in Excel without the manual splitting and number cleanup a paste leaves behind.
To retain the formatting, do not paste the table at all. Convert the PDF so the columns, rows, and number types are rebuilt in Excel for you. Upload the file here, and the converter keeps each value in its own cell, holds wrapped rows together, and keeps amounts numeric, so the spreadsheet matches the table in the PDF without any reformatting.
Because the PDF stores text by position rather than in columns, so when you paste there are no column boundaries for Excel to follow and it stacks everything into one column. A structure-aware converter avoids this by detecting the table first and writing each value to its own cell, so the grid arrives intact instead of in a single column you have to split.
Skip the copy and paste and convert the file instead. Pasting loses the columns because the clipboard carries plain text with no grid. If you upload the PDF here, the converter rebuilds the columns for you and exports a spreadsheet, so you open the table in Excel with its rows and columns already in place rather than reassembling them by hand.
It is safe when the tool encrypts your files and deletes them after conversion, which this one does. Uploads are encrypted in transit and at rest, processed in isolation, and removed automatically once your spreadsheet is ready. Nothing is stored long term, shared, or reused, so even a sensitive financial table stays private.
More PDF to Excel options
PDF to Excel Converter That Businesses Trust
Convert any PDF to Excel spreadsheets in seconds. pdfxlsx preserves tables, formatting, and data integrity for business-grade accuracy.
FeaturesAI PDF to Excel Converter: Convert PDF to Excel With AI Accuracy
Convert PDF to Excel with an AI converter that reads tables and scanned files, keeps numbers numeric, and exports clean XLSX or CSV. First file free.
FeaturesConvert PDF to XLSX With Perfect Cell Structure
Convert PDF documents to native XLSX format with full cell structure preserved. No manual reformatting required.
FeaturesExtract Tables From PDF to Excel Automatically
Extract tables from PDF to Excel in seconds. Clean, structured PDF table extraction that handles complex multi-row and merged-cell tables automatically.
Copy a table from a PDF to Excel the clean way
Drop a PDF at the top of the page, check the converted table, and download clean XLSX or CSV with the rows and columns intact and the numbers ready to total. Your first conversion is free. For whole files, start with the PDF to Excel converter, or pull just the grids with the PDF table extractor.