Copy a Table from PDF to Excel Without Losing Columns

You copy a table from a PDF, paste it into Excel, and... everything lands in column A. Or worse, the numbers shift into the wrong columns. You're not doing anything wrong. This happens to almost everyone.

This guide explains why, then shows you how to fix it with free Excel tricks. If you'd rather skip the fixing, Sheetsnap turns the PDF table straight into an Excel file with the columns in place.

Why it happens

A PDF is like a printed page. It knows where each word sits, but it doesn't know about rows and columns. When you copy, Excel gets a long line of words with spaces between them. It has no way to know which space means "new column" and which is just a space inside "Main Street."

Fix 1: Text to Columns (free)

Use this when your pasted rows all sit in column A.

Paste the table into Excel.
Click the letter A at the top to select the whole column.
Click the Data tab, then Text to Columns.
Choose Delimited and click Next.
Tick Space. Also tick Treat consecutive delimiters as one.
Look at the preview at the bottom. If the columns look right, click Finish.

When this fails: if a cell has more than one word (like a name or address), Excel splits it into two cells. Your columns then shift to the right on that row.

Fix 2: Fixed width (free)

Some tables line up in neat columns, like an old printout. Try this:

Select column A again.
Click Data, then Text to Columns.
Choose Fixed width and click Next.
Click in the preview to add lines where each column should split. Drag a line to move it. Double-click a line to remove it.
Click Finish.

This works well for tidy tables but not for ones where text lengths change a lot.

Fix 3: Paste into Word first (free)

This old trick sometimes helps.

Copy the table from the PDF.
Paste it into a blank Word document.
If Word shows it as a table with lines, select the table and copy it again.
Paste into Excel. The columns often stay in place.

If Word shows plain text instead of a table, this trick won't help for that file.

Fix 4: Skip the clean-up with Sheetsnap

When the table is long, has many words per cell, or spreads over several pages, the fixes above take a long time. Sheetsnap reads the layout of the page, so it knows where each column is.

Go to tools.ltd/sheetsnap.
Choose your PDF. It needs real text, not a scan.
Download the Excel file.
Open it and check a few rows against the PDF.

Your file never leaves your device. The tables are read right in your browser, and nothing is uploaded.

Only need one table from a huge PDF? Pull out just those pages first with PageKit. It splits PDFs right in your browser. Then give the smaller file to Sheetsnap.

After pasting: tidy up numbers

Even when the columns are right, numbers sometimes come in as text. You can spot them because they sit on the left side of the cell, and AutoSum ignores them.

Select the numbers.
Click the small yellow warning icon that appears.
Choose Convert to Number.

Also watch for:

Currency signs and commas stuck to numbers. Use Find & Replace (Ctrl + H) to remove "$" if needed.
Dates that turned into odd numbers. Select the column, right-click, choose Format Cells, then Date.
Blank rows from page breaks. Sort the sheet to push blanks to the bottom, then delete them.

Quick guide

Problem	Try this
All in column A, one word per cell	Text to Columns, Delimited
All in column A, neat spacing	Text to Columns, Fixed width
Columns shift on some rows	Paste into Word first, or Sheetsnap
Long or multi-page table	Sheetsnap

Frequently asked questions

Why does everything paste into one column?

A PDF stores words by where they sit on the page, not in cells. When you copy, Excel only gets the words and spaces, so it can't tell where one column ends.

Can Paste Special fix it?

Sometimes. Try right-clicking in Excel and choosing to keep text only, then use Text to Columns.

My table is on page 40 of a long PDF. What do I do?

Pull out just the pages you need first with PageKit, then convert those pages.