You can save a PDF as Excel only if the program that opened it includes an export feature. Some desktop PDF editors do, often in a paid edition. Browsers and basic viewers do not, and renaming the file to .xlsx never works. If your viewer has no export, you need a separate converter.
Is there a Save as Excel option for PDF files?
Sometimes, and rarely where you first look. Save As in most PDF programs only offers PDF, because Save As keeps the same kind of file. Turning a PDF into a spreadsheet is a conversion, so programs that support it usually put it under an Export or Convert menu instead.
Save As versus Export
Save As writes the document you have open in another file type that the program understands natively. Export runs a conversion and writes a file in a different family altogether. Because a PDF reader's native type is the PDF, a spreadsheet is an export. If you open the Save As dialog and the type list shows only PDF, or PDF plus images, look for Export, Convert or a tools panel instead.
Where to look
Menu names differ between programs and versions, so treat these as places to check, not exact paths:
- The File menu, for an Export or Export To entry.
- A Tools panel or side bar, for an Export PDF or Convert tool.
- A right-click menu on the open document or on a selected table.
- The program's Help search box, where typing "Excel" often jumps to the right menu.
If none of these has a spreadsheet choice, your program has no export for it. That is normal for free viewers.
Export menus in desktop PDF readers
Some desktop PDF programs export to a spreadsheet, but many lock it behind a paid edition. A free reader opens and prints; an editor or a premium tier adds conversion to Word, Excel and other formats. Check your program's feature list before you spend time hunting for a menu that is not there.
The export path in a desktop reader
The exact words vary, but the path generally looks like this. Use it as a guide and adjust to what you see on screen.
- Open the PDF in the desktop program, not in a browser tab.
- Open the Export or Convert option from the File menu or the tools panel.
- Choose a spreadsheet format as the target, usually named Excel or Microsoft Excel Workbook.
- If the program offers a choice between a workbook and an older spreadsheet type, pick the workbook unless you need the old type. The post on choosing between XLS and XLSX explains the difference.
- Check whether the program offers settings, such as the language of the document or whether to convert the pages or only a selected table.
- Choose a folder and a file name, and save.
- Open the saved file in Excel and run the checks below before you use any of it.
Five checks on the saved workbook
An export can finish without errors and still produce a poor sheet. Inspect these five things before you build anything on top of the file:
- Sheet count. Did the export make one sheet, or one per page? A 12-page PDF that arrives as 12 sheets needs combining.
- Header rows. Are the column headings repeated in the middle of the data, once for every page?
- Number cells. Select an amount column. If Excel shows a Sum in the status bar, the cells are numbers. If it shows only a Count, they are text.
- Dates. Click a date cell. If the formula bar shows the same text as the cell and the date will not sort, it is stored as text.
- Totals. Add up the amounts and compare with the total printed on the PDF.
What to do when the export looks wrong
Do not repair a bad export cell by cell. First ask whether the cause is the PDF or the program. Run the same file through a second route, such as Excel's import, and compare the two results. If both mangle the same page, the page itself is the problem, often because it is a scan or has an unusual layout. If only one is wrong, switch to the other and keep it. Also try the export again with only the table pages selected, since cover pages and notes confuse table detection and add stray rows at the top of the sheet.
A reader's export is a good first attempt, but its result is only as good as its guess about your table. For the cases where the guess fails, Excel's own PDF import gives you a table picker and a cleanup window.
Free versus paid features
Do not assume a program you already have can export. Several free viewers will open, search and sign a PDF but offer no spreadsheet output at all. If export is locked, you can either upgrade that program, import the PDF with Excel itself, or use a separate converter. Compare the cost of a subscription with how often you do this task.
Why a web browser cannot save a PDF as Excel
A web browser opens PDFs for viewing and printing, but it has no feature to turn one into a spreadsheet. When you choose Print and then Save as PDF in a browser, that works in one direction only: it creates a PDF from a page. Nothing in the browser reads a PDF back into rows and columns.
Print to PDF goes one way
Print to PDF takes something editable, such as a web page or a document, and draws it into a fixed layout. That step throws away the structure. A spreadsheet that has been printed to PDF no longer has cells, only text placed on a page. Going back means guessing the structure again, which is the whole problem. The post on what survives the trip from PDF to Excel explains why that guess is imperfect.
What the browser can do
Your browser can help in small ways:
- Select and copy text from the PDF it displays, which you can then paste into Excel. A table pasted this way often lands in one column.
- Download the file so a desktop tool can open it.
- Display the file safely so you can check the contents before you convert anything.
For anything beyond that, you need Excel's import, a desktop editor with export, or an online converter.
Can you save a PDF as Excel on a phone?
Yes, but not through the phone's built-in file viewer. Phone viewers open and share PDFs; they do not export to a spreadsheet. To save a PDF as Excel on a phone, you use an app that has a conversion feature, or an online converter in your mobile browser.
The usual routes
On a phone you have three options. A PDF app with an export feature can do it, with the same free versus paid split as on a desktop. A spreadsheet app can open some files, but a PDF is not a spreadsheet type, so it usually cannot. An online converter in the browser works from the files you pick from your phone and lets you download the result there too.
If you take the app route, the step-by-step is in the guide on finding the PDF in your phone's files app.
A phone-friendly option for bank statements
For bank statements, FastBankConvert is built to work on a phone: you upload from your phone's files and download the spreadsheet there. It is not open yet, and the get started page takes your email for when trial conversions are available.
Renaming .pdf to .xlsx and other export dead ends
Renaming a PDF to .xlsx does not convert it. A file extension is a label that tells your computer which program to open the file with. It does not change what is inside. The PDF stays a PDF, and Excel will refuse to open it or report that the file is corrupt.
Why the rename fails
An .xlsx file is a compressed package of structured data that Excel knows how to read. A PDF has a different internal structure. When you rename, you only attach the wrong label. Excel looks inside, does not find what it expects, and shows an error. Changing the label back restores the original file, so the rename is harmless, but it achieves nothing.
Other dead ends
These approaches look plausible and usually do not work:
- Opening the PDF in Excel with File, Open. Depending on your version this either fails or does something other than import data. The guide to what happens when Excel opens a PDF goes through the cases.
- Inserting the PDF as an object. This embeds the file as an icon or a picture of a page; the numbers do not become cells.
- Taking a screenshot and pasting the picture, which gives you an image, not data.
- Printing to a spreadsheet printer. There is no such printer in a standard setup.
What does work
Three real routes remain: a desktop program with an export function, Excel's own Get Data from PDF, and an online converter. The sections above help you choose among them, and the comparison in four ways to turn a PDF into Excel puts them side by side.