PDF Table Pastes Into One Cell in Excel? How to Fix It
When you copy a table from a PDF and paste it into Excel, content that should be in several columns can end up in one cell. This guide covers two ways to get the columns back and what to check afterwards. We confirmed with a test PDF that this site's PDF to Excel puts table content into separate cells.
Last updated: 2026-10-22
Why does the table land in one cell?
A PDF stores a table not as cells and rows but as text drawn at positions on the page. When you copy, the text can come out without any cell information, and Excel may take it as the text of a single cell. See Why PDF tables break in Excel, and how to fix it for the details.
Method 1: Get the columns from a converter
- Add your PDF to PDF to Excel.
- Check the notice ("Found N tables in N pages") and the preview. In our 2-page test PDF it found 2 tables, and No., date, customer and amount showed in separate columns.
- For a multi-page PDF, choose One sheet per page or Merge into one sheet.
- For formatting, choose Apply original formatting (designed to carry over cell sizes, fonts, background colors, borders) or Values only.
- Click Download Excel file.
When we opened the test file we received, numbers were stored as numbers and dates as date values, and the negative amounts (50,000) and △30,000 came through as -50000 and -30000. To check totals, follow How to check a converted table.
Method 2: Split the pasted text with Text to Columns
This works when the pasted text has a consistent separator, such as a comma or a space, between values. These are the steps from Microsoft's help page for the Text to Columns wizard:
- Select the cell or column you want to split.
- On the Data tab, click Text to Columns.
- In the wizard, choose Delimited and continue.
- Pick the delimiter that matches your data (comma, space and so on) and check the preview.
- Continue, choose where the split data should go, and finish.
We did not test this method in Excel ourselves; the steps come from Microsoft's official help page, and menu names may differ slightly by Excel version.
What to check afterwards
- Numbers left-aligned as text → Fixing numbers stored as text
- Whether totals and row counts match the PDF → How to check a converted table
When this does not work
- Scanned (image) PDFs store the text as a picture, so they can neither be copied nor converted. → How to tell a scanned PDF from a text PDF
- Tables without clear column boundaries can still shift columns after conversion, so check the preview.
- Text to Columns can split in the wrong places if the separators are not consistent.
Last updated: