You select a clean looking table in a PDF, hit Ctrl+C, paste it into Excel, and the whole thing lands in a single column. Rows mash together, numbers arrive as text you cannot add up, and the tidy grid you saw on screen is gone. It is one of the most common and most annoying Excel problems, and it is not your fault. A PDF does not actually store a table, so there is nothing for Excel to line up when you paste.
This guide explains why it happens and walks through every way to copy a table from a PDF into Excel and keep the columns, from manual Excel tricks to a one click converter. If you just want the spreadsheet now, the converter at the top of this page reads the real table and gives you clean rows and columns straight away.
Why does my PDF table paste into one column in Excel?
Your PDF table pastes into one column because a PDF stores text by position on the page, not as a grid of cells. There are no real columns or rows inside the file, just characters placed at coordinates that happen to look like a table. When you copy and paste, Excel receives one long stream of text with no cell boundaries, so it drops everything into the first column. The spacing you saw was visual, not structural, which is why it collapses the moment you paste.
This is also why pasted numbers show up left aligned and refuse to sum: Excel treats them as text, not values. Any method that keeps your columns has to rebuild that structure from the layout, either by you setting the splits manually or by a tool that reads the table for you.
How do I copy a table from a PDF into Excel?
To copy a table from a PDF into Excel, select the table in your PDF reader, copy it, paste it into Excel, then use Data and Text to Columns to split the single column back into separate columns. It works best on simple tables with even spacing. Here are the manual steps:
- In your PDF reader, drag to select just the table (avoid grabbing page headers or footnotes).
- Press Ctrl+C, click the first cell in Excel, and press Ctrl+V.
- With the pasted column selected, go to the Data tab and click Text to Columns.
- Choose Delimited if the data is separated by tabs or commas, or Fixed width if it is separated by spaces, then set the break lines and finish.
- Reformat any number columns, because they often paste in as text.
Microsoft says Text to Columns lands somewhere around a 60 to 70 percent success rate on clean tables. On anything with merged cells, multi line entries, or uneven spacing, you spend more time fixing the splits than you saved by copying. For a table you only need once, that may be fine. For statements you process every week, it stops being worth it.
How do I paste a PDF table into Excel columns?
To paste a PDF table into separate Excel columns, paste the copied text first, then immediately run Data and Text to Columns and pick Fixed width so you can place a break line between each column by hand. Excel previews exactly where each split will fall, so you can nudge the lines until every figure sits in its own column. This is the single most useful trick for the one column problem, and most people have never opened that menu.
If your version of Excel is part of Microsoft 365, there is a cleaner route that skips copy and paste entirely. Use Data, then Get Data, then From File, then From PDF, and let Power Query pull the tables out. It keeps structure far better than pasting, but it only ships with 365 and recent builds, it cannot read scanned pages, and it loads the whole file rather than the one table you wanted. We cover the From PDF route in more depth on the page for how to import a PDF into Excel.
Can you copy a table from a PDF into Excel and keep the formatting?
You can keep the formatting, but copy and paste rarely does it on its own. The reliable ways are to use Excel From PDF on Microsoft 365, paste the table into Microsoft Word first and then into Excel, or run the PDF through a converter that maps the real table. Each of these rebuilds the column structure instead of dumping raw text, so rows stay together and numbers stay numeric.
The Word trick is worth knowing: Word often interprets a pasted PDF table as an actual table, and copying it from Word into Excel can carry the cell boundaries across. It is hit or miss with complex layouts, but it costs nothing to try. When formatting really has to hold, including dates, negative numbers, and decimals, a purpose built tool is steadier. Our guide to converting a PDF table into Excel while keeping the columns and formatting shows how a converter handles the cases where the manual methods break down.
Why can't I copy and paste from a PDF at all?
If you cannot copy and paste from a PDF, the document is almost always either scanned or secured. A scanned PDF is a picture of a page, so there is no selectable text to copy, only an image. A secured PDF has copy permissions locked by whoever created it. In both cases the table is there on screen but the characters are not available to your clipboard.
For a scanned file, you need optical character recognition to turn the image into real text before any of it reaches Excel. Manual copy and paste cannot do that, and neither can Excel From PDF. A dedicated OCR PDF to Excel tool reads the picture, recovers the numbers, and rebuilds the table, which is the only way scanned statements and photographed receipts make it into a working spreadsheet.
What is the easiest way to copy a table from a PDF into Excel?
The easiest way to copy a table from a PDF into Excel is to upload the PDF to a converter that reads the table structure and exports clean rows and columns, so you skip the paste, the Text to Columns wizard, and the cleanup entirely. You open the file, the tool finds the tables, and you download an .xlsx where every figure is already in its own cell and every number is a real number.
That is what the converter at the top of this page does, and it is the difference between a five second job and twenty minutes of fixing splits. It detects tables on almost any layout, runs OCR on scanned pages, keeps numbers numeric so your formulas work, and handles several tables in one pass. When accuracy matters most, our accurate PDF to Excel converter maps the real table so the totals match the source, and if you only need the grid as plain data you can export to CSV instead. Either way, you copy the table once and move on.