PDF pasted into Excel is all in one column? Here's how to fix it

You copy a table out of a PDF, paste it into Excel, and every row lands in column A as one long line of text. Here's why it happens and four ways to split it back into proper columns.

Updated October 21, 2026 · 7-minute read

Why it happens

A PDF doesn't store a table. It stores pieces of text placed at positions on a page, so when you copy, your PDF viewer hands Excel lines of text with spaces between the words, not cells. Excel has no way to know where one column ends and the next begins, so each line goes into a single cell.

Before trying the fixes, look at one pasted line and notice what separates the columns:

A single space, the same as the spaces inside names and descriptions. This is the hard case (see names with spaces).
Wider gaps (two or more spaces) between columns, single spaces inside names. Some PDF viewers keep these, and they make splitting easy.
Tabs. Some viewers copy columns with tabs between them. If so, Excel usually splits them by itself when you use Paste Special as text, or Text to Columns with Tab ticked.

Also check whether you can select the text in the PDF at all. If nothing highlights, it's a scan and needs text recognition (OCR) first; there's no text to split.

Fix 1: Data > Text to Columns

Good for: columns separated by a delimiter (a tab, a comma, a pipe) or columns that start at the same character position on every line.

Select the column with the pasted text (column A).
Go to Data > Text to Columns.
Choose Delimited if something consistent separates the columns, tick it (Tab, Space, Comma or Other), and tick Treat consecutive delimiters as one so a run of spaces counts once. Choose Fixed width if the columns line up at the same position on every line, then click in the preview to set the break lines.
On the last step, set columns that hold IDs with leading zeros (like part numbers 00412) to Text so Excel doesn't strip the zeros, then Finish.

Excel desktop also offers Paste > Use Text Import Wizard right after you paste, which runs the same steps.

Fix 2: the TEXTSPLIT function (Excel for Microsoft 365)

Good for: lines where columns are separated by wider gaps than the spaces inside names.

If your paste kept two or more spaces between columns, split on two spaces and tidy the leftovers. In B2, next to the first pasted line:

=TRIM(TEXTSPLIT(A2, "  ", , TRUE))

The delimiter is two spaces, the TRUE ignores the empty pieces a long run of spaces creates, and TRIM removes stray spaces. The result spills across the row; copy the formula down. When it looks right, copy the results and use Paste Values so you can delete the original column.

Fix 3: Power Query, Split Column

Good for: long pastes you'll redo every week, because the steps are saved and replayed.

Select the pasted column and use Data > From Table/Range to open it in Power Query.
Use Home > Split Column > By Delimiter (choose Space or a custom delimiter such as two spaces) or By Positions if columns start at fixed character positions, for example 0, 10, 34, 52.
Filter out the junk rows (page headers, "Page 3 of 9", subtotals), set column types, and Close & Load.

Next week, paste the new text into the same table and use Data > Refresh All. If the PDF itself is regular enough, skip the copy and paste entirely with Get Data from PDF and these cleanup steps.

The hard case: names and descriptions with spaces

If every separator is a single space, splitting on spaces breaks "Riverbend Cafe" into two columns and shifts everything after it. A few ways around it:

Split from the edges. When only one column has spaces in it (usually the name or description), the columns on either side are single words or numbers. In Power Query, use Split Column > By Delimiter, choose Space and Left-most delimiter to take the first column off, then Right-most delimiter to take the amount off the end. Repeat until only the name is left in the middle.
Fixed width. If the report prints in a monospaced layout, the columns start at the same position on every line, so Fixed width in Text to Columns (or By Positions in Power Query) works no matter what the names contain.
Open the PDF in Word first. Word's PDF conversion often recognizes the table and keeps the columns apart; copy the table from Word into Excel instead. See the Word method.
Flash Fill. Type the first two or three values of a column by hand next to the pasted text, then press Ctrl+E. Excel guesses the pattern for the rest of the rows. Check the results; it guesses wrong on irregular rows.

If you paste the same report every week

The fixes above get you columns. You still have to remove the repeated headers, page totals and wrapped notes, then build the summary people asked for, every time the report comes back.

Wheelbarrow starts from the PDF itself, so there's no paste to split. You drop in the report, describe the result in plain words, for example "one row per order, a tab per region, red if over 30 days", and see it built from your own file before you pay. The tool you keep runs on your PC, even offline, and turns next week's PDF into the finished workbook in seconds.

Tired of splitting the same paste every week? See your report built from your own PDF first. Try it with my files

Questions

Why does my PDF paste into one column in Excel?

The PDF stores positioned text, not a table, so the copy gives Excel plain lines of text. Excel puts each line in one cell because nothing tells it where the columns are. Text to Columns, TEXTSPLIT or Power Query can split the lines afterward.

How do I split the column when names have spaces in them?

Split from the edges: take the first column off with the left-most space and the last column with the right-most space, leaving the name in the middle. Or use Fixed width if the report lines up in fixed positions, or open the PDF in Word and copy the table from there.

Is there a way to paste a PDF table into Excel and keep the columns?

Sometimes. Some PDF viewers copy with tabs between columns, which Excel splits automatically. Opening the PDF in Word first, or using Data > Get Data > From File > From PDF in Excel for Microsoft 365 on Windows, usually keeps the columns better than a plain paste.

Does Text to Columns work on Mac?

Yes. Data > Text to Columns is in Excel for Mac too. TEXTSPLIT needs Excel for Microsoft 365 or Excel for the web.