How to convert PDF to Excel without losing formatting?

You can convert PDF to Excel using Excel’s built-in import tools, online converters, or dedicated desktop software such as PDFgear. To convert PDF to Excel without losing formatting, choose a converter that recognizes table structure. Rows, columns, and basic styling may transfer well, but complex layouts can still require adjustments.

Import PDF tables with Excel’s built-in tools

Excel’s PDF connector uses Power Query to import detected tables. It extracts data rather than reproducing the PDF’s appearance.

1. Open Excel and select Data > Get Data > From File > From PDF.
2. Select your PDF and review the detected tables in Navigator.
3. Choose the tables you need, then select Transform Data.
4. Clean the rows and columns, then select Close & Load.

Availability depends on your Excel version and platform. Scanned PDFs require OCR before their text can be extracted.

Convert PDF to Excel online with PDFgear

PDFgear’s free online PDF to Excel converter creates editable XLSX files. It works in a browser on Windows or Mac, allowing you to convert PDF to Excel without installing software.

1. Open PDFgear’s PDF to Excel converter and click Select PDF File.
2. Choose the PDF report you want to convert.
3. Select Standard mode for a text-based document or Advanced mode for OCR.
4. Click Convert, then Download File.
5. Open the workbook and compare the extracted table with the PDF.

Choose Advanced mode to convert scanned PDF to Excel using OCR. The online tool accepts one PDF at a time, up to 100 MB.

Batch convert PDF to Excel offline with PDFgear desktop

PDFgear Desktop lets you convert PDF to Excel for free on Windows and Mac. This PDF to Excel converter app supports multiple reports in one operation and lets you convert PDF to Excel offline.

1. Download and open the PDFgear desktop app.
2. Select PDF to Excel in the Convert from PDF section.
3. Click Add File and select the reports you want to convert.
4. Choose the output folder and enable Output to One Sheet if you want a table spanning several pages in one worksheet.
5. Click Convert, then open the resulting Excel file.

Add several reports to batch convert PDF to Excel. For a table that continues across pages, Output to One Sheet lets you convert a multi-page PDF to one Excel sheet.

Export PDF tables with Adobe Acrobat Pro

Adobe Acrobat Pro offers worksheet organization and number-format settings on Windows and Mac. Excel export requires paid access; it is not a free Acrobat Reader feature.

1. Open your PDF in Acrobat Pro and select Convert.
2. Choose Microsoft Excel and select XLSX.
3. Open Settings and choose a worksheet for each table, each page, or the entire document.
4. Adjust the number separators if needed, then click OK.
5. Select Convert to XLSX and save the workbook.

To convert PDF to Excel without losing formatting, check both the table layout and its appearance. Excel’s built-in import focuses on data, while PDFgear and Acrobat Pro also aim to retain styling. Complex tables and scans may still need corrections.

If your reports contain scanned pages or complex tables that Excel’s import struggles with, Azure AI Document Intelligence is worth testing. It combines OCR with table extraction, including identifying rows, columns and merged cells.

To try it, create an Azure Document Intelligence resource, open its Studio, and analyse a sample PDF with the Layout model. Check the detected tables in the preview before processing more reports. The results are structured data, so you’ll need a small script or integration to turn them into an Excel workbook.

For your formatting concern, it focuses on recovering table structure, rather than matching the original fonts, colours and borders. Extracted amounts may also need conversion from text to numbers, so check decimal separators and totals before calculating.

There’s a limited free tier for testing, with paid usage generally charged per page. It’s a cloud service, so files must be uploaded. It makes more sense for repeatedly processing difficult reports than for a few files where you want a straightforward “upload PDF, download Excel” converter.

If your reports are scanned PDFs, PaddleOCR’s PP-Structure is worth considering. It’s a free, open-source document-analysis toolkit that combines OCR with table-structure recognition. It runs locally, but it’s a developer tool rather than a simple desktop converter.

The workflow is to install PaddleOCR and the PP-Structure dependencies for your chosen version, download the required models, then run the table-recognition pipeline on your PDF pages. For a pipeline that accepts images, render the PDF pages as images first. Export the recognised tables using that version’s Excel export option.

Use one representative page as a test before processing everything. Check merged cells, multiline headings, and whether amounts landed in the correct columns. OCR can confuse characters such as 0 and O, so compare some figures and totals against the original.

It’s useful when you need to process many scans privately on your own computer. However, reconstructed table structure doesn’t guarantee identical formatting or that every exported value will already be an Excel number.

Since you already have Excel, Power Query is worth another try specifically for importing tables. It’s included in supported Windows versions of Excel, so there’s no separate converter fee.

Go to Data > Get Data > From File > From PDF, select your report, and choose the detected table in the Navigator preview. Click Transform Data before loading it. This lets you remove repeated headings, correct column names, and set numeric columns to Decimal Number or Whole Number. Then select Close & Load to bring the table into your worksheet.

The trade-off is that Power Query focuses on usable data, not reproducing the PDF’s appearance. It can preserve a straightforward table’s rows and columns, but fonts, borders, merged cells, and complicated layouts may not carry over cleanly. Image-only scans need OCR first.

Before doing calculations, check a few totals and confirm that decimal separators and negative numbers imported correctly. If you regularly receive reports with the same layout, you can reuse the query’s cleanup steps.

Before paying for anything, try the converter built into Excel itself, because it keeps tables as tables and is free if you have Microsoft 365 or a recent Excel. It is easy to miss:

• In Excel go to Data > Get Data > From File > From PDF, pick your file, and in the Navigator choose the table (or the page) you want. Click Transform Data if it needs cleaning, then Close & Load. Excel detects the tables for you and keeps rows and columns separate, so sorting and formulas work straight away.
• Clean up in the Power Query window if needed: Use First Row as Headers, split or merge columns, change data types (numbers and dates), and remove blank rows. The steps are saved, so when next month's PDF has the same layout you can point the query at it and click Refresh, which saves a lot of time on recurring reports.
• Expect values, not styling. No converter can reproduce the PDF's fonts and colours exactly. What matters is that the numbers land in the right cells, and you can apply a table style afterwards or copy the format from a previous workbook with Format Painter.
• If the PDF is a scan or a photo (you cannot select the text in it), Excel will not read it. In that case you need OCR first: the Excel mobile app has Insert Data from Picture, or you can use a PDF reader with OCR.
• For a lot of PDFs with complicated layouts and merged cells, a paid tool such as Adobe Acrobat's Export to Excel is usually more accurate than free ones.

One caution on free online converters: your reports get uploaded to a stranger's server, so avoid them for anything with business or customer data.