Adobe Acrobat PDF to Excel: Export Steps and Fixes

Quick Answer: In Adobe Acrobat Pro, open the PDF, go to All tools > Export a PDF, pick Microsoft Excel (.xlsx) and click Convert to XLSX, then save the workbook. Before converting, open the export settings to choose one worksheet for the whole document and to set the decimal and thousands separators. Scanned files need text recognition, which Acrobat Pro runs as part of the export.

Acrobat Pro turns a PDF into an .xlsx workbook through its Export a PDF tool, and the free Acrobat online converter does the same for a single file without the desktop app. The export works best on PDFs that were generated by software and contain real tables. Long statements and reports usually need ten minutes of cleanup in Excel afterwards, and this guide shows where.

What do you need before exporting?

Three things decide how the export goes, so check them first.

• Your Acrobat edition. Exporting to Excel is an Acrobat Pro (or Standard) feature on the desktop. The free Acrobat Reader opens and prints PDFs but does not convert them. If you only have Reader, use Adobe's free online PDF to Excel page instead (covered below).
• Whether the PDF has a text layer. Open the file and try to highlight a number with the cursor. If individual characters highlight, the PDF contains text and the export will read it directly. If the whole page highlights as one picture, it is a scan, and the export depends on optical character recognition.
• Whether the content is a table at all. Acrobat maps text it sees in rows and columns onto cells. A contract or a letter will come out as paragraphs crammed into column A. That is not a fault of the settings; there was no grid to find.

If the PDF is password protected, Acrobat will ask for the password before it lets you export. A file with a permissions password that blocks content copying may refuse to convert until the owner removes the restriction.

How do you convert a PDF to Excel in Acrobat Pro?

Adobe's own instructions for the desktop app follow this sequence. Menu labels move slightly between Acrobat releases (newer builds also expose the same converter from a Convert button in the top bar), but the options are the same.

1. Open Acrobat Pro and sign in, then open the PDF you want to convert.
2. Choose All tools > Export a PDF.
3. In the format list, pick Microsoft Excel and set the file type to Excel Workbook (.xlsx). The other choice, XML Spreadsheet 2003, exists only for very old Excel versions.
4. Click the gear icon or Settings next to the format before you convert (see the next section). This is the step most people skip.
5. Click Convert to XLSX. If the document is a scan, Acrobat recognizes the text first, which can take a while on long files.
6. Choose a folder and file name, and click Save. Acrobat can open the new workbook in Excel when it finishes.

Adobe's walkthrough for the related CSV task, How to convert PDF to CSV, uses exactly this export as its first half, which is why Excel is the right intermediate step if you ultimately need a CSV. That second hop is covered in Adobe PDF to CSV.

Exporting only part of a document

If you need one table from a 40-page report, do not export all 40 pages and delete the rest. Use the page range in the export settings, or use the selection tool to highlight just the table, right-click and choose the option to export the selection. A smaller input gives Acrobat fewer chances to confuse page furniture (headers, footers, page numbers) with data.

Which export settings matter?

The settings panel has three groups, and each one fixes a specific kind of mess.

The numeric setting is the one that causes silent damage. When the separators are wrong, Excel may read 1,234 as one-point-two-three-four in some locales, or leave the amount as text that a SUM ignores. Always check one large figure from the PDF against the cell after export.

Can you do it without Acrobat Pro?

Yes, for occasional files. Adobe runs a free PDF to Excel converter on its website. You select or drag a PDF onto the page, it converts, and you download an .xlsx. Signing in is optional for the basic conversion, though it is needed to save to Adobe cloud storage. The online tool has none of the settings described above, so you cannot choose a single worksheet or force decimal separators; for anything beyond a simple one-page table, the desktop export gives you more control. Also note that the online version uploads your file to Adobe's servers, which matters if the document is confidential.

Other built-in options exist as well. Excel for Windows can read tables straight out of a PDF with Get Data, which is covered step by step in How to import a PDF into Excel. For a quick comparison of every route, including Word and Google Docs, see How to turn a PDF into Excel.

Why does the Acrobat export look wrong on statements and long tables?

Acrobat is a general-purpose converter. It reconstructs a grid from the positions of text on the page, and documents built for printing break that reconstruction in predictable ways. Bank and card statements are the classic example.

Split rows

A transaction description that wraps onto a second line in the PDF becomes two rows in Excel: the first with the date and amount, the second holding only the rest of the description. Sorting the sheet then scatters the fragments. Fix it by filtering the date column for blanks, which isolates the continuation rows, and joining each one to the row above with a formula such as =B2&" "&B3 before deleting the extra row.

Merged cells

Acrobat sometimes merges cells to mimic headings that span several columns. Merged cells block sorting and filtering. Select the whole sheet, open the Merge & Center dropdown on the Home tab and choose Unmerge Cells, then fill any gaps the unmerge leaves.

Numbers stored as text

Amounts with currency symbols, trailing minus signs (125.00-) or a CR/DR suffix are often exported as text. Excel flags them with a small green triangle. Select the column, use the warning icon's Convert to Number option, or run Find and Replace to strip the symbol first. A trailing minus needs a formula, for example =IF(RIGHT(A2)="-",-VALUE(LEFT(A2,LEN(A2)-1)),VALUE(A2)).

Repeated headers and page furniture

Every page of a statement repeats the column headings, the bank name and often a "continued" line. With one worksheet for the whole document, these appear as stray rows throughout. Sort by the date column or filter out rows where the amount column is empty, and they collect at the bottom where you can delete them in one go.

Debit and credit in separate columns

Many statements print withdrawals and deposits in two columns. Acrobat keeps that layout, which is fine for reading but awkward for totals. Add a column with =C2-D2 (or the reverse, depending on which column holds money in) to get one signed amount per row.

When you convert statements regularly, the cleanup above repeats every month. A converter built only for statements reads the transaction table by its meaning (date, description, amount, balance) rather than by its position, so wrapped descriptions stay on one row and money out comes back negative. QuickBankConvert's PDF to Excel page explains what that produces, and the side-by-side Acrobat comparison lays out where each one is the better choice.

How do you check the exported workbook?

Never trust a conversion until it reconciles. Spend two minutes on these checks:

• Row count. Count the entries on one page of the PDF and compare them with that page's rows in Excel.
• Totals. Sum the amount column and compare it with a total printed in the PDF: an invoice subtotal, a report footer, or the change between a statement's opening and closing balance.
• Dates. Click a date cell. If the formula bar shows text rather than a date, or the day and month are swapped, use Text to Columns with the correct date order to fix the whole column.
• Last page. Scroll to the end and confirm the final rows of the PDF made it across. Long exports occasionally drop a closing table that sits beside a summary box.

If the totals match, the file is safe to sort, chart or import elsewhere. If they do not, the gap usually comes from one of the problems in the previous section.

Tips for better results next time

• Ask the sender for the original spreadsheet or a CSV. Many systems that produce PDF reports can export the data directly, which beats any conversion.
• Export from the original digital PDF, not a printed-and-scanned copy. Text recognition is good but not flawless, especially with faint print, stamps or handwriting near the figures.
• Keep the export settings at one worksheet for the whole document for anything tabular that runs over several pages.
• Save the cleaned workbook alongside the PDF so you can audit it later.

For more context on why conversions lose structure and how to repair each symptom, read Convert PDF to Excel without losing formatting.

Related guides

• Adobe PDF to CSV: the Excel route
• Is there a free way to use Adobe's PDF to Excel?
• QuickBankConvert vs Adobe Acrobat
• Convert a PDF to Excel on a Mac