Convert a PDF to Google Sheets

Why Drive cannot do this on its own

Right-click a PDF in Drive and Open with Google Docs, and Google runs OCR and gives you a document. It is text in paragraphs, not a grid; a table becomes one line per row with the cells run together, and copying that into Sheets puts each row in a single cell. That is the reason "import PDF into Google Sheets" has no menu item: Sheets has no PDF reader and Docs does not keep table structure.

PDF to Excel does the part Google skips. It reads the text and its positions from the PDF, works out where the columns fall, and writes a .xlsx with one worksheet per table it found. Before the download it opens that workbook again and counts the cell text against the PDF, so a table that lost its cells is refused. Nothing is sent anywhere; the PDF stays in the browser tab.

Importing the workbook into Sheets

The import dialog matters. File, Import, Upload, then choose the .xlsx. Sheets offers three placements: create a new spreadsheet, insert new sheets into the current one, or replace the current spreadsheet. For a first look, create a new one. Every worksheet the converter wrote becomes a tab, so a twelve-page statement can arrive as twelve tabs, one per page, when the page breaks split the table.

Joining a table that arrived in pieces

Copy the rows from each tab under the first, or use an array formula: in a new tab, list the data ranges of the tabs inside curly braces, separated by semicolons, and Sheets stacks them. Then convert that tab to values with Copy and Paste special, Values only, before you delete the source tabs.

When a CSV is the better route

A CSV is a text file with one line per row and a comma between cells, and Sheets imports it with the same File, Import dialog. PDF to CSV writes one CSV per table it detects, which is convenient when you want each table as its own spreadsheet or want to feed it to a script. It has no number formats, so a column of amounts is imported as plain numbers, and dates are whatever the PDF printed. For a single table with no formatting to keep, CSV is the lighter file.

Scans and photographed pages

A PDF made by a scanner or a phone camera holds a picture of each page. The PDF to Excel tool finds no text in it and says so. Two routes exist. Open the PDF with Google Docs from Drive, which runs OCR, then copy the recognised text into Sheets and use Data, Split text to columns. Or run an OCR tool that writes a text layer into the PDF and then convert the result here. Both need a check of every number against the page, because OCR misreads 6 and 8, and 1 and 7, at a rate that matters in a column of amounts.

Related conversions

The Excel side of this route, with the same tool, is written up in Convert PDF to Excel. For a document rather than a table, Convert a PDF to Google Docs uses Drive's own OCR. The reverse trip is in Convert Google Sheets to PDF, and a deck goes the same way in Convert Google Slides to PDF. The rest of the Office guides are under PDF, Word and Excel help.