Convert PDF to Excel in Power Automate

What this action does

PDF4me Convert PDF to Excel transforms PDF documents into fully editable Microsoft Excel (.xlsx) spreadsheets inside your Power Automate flow. Automatically extracts tables, line items, numeric data, and form responses as native Excel cells, not flat images. Choose Draft mode for fast native-PDF extraction (1 API call per file) or High mode with AI OCR for scanned documents and complex layouts in 8+ languages (2 API calls per page). Replace manual Smallpdf, iLovePDF, Adobe Acrobat, or Tabula uploads with a single automated action that chains directly into SharePoint, Excel Online, Power BI, Dataverse, Dynamics 365, and any Microsoft 365 workflow.

Authenticating Your API Request

Every PDF4me action in Power Automate requires a valid PDF4me connection. Create one with your API key the first time and Power Automate reuses it across all PDF4me actions in your flows.

Get your API Key

Important Facts You Should Not Miss

Draft vs High, match the mode to your PDF source

Draft uses 1 API call per file, ideal for native PDFs from accounting software, ERPs, or BI tools (5-10× cheaper at scale). High uses 2 API calls per page with full OCR + table reconstruction, required for scanned invoices, photographed statements, and image-based tables.

Native Excel cells, not flat images of tables

Table headers become Excel headers; numeric columns are typed as numbers; date columns parse as dates. Cells are sortable, filterable, and ready for formulas, pivot tables, and Power BI ingestion, unlike screenshot-style PDF-to-Excel tools.

Output is .xlsx (Office Open XML), not legacy .xls

Modern .xlsx format with MIME type application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, compatible with Excel 2007+, Excel Online, Excel for Mac, Microsoft 365, Power BI, Google Sheets, and LibreOffice Calc.

Power Automate PDF4me Convert PDF to Excel action showing File Content mapped from a previous Get file content step, File Name with .pdf extension, and Quality Type set to Draft for native PDFs or High for scanned documents — Map File Content and File Name from a prior step, choose Quality Type (Draft for native PDFs, High for scanned), and run, the editable XLSX is returned in the output.

Parameters

Required: File Content, File Name, and Quality Type must all be provided. The action cannot convert without a binary source PDF and a quality selection.

Parameter	Required	What it does	Example
File Content	Yes	Binary content of the source PDF file. Map from any prior action that returns file bytes: SharePoint Get file content, OneDrive Get file content, Outlook email attachment, Forms file upload, HTTP Request, or Get file content using path.	`File Content (binary)`
File Name	Yes	Filename of the source PDF including the .pdf extension. Used for identification during processing and to derive the default output filename (replacing .pdf with .xlsx). Map dynamically from prior step variables.	`invoice-2026.pdf`
Quality Type	Yes	Conversion quality mode. Draft for native born-digital PDFs with selectable text (1 API call per file, fast and cost-efficient). High for scanned PDFs, image-based PDFs, or complex multi-column layouts (2 API calls per page with OCR and table reconstruction).	`Draft`

Quality Type Options

DraftDefault, fast, 1 API call per file

Best for native born-digital PDFs with selectable text, invoice exports from QuickBooks/SAP/Xero/NetSuite, BI tool reports, browser print-to-PDF financial statements, ERP-generated documents. Returns a usable XLSX in seconds. 5-10× more cost-efficient at scale than High mode.

HighAccurate, 2 API calls per page with OCR

Required for scanned invoices, photographed bank statements, image-based tables, or complex multi-column financial layouts. Applies AI OCR + table reconstruction. Supports English, German, French, Spanish, Italian, Portuguese, Dutch, Polish OCR.

Output Fields

Field	Type	What it contains
`File Content`	Binary	Converted XLSX file as binary content. Map directly into downstream actions: SharePoint Create file, OneDrive Create file, Excel Online (Business) Add a row, Power BI dataset refresh, Outlook Send an email attachment, or Dynamics 365 Record attachment.
`File Name`	String	Output filename of the generated Excel spreadsheet (e.g. invoice-2026.xlsx). Derived from the input File Name with the .pdf extension replaced by .xlsx. Use directly as the filename in SharePoint or OneDrive Create file actions.

Quick Setup

In your Power Automate flow, click + New step and search for PDF4me.
Select the Convert PDF to Excel action from the PDF4me Connect connector.
Choose your PDF4me connection or click Add new connection with your API key.
Map File Content to the binary output of a previous action: typically Get file content (SharePoint), Get file content using path (OneDrive), Outlook email attachment, or HTTP Response body.
Set File Name dynamically from the prior step (must include .pdf extension): e.g. triggerOutputs()?['body/Name'].
Choose Quality Type:

Draft for native PDFs (invoice exports, BI reports, ERP outputs): fast and cost-efficient.
High for scanned PDFs, photographed bank statements, or complex multi-column tables, applies OCR + table reconstruction.

Save the flow and test with a sample PDF containing tables.
Connect the output File Content to your next action: SharePoint Create file, Excel Online Add a row, Power BI dataset refresh, Dynamics 365 record attachment, or Outlook attach to email.

Workflow Examples

Workflow ExamplesCommon Power Automate flow patterns using Convert PDF to Excel.

Vendor invoice email → Excel line items → accounting system import

An Outlook trigger fires when an email arrives from a known vendor domain with a PDF invoice attachment.
Convert PDF to Excel runs with Quality Type = Draft (vendor invoices are typically native PDFs from accounting systems).
The resulting XLSX contains line items (description, quantity, unit price, total) as native Excel rows.
An Excel Online action reads the rows and posts each as a record into Dynamics 365 Finance, Business Central, or your AP system via HTTP.
The original PDF and the extracted XLSX are filed in SharePoint with metadata (vendor, amount, invoice number) for audit traceability.

Monthly financial PDF reports → Excel → Power BI dashboard refresh

A scheduled flow runs on the 1st of every month over a "Monthly Reports" SharePoint library containing PDF financial reports from auditors and finance teams.
For each new PDF, Convert PDF to Excel runs with Quality Type = Draft to produce an editable XLSX with all data tables extracted.
An Excel Online action appends the data to a master "Consolidated Financials" workbook in SharePoint, partitioned by report category and reporting period.
A Power BI dataset refresh is triggered on the consolidated workbook, the executive dashboard now reflects the latest figures within minutes of PDF arrival.
An Adaptive Card in Microsoft Teams notifies the CFO that the monthly close data is ready for review.

Scanned bank statements → OCR Excel → automated reconciliation

A SharePoint trigger fires when bookkeepers upload scanned bank statement PDFs to a "Statements to Reconcile" library.
Convert PDF to Excel runs with Quality Type = High (scanned source, OCR + table reconstruction required).
The OCR-extracted XLSX contains every transaction row (date, description, amount, balance) as editable, sortable Excel cells.
A Power Automate Apply to each loop matches each transaction to records in Dataverse or the ERP, matched rows are flagged "Reconciled"; unmatched rows route to a Microsoft Teams approval channel for the bookkeeper to investigate.
The reconciled XLSX is archived to the "Reconciled Statements" SharePoint library with metadata (account, period, match rate) for audit.

Frequently Asked Questions

What's the difference between Draft and High quality in Convert PDF to Excel?+

Draft mode is the fast path: one API call per file, designed for native born-digital PDFs with selectable text such as invoice exports from QuickBooks, Xero, SAP, NetSuite, browser print-to-PDF financial statements, accounting software output, and BI tool reports. It returns a usable XLSX in seconds and is the right choice for most modern PDFs. High mode uses two API calls per page and applies AI-powered OCR plus table reconstruction, designed for scanned PDFs, photographed pages, image-based PDFs, or PDFs with complex multi-column financial layouts. Use High when source files came from a scanner or when Draft output has missing rows, misaligned tables, or character recognition errors.

How does Convert PDF to Excel extract tables from a PDF document?+

The action automatically detects table boundaries in the source PDF, reconstructs row and column structure, and outputs the data as native Excel cells: not flat images of cells. Table headers become Excel headers; numeric columns are typed as numbers (not strings) so SUM, AVERAGE, and other formulas work immediately; date columns are parsed as dates where possible. For PDFs with multiple tables on one page or tables spanning multiple pages, the action handles each table as a separate region while preserving row-level relationships. Use High quality mode for scanned tables, multi-column layouts, or PDFs where row alignment is critical (such as bank statements or multi-page invoices).

Can I convert scanned or image-based PDFs to editable Excel spreadsheets?+

Yes. Set Quality Type to High to apply AI-powered OCR over each page. The action extracts text and numeric values from scanned tables, reconstructs row and column structure, and produces an XLSX where the formerly image-based data is now fully editable, sortable, filterable, and ready for Excel formulas and Power BI ingestion. OCR supports English, German, French, Spanish, Italian, Portuguese, Dutch, Polish, and other major business languages without extra configuration. Ideal for digitizing legacy paper invoices, scanned bank statements, photographed receipts, historical accounting records, and any paper-origin financial content that needs to flow into modern Microsoft 365 analysis workflows.

What output format does the action produce: .xlsx or legacy .xls?+

The output is always the modern Microsoft Excel .xlsx format (Office Open XML standard, ECMA-376 / ISO 29500). This is fully compatible with Microsoft Excel 2007 and later, Excel Online (Microsoft 365), Excel for Mac, Power BI Desktop (direct import), Google Sheets (with conversion), LibreOffice Calc, Apple Numbers, and all major spreadsheet applications. The legacy binary .xls format is not produced. The XLSX file ships with proper MIME type application/vnd.openxmlformats-officedocument.spreadsheetml.sheet for correct handling by SharePoint, Outlook, Microsoft Teams, OneDrive, and Power BI dataset connections. The XLSX format also enables features that .xls does not support: million-row tables, conditional formatting, and modern pivot table engines.

How does this compare to manual Smallpdf, iLovePDF, Adobe Acrobat, or Tabula conversion?+

Online tools like Smallpdf, iLovePDF, Adobe Acrobat online, Nitro PDF, Soda PDF, and the open-source Tabula desktop application require manual file upload one PDF at a time with daily free-tier limits (typically 2-3 conversions per day on free tier) or paid subscriptions ($9-20/month per user). The PDF4me Power Automate action automates the same table extraction at scale: triggered by SharePoint file uploads, Outlook email attachments containing invoices or statements, Microsoft Forms responses, Dataverse record updates, OneDrive folder changes, or scheduled batch flows, and chains directly into downstream Microsoft 365 actions including Excel Online Add a row, Power BI dataset refresh, Dynamics 365 Finance record creation, Business Central, SharePoint metadata updates, and any accounting system via HTTP. Use this when you process dozens to thousands of PDFs per month consistently across the Microsoft 365 ecosystem rather than one-off ad-hoc conversions.

Convert PDF to Word

Convert PDFs to editable DOCX for narrative content, use when your PDF content is text-heavy rather than tabular data.

Convert PDF to PowerPoint

Convert PDFs to editable PPTX slide decks, pair with PDF to Excel for full Microsoft Office output automation across reports, proposals, and dashboards.

Extract Table from PDF

Extract specific table data from PDFs as structured JSON, alternative path when you need just table content without an XLSX wrapper.