How to Convert a PDF to Google Sheets (From a Mac, Without Extra Software)
If your team lives in Google Sheets, a PDF full of numbers is an irritation: there is no open-and-convert button, and Sheets does not import PDFs directly. The good news is that two simple routes work on any Mac without installing software. Which one you choose depends on how complicated the PDF is and whether you are comfortable putting the file into Google Drive.
Quick answer: If the PDF has selectable text, select the table in Preview, press ⌘C, click a cell in Google Sheets and press ⌘V, then use Data > Split text to columns if everything lands in one column. For a short PDF, you can instead upload it to Google Drive, open it with Google Docs, copy the table from there and paste it into Sheets.
Why there is no direct import
Google Sheets can import CSV, Excel and a number of other formats, but a PDF is a page description rather than a data format. The table you see is characters placed at coordinates, so any tool has to guess the structure. That is why every route to Sheets involves either copying text and splitting it or using Google Docs as an intermediate step.
| Route | Steps in short | Good when | Watch out for |
|---|---|---|---|
| Copy from Preview, paste into Sheets | Select table, copy, paste, Data > Split text to columns | PDF has selectable text and a simple table | Columns may merge |
| Open in Google Docs via Drive | Upload, Open with Google Docs, copy the table, paste into Sheets | PDF is short, or has an image text layer | Layout can change, file goes to Google Drive |
| Convert to Excel first, then import | Extract to .xlsx locally, upload and open in Sheets | You already have a local workflow | An extra step |
Route 1: Copy from your Mac and paste into Sheets
This route keeps the PDF on your Mac until you paste the text.
Open the PDF in Preview and check the text is selectable by searching with ⌘F.
Hold ⌥ and drag a rectangle around the table, then press ⌘C.
In Google Sheets, click the cell where the table should start and press ⌘V.
If everything lands in column A, select it and choose Data > Split text to columns. Sheets splits on a separator you choose: comma, semicolon, period, space, or a custom character, and it can detect the separator automatically.
Clean up the result.
The selection tips in our guide to copying a PDF table into Excel apply here, including copying one column at a time when columns merge. Everything about checking totals applies as well.
Route 2: Open the PDF in Google Docs
Google Drive can open a PDF in Google Docs, converting it into an editable document. Tables often come across as real tables, which paste into Sheets with rows and columns intact.
Upload the PDF to Google Drive by dragging it into the browser window.
Right-click the file and choose Open with > Google Docs.
Find the table in the document, select it by dragging across it, and copy.
Paste it into a Google Sheet.
This works best for short, simple PDFs. Complex layouts, many pages or unusual fonts can come out rearranged, and Google applies conversion limits, so check Google's current documentation if a file does not open. Because the file is uploaded, keep this route for documents that are fine to store in your Drive. It can also read some scanned PDFs, because Google applies text recognition when it converts them, but check every number if you rely on that.
Route 3: Convert locally, then import
If you already extract tables locally, for example with the method in our guide to converting a PDF to CSV on a Mac, you can simply upload the finished CSV or Excel file to Sheets using File > Import. This keeps the messy PDF out of Google altogether and uploads only the cleaned data.
Fix the data in Sheets
The same problems that appear in Excel appear in Sheets. Numbers arrive as text, dates are not recognised, and there are invisible spaces. The fixes are the same in principle, and many are the same formulas.
Numbers as text. Wrap the cell in VALUE, or multiply by 1, and paste back as values.
Invisible spaces. =TRIM(SUBSTITUTE(A2, CHAR(160), " ")) works in Sheets as it does in Excel.
Paste values only. Use ⌘⇧V to paste values without formatting.
Dates. Use Format > Number > Date, or DATEVALUE for text that Sheets recognises.
Our guide to cleaning PDF data pasted into Excel explains each of these problems in depth, including negative numbers written with parentheses or a trailing minus. The ideas transfer directly even though the menus differ.
Privacy
Route 1 sends only the pasted text to Google, and only when you paste it into a Sheet. Route 2 uploads the whole PDF to Drive. If the document is sensitive, such as a bank statement or payroll report, think about whether that is acceptable under your own or your employer's rules, and use a local method instead.
Common mistakes
Pasting into a sheet that already has data, overwriting it.
Forgetting to split the text, and then wondering why every row is one cell.
Assuming the Google Docs conversion is perfect. Always compare with the PDF.
Leaving the PDF in Drive after you have finished with it.
Skipping the total check.
Frequently asked questions
Can Google Sheets import a PDF directly?
Not as a table. You paste the data in, or convert the PDF through Google Docs first.
Is there a formula that reads a PDF?
No built-in function does. Add-ons exist, but check what they do with your data and what they cost before installing.
Why did my table lose its columns?
The copied text had no tab separators. Use Split text to columns, or copy one column at a time.
Does this work for scanned PDFs?
Google's conversion to Docs may recognise some text in scans. Quality varies, so verify the numbers.
Is it better to convert to Excel first?
Only if you already have a good local workflow. Otherwise route 1 or 2 is quicker.