Tabular Data Extraction

Requirements

These packages are required to use these features in production. Trial keys have unlimited access to all features

Package: Smart Data ExtractionModule: Data ExtractionLive demo

Apryse's Tabular Data Extraction engine transforms PDFs with tables into clean, structured outputs you can use in spreadsheets, analytics tools, or downstream systems. Whether you're processing invoices, reports, or research data, this engine helps you turn visual tables into machine-readable formats.

How It Works

The engine detects the row and column structure across pages and consolidates all text into a structured table. It's designed to handle both native and scanned PDFs with a strong focus on numerical and tabular data.

You can export the data as:

• JSON (ideal for programmatic use)
• Excel (XLSX) (ideal for business workflows)

JSON Output Specification

Refer to the following specifications to learn more about the output JSON format:

• JSON Specification for Tabular Data and Document Structure

Extract tabular data as JSON file

Specify the name of the input PDF file and the name of the output JSON file, then select the Tabular engine:

C#

DataExtractionModule.ExtractData("table.pdf", "table.json", DataExtractionModule.DataExtractionEngine.e_tabular);

C++

DataExtractionModule::ExtractData("table.pdf", "table.json", DataExtractionModule::e_Tabular);

Go

DataExtractionModuleExtractData("table.pdf", "table.json", DataExtractionModuleE_Tabular)

Java

DataExtractionModule.extractData("table.pdf", "table.json", DataExtractionModule.DataExtractionEngine.e_tabular);

JavaScript

await PDFNet.DataExtractionModule.extractData('table.pdf', 'table.json', PDFNet.DataExtractionModule.DataExtractionEngine.e_Tabular);

PHP

DataExtractionModule::ExtractData("table.pdf", "table.json", DataExtractionModule::e_Tabular);

Python

DataExtractionModule.ExtractData("table.pdf", "table.json", DataExtractionModule.e_Tabular)

Ruby

DataExtractionModule.ExtractData("table.pdf", "table.json", DataExtractionModule::E_Tabular)

VB

DataExtractionModule.ExtractData("table.pdf", "table.json", DataExtractionModule.DataExtractionEngine.e_tabular)

Extract tabular data as JSON string

If you are going to parse the JSON right away, you may as well retrieve it as an in-memory string, instead of an external file.

Specify the name of the input PDF file, then select the Tabular engine:

C#

string json = DataExtractionModule.ExtractData("financial.pdf", DataExtractionModule.DataExtractionEngine.e_tabular);

C++

UString json = DataExtractionModule::ExtractData("financial.pdf", DataExtractionModule::e_Tabular);

Go

json := DataExtractionModuleExtractData("financial.pdf", DataExtractionModuleE_Tabular).(string)

Java

String json = DataExtractionModule.extractData("financial.pdf", DataExtractionModule.DataExtractionEngine.e_tabular);

JavaScript

const json = await PDFNet.DataExtractionModule.extractDataAsString('financial.pdf', PDFNet.DataExtractionModule.DataExtractionEngine.e_Tabular);

PHP

$json = DataExtractionModule::ExtractData("financial.pdf", DataExtractionModule::e_Tabular);

Python

json = DataExtractionModule.ExtractData("financial.pdf", DataExtractionModule.e_Tabular)

Ruby

json = DataExtractionModule.ExtractData("financial.pdf", DataExtractionModule::E_Tabular)

VB

Dim json As String = DataExtractionModule.ExtractData("financial.pdf", DataExtractionModule.DataExtractionEngine.e_tabular)

Extract tabular data as Excel file

Specify the name of the input PDF file and the name of the output XLSX file:

C#

DataExtractionModule.ExtractToXLSX("table.pdf", "table.xlsx");

C++

DataExtractionModule::ExtractToXLSX("table.pdf", "table.xlsx");

Go

DataExtractionModuleExtractToXLSX("table.pdf", "table.xlsx")

Java

DataExtractionModule.extractToXLSX("table.pdf", "table.xlsx");

JavaScript

await PDFNet.DataExtractionModule.extractToXLSX('table.pdf', 'table.xlsx');

PHP

DataExtractionModule::ExtractToXLSX("table.pdf", "table.xlsx");

Python

DataExtractionModule.ExtractToXLSX("table.pdf", "table.xlsx")

Ruby

DataExtractionModule.ExtractToXLSX("table.pdf", "table.xlsx")

VB

DataExtractionModule.ExtractToXLSX("table.pdf", "table.xlsx")

Extract tabular data as Excel stream

Specify the name of the input PDF file and an output filter, such as MemoryFilter:

C#

MemoryFilter output_xlsx_stream = new MemoryFilter(0, false);
DataExtractionModule.ExtractToXLSX("financial.pdf", output_xlsx_stream);

C++

MemoryFilter output_xlsx_stream(0, false);
DataExtractionModule::ExtractToXLSX("financial.pdf", output_xlsx_stream);

Go

outputXlsxStream := NewMemoryFilter(0, false)
DataExtractionModuleExtractToXLSX("financial.pdf", outputXlsxStream)

Java

MemoryFilter output_xlsx_stream = new MemoryFilter(0, false);
DataExtractionModule.extractToXLSX("financial.pdf", output_xlsx_stream);

JavaScript

const outputXlsxStream = PDFNet.Filters.MemoryFilter(0, false);
await PDFNet.DataExtractionModule.extractToXLSX('financial.pdf', outputXlsxStream);

PHP

$outputXlsxStream = new MemoryFilter(0, false);
DataExtractionModule::ExtractToXLSX("financial.pdf", $outputXlsxStream);

Python

outputXlsxStream = Filters.MemoryFilter(0, False)
DataExtractionModule.ExtractToXLSX("financial.pdf", outputXlsxStream)

Ruby

outputXlsxStream = Filters.MemoryFilter.new(0, false)
DataExtractionModule.ExtractToXLSX("financial.pdf", outputXlsxStream)

VB

Dim output_xlsx_stream As MemoryFilter = New MemoryFilter(0, False)
DataExtractionModule.ExtractToXLSX("financial.pdf", output_xlsx_stream)

Optional Configuration

Select OCR Language

Password-Protected PDFs

Page Range

Best Use Cases

• Financial statements
• Invoices and billing reports
• Research tables
• Survey exports
• Any document where tabular data is the core structure