pdf to excel6 min read

How to Convert PDF to Google Sheets Free (2026 Guide)

Convert your PDF to .xlsx with PurePDF's free PDF to Excel tool, then open Google Sheets, go to File > Import > Upload, and choose the .xlsx file — your PDF tables appear as an editable spreadsheet in under a minute, no software to install.

SM
Sarah Mitchell

Bank statements, invoices, grade sheets, and sales reports usually arrive as PDFs — and PDFs are where data goes to sit still. You can read the numbers, but you cannot sort them, total them, or chart them until they live in a spreadsheet.

Google Sheets cannot open a PDF directly. There is no File > Open for PDFs, and copying a table and pasting it into Sheets usually lands as one messy column. The fix is a two-step route: first turn the PDF into an Excel (.xlsx) file, then import that file into Google Sheets. The whole thing takes under a minute, it is free, and you do not need to install anything. Here is exactly how to do it.

What you need

Before you start, check three things:

  • A PDF that contains real tables. Text-based PDFs convert cleanly. Scanned images need one extra step, covered below.
  • A Google account, so you can use Google Sheets.
  • A browser. Everything below runs in the browser — nothing to download or install.

The conversion itself uses PurePDF's free PDF to Excel converter. It turns PDF tables into editable .xlsx files with no watermarks and no sign-up.

Step 1: Convert your PDF to Excel

  1. Open the PDF to Excel converter.
  2. Upload your PDF. Drag the file onto the page or click to browse for it.
  3. Wait a few seconds while the tool reads the tables in your file. Large files with many pages take a little longer.
  4. Download the .xlsx file it produces. Save it somewhere you can find it, such as your Downloads folder.

What you get is a real spreadsheet file, not a picture of one: the numbers and text from your PDF sit in rows and columns you can edit. Check the downloaded file before moving on — open it in Excel, LibreOffice, or Google Sheets directly — and confirm the columns line up the way you expect. If a table looks wrong here, it will look wrong in Sheets too, so fix the source first: a PDF with faint or decorative table borders sometimes needs its layout tidied before converting.

Step 2: Import the file into Google Sheets

  1. Go to Google Sheets and open a blank spreadsheet, or open the spreadsheet you want the data in.
  2. Click File in the top menu, then Import.
  3. In the Import file window, click the Upload tab, then Select a file from your device — or drag the .xlsx file straight in.
  4. Pick your .xlsx file and confirm. Sheets asks how to add it. Choose one of these:
    • Replace spreadsheet: the imported data becomes the whole spreadsheet. Best when you are starting fresh.
    • Insert new sheet(s): the imported data lands on its own tab inside your current spreadsheet. Best when you are adding data to an existing workbook.
    • Append to current sheet: adds the imported rows below what is already there. Useful for stacking monthly reports.
  5. Click Import data.

Your PDF tables are now an editable Google Sheet. You can sort, filter, add formulas, and share it like any other spreadsheet.

Step 3: Clean up the sheet

Converted tables almost always need a little tidying. Work through this checklist:

  • Delete blank rows. Conversion often adds empty rows between sections. Select them and use Edit > Delete rows.
  • Fix split columns. A single column in the PDF can arrive as two columns in Sheets, or two columns can arrive merged into one. Use Data > Split text to columns when values are stuck together, and merge cells only when a heading genuinely spans columns.
  • Turn text back into numbers. Values with currency symbols, commas, or spaces may import as text, which breaks SUM and AVERAGE. Select the column, then use Format > Number to set the right format. A quick test: =SUM(A2:A20) should return a number, not 0.
  • Freeze the header row. Click View > Freeze > 1 row so your column names stay visible while you scroll.
  • Check the dates. Dates sometimes import in US month/day order when your sheet expects day/month. Select the column and set Format > Number > Date to match your locale.

If your PDF is scanned

This two-step route works on text-based PDFs — files where you can select the words with your mouse. A scanned PDF is a photograph of a page, and there is no text for a converter to read, so a direct conversion produces a blank or garbled sheet.

Fix that first with OCR. Run the scan through PurePDF's free OCR PDF tool to turn the image into real, selectable text, then convert the result with the PDF to Excel converter and import it as above. Check the OCR result before converting: handwriting, faint print, and skewed scans are the usual reasons a table comes out wrong.

Common problems and fixes

  • The numbers are there but formulas ignore them. The cells contain text, not numbers. Select the column, use Format > Number > Number, and re-enter or paste-as-values any stubborn cells.
  • One table became many tables. Long tables that span pages often import as separate blocks. Stack them with copy and paste, or use a formula such as ={Sheet1!A2:D20;Sheet2!A2:D20} to combine ranges.
  • The currency symbol vanished. Sheets applied a plain Number format. Re-apply Format > Number > Custom currency to the column.
  • Everything landed in column A. The PDF's table borders were faint or missing, so the converter could not tell where columns split. Try Data > Split text to columns with the right separator, and for stubborn files re-export the PDF from its original app with visible table borders.
  • The file is too big to import. Google Sheets caps a spreadsheet at 10 million cells. Split a huge PDF into smaller files first — convert a few pages at a time — and import each part as its own tab.

Repeating this every month

If the same report arrives every month, keep the workflow boring: the same file name pattern, the same import choice, the same cleanup checklist. Save a blank template sheet with your formulas and formatting already in place, then import each month's .xlsx file as a new tab and point your summary formulas at it. That way the monthly job is five minutes of importing instead of an afternoon of retyping — and the numbers stay copy-paste-free, which means no transcription errors.

Frequently asked questions

Can I convert a PDF to Google Sheets without Excel? Yes. You never need Excel installed — the .xlsx file is only a bridge format. PurePDF creates it in your browser and Google Sheets opens it.

Is it really free? Yes. PurePDF's PDF to Excel converter is free to use, and Google Sheets is free with a Google account. There is no software to install and no watermark on the output.

Will my formatting survive? The values and the table layout come across. Fonts, colors, and decorative styling usually do not — Sheets applies its own formatting. Treat the import as raw data, then format it in Sheets.

What about password-protected PDFs? Unlock the file first. A protected PDF will not convert until its password is removed.

The bottom line

PDFs are a great way to share a finished report and a terrible place to keep working data. Converting to .xlsx and importing into Google Sheets takes under a minute, costs nothing, and turns a frozen document back into numbers you can sort, total, and chart. Start with PurePDF's free PDF to Excel converter, import the file, run the cleanup checklist, and your data is ready to work with.

Ready to pdf to excel?

Use our free online tool to process your files securely in high quality. No sign-up required.

Open pdf to excel Tool

Continue Reading