Copy PDF Table to Excel: Fix the One-Column Paste

Quick Answer: A PDF has no cells, so when you copy a table the clipboard gets lines of text with spaces between the values, and Excel puts each line in column A. Select that column and run Data > Text to Columns to split it, use Flash Fill (Ctrl+E) when the spacing is irregular, and switch to an import tool once the table runs past a page or two.

Copying a table out of a PDF and pasting it into Excel usually lands every row in a single column, because the PDF stored positioned words, not a grid. You can repair that paste with Text to Columns, a paste-as-text step, or Flash Fill. If the table is long, has wrapped descriptions or spans pages, importing the PDF is quicker than fixing the paste.

Why does a PDF table paste into one column?

Excel splits pasted text into columns only when it finds tab characters between values. A spreadsheet or a web page puts tabs on the clipboard when you copy a grid. A PDF viewer usually does not: it copies the characters in reading order and separates them with ordinary spaces, one line of text per row. Excel sees "03/14 Coffee Shop 4.50 1,204.10" as one value and puts it in A1.

Three things make it worse:

• Spaces inside values. "Coffee Shop" contains a space, so splitting on spaces breaks the description into two cells while the date and amount behave.
• Wrapped lines. A long description that takes two lines in the PDF becomes two rows on paste.
• Reading order. Some viewers copy a page column by column instead of row by row, so you get all dates, then all descriptions, then all amounts.

Which viewer you copy from changes the result. Try the same selection in a second app before you start fixing: Adobe Acrobat Reader, a web browser's built-in PDF viewer and macOS Preview each build the clipboard text slightly differently, and one of them may give you tabs or cleaner line breaks for that particular file.

Fix 1: split the column with Text to Columns

This is the standard repair, and it works whenever each row's values are separated consistently. Microsoft's Text to Columns instructions boil down to:

1. Select column A (or just the pasted cells).
2. Choose Data > Text to Columns.
3. Pick Delimited and click Next.
4. Tick the delimiter. For PDF pastes this is usually Space, with Treat consecutive delimiters as one ticked so double spaces do not create empty columns.
5. Watch the Data preview, then click Next.
6. Set a Destination cell to the right if you want to keep the original paste for comparison.
7. Click Finish.

When the PDF lines values up in fixed positions (common in reports printed from older systems), choose Fixed width in step 3 instead and click in the preview to place column breaks. Fixed width keeps "Coffee Shop" together because it ignores spaces and cuts at the positions you set.

On the last wizard screen you can also set a column data format. Set account numbers and reference codes to Text so Excel keeps leading zeros, and set the date column to Date with the order the PDF uses (DMY or MDY).

Fix 2: paste as plain text first

Sometimes the paste arrives as an object or with fonts and spacing from the source, and Text to Columns behaves oddly. Paste as plain text and split afterwards:

• In Excel, use Home > Paste > Paste Special and choose Text or Unicode Text.
• Or paste into a plain text editor (Notepad, TextEdit in plain text mode) first, clean obvious junk such as page footers, then copy from there into Excel.

The text editor detour is also the easiest place to use find and replace on double spaces or stray symbols before Excel ever sees the data.

Fix 3: let Flash Fill pull out each field

When spacing is irregular and neither delimiter nor fixed width splits cleanly, Flash Fill can work by example. Per Microsoft's Flash Fill page:

1. In column B, next to the first pasted row, type the value you want extracted, for example just the date.
2. Start typing the second one. Excel previews the rest of the column; press Enter to accept, or press Ctrl+E (or Data > Flash Fill) to run it.
3. Repeat in column C for the description, column D for the amount, and so on.

Flash Fill is good at "first token", "last number on the line" and "everything between the date and the amount". Check its guesses on rows that differ from the first example, such as a refund with a minus sign or a description containing digits. If it does not trigger, turn on Automatically Flash Fill under the advanced editing options.

Fixing the leftovers after the split

Many of these show up on bank statements in particular. The statement data cleanup tips go further on signs, balances and categories.

When should you stop copying and import instead?

Copy and paste is fine for a ten-row table on one page. It stops paying off when:

• the table continues across pages, because you repeat the copy, the split and the header cleanup for each page;
• the descriptions wrap, so you are joining rows by hand;
• the PDF is a scan, where there is no text to copy at all (the selection tool picks up nothing, or the whole page as an image);
• you will do the same job again next month on a PDF with the same layout.

The alternatives, roughly in order of effort:

1. Excel's built-in importer. On Windows with Microsoft 365, Data > Get Data > From PDF detects tables page by page and can join them. The guide to importing a PDF into Excel has the full walkthrough.
2. Tabula, a free desktop tool where you draw a box around the table and export CSV. Its own site says it only reads text-based PDFs, not scans.
3. A dedicated table or statement converter. For a comparison of the table tools, see converting a PDF table to Excel.

If the table you keep pasting is a bank or credit card statement, QuickBankConvert removes the splitting step entirely. Upload the PDF, and each transaction comes back as its own row with the date, description, signed amount and running balance in separate columns, with wrapped descriptions already joined. Without an account you can preview one statement a day on screen; a free account adds CSV and Excel downloads (pricing has the limits).

Related guides

• How to turn any PDF into an Excel spreadsheet
• Import a PDF or a PDF table into Google Sheets
• Bank statement PDF to Excel