Convert the emailed PDF documents from suppliers received today into editable Excel files, extract vendor name, invoic…
Open your PDF file in Adobe Acrobat.
Select the Export PDF tool from the right pane.
Choose Spreadsheet as the export format.
Select either Microsoft Excel Workbook (*.xlsx) or Comma Separated Values (*.csv) as your output format.
Click Export.
If prompted, specify the location and file name for the exported file, then save.
Open the exported file in Excel or your preferred spreadsheet application to review and analyze the extracted table data.
Best practiceIf tables are not extracted cleanly, try using the 'Organize Pages' tool to split the PDF into smaller sections before exporting, as some blogs suggest this improves accuracy for complex layouts.
You can preview the table structure in the export dialog before saving to ensure the data is being recognized correctly.
This runs in the Acrobat app - there is no separate API for this task.
The PDF Extract API can work with both native (digital) and scanned PDFs. It uses Sensei, which is Adobe's AI technology, to understand the content. You just send your scanned PDF to the API, and it will process it and return structured data, even if the original was a scan.
| Feature | Purpose | Direction |
|---|---|---|
| PDF Extract API | Turns PDFs into structured data (JSON, Markdown) | PDF -> Data |
| Document Generation API | Creates PDFs or Word documents from data and templates | Data -> PDF/Word |
Using the PDF Extract API is much better for large amounts of data. Copying and pasting is slow and can lose the structure of tables or reading order. The API automatically gives you structured data like JSON, which is easy for other computer programs to use and analyze.
The PDF Extract API is very good at identifying tables within your PDF. When you extract data, it can convert these tables into formats like CSV or XLSX. This means you get your table data in a spreadsheet format, which is easy to open and work with in programs like Microsoft Excel.