ExpertPdf Anywhere v22.0.0

PDF to Excel Converter for .NET

Convert the tables of PDF documents to Excel workbooks (XLSX) from C# and VB.NET. The tables are found from their rules or their aligned columns, and each becomes cells: numbers, percentages, currency amounts and dates as typed values with a number format, text as text.

The PDF to Excel converter is part of ExpertPdf Anywhere, the .NET library with every ExpertPdf tool. It runs in the application's process on Windows, Linux and macOS, with no native engine and no Microsoft Office.

NuGet · ExpertPdf.Anywhere C# & VB.NET samples
Input PDF file or stream
Output XLSX with typed cells
Package ExpertPdf.Anywhere only

Everything PDF to Excel does.

How the tables of the PDF are found and read, and how the workbook is written.

Reading the tables

What is recognized.

The tables of the pages, with the values of their cells.

Ruled and unruled tables

Tables are found from their rules or from their aligned columns.

Typed values

Numbers, percentages, currency amounts and dates as typed values with a number format; text as text.

Number formats of a culture

Culture reads the numbers as a culture writes them, for example 1.234,50 with "de-DE".

Pages and passwords

Convert a range of pages with StartPageNumber and EndPageNumber; open a protected document with UserPassword.

Writing the workbook

What comes out.

An XLSX workbook, to a file or as bytes.

Table formatting

Header rows bold and frozen, merged cells merged, with the shading, borders and column widths of the PDF.

A sheet per table or per page

PdfToExcelSheets.PerTable (the default) or PdfToExcelSheets.PerPage, with Sheets.

Text and pictures

The text outside the tables on a worksheet of its own (TextOutsideTables), and the document's pictures (Images).

A file or bytes

ConvertToExcelFile from a PDF file or stream to a file; ConvertToExcel returns the workbook as bytes.

In the application's process

No native engine and no platform package: only ExpertPdf.Anywhere, on Windows, Linux and macOS.

The tables of a PDF, in Excel.

Create a PdfToExcelConverter from the ExpertPdf.Anywhere namespace, choose how the sheets are made, and convert. The tabs write a worksheet for each table, and a worksheet for each page of a German statement.

Program.cs · C#
using ExpertPdf.Anywhere;

var converter = new PdfToExcelConverter();
// converter.LicenseKey = "your license key";

// A worksheet for each table (the default)
converter.Sheets = PdfToExcelSheets.PerTable;

converter.ConvertToExcelFile("statement.pdf", "statement.xlsx");

Install with dotnet add package ExpertPdf.Anywhere. The PDF to Word, Excel and PowerPoint topic describes every option, and the online sample converts a sample PDF or your own to a workbook. To create and edit workbooks, see the ExpertXLS Excel Library.

PDF to Excel questions, answered.

Common questions about tables, cell values, sheets and licensing.

How are the tables found?
From their rules or their aligned columns, so tables drawn with lines and tables laid out only with spacing are both found.
Are the numbers real numbers in Excel?
Yes. Numbers, percentages, currency amounts and dates become typed values with a number format, and text stays text, so the workbook can be summed, sorted and filtered. Culture reads the numbers as a culture writes them, for example 1.234,50 in a German document with "de-DE".
Is the formatting of the tables kept?
Header rows are bold and frozen, merged cells are merged, and the cells have the shading, borders and column widths of the PDF.
A worksheet for each table or for each page?
Sheets puts each table on a worksheet of its own (PdfToExcelSheets.PerTable, the default) or each page (PdfToExcelSheets.PerPage).
What happens with the text that is not in a table?
TextOutsideTables writes it on a worksheet of its own, and Images keeps the document's pictures; both are on by default.
Does it need Microsoft Excel or a native engine?
No. PdfToExcelConverter runs in the application's process on Windows, Linux and macOS, with only the ExpertPdf.Anywhere package: no Office and no platform package.
Can it convert a password protected PDF or only some pages?
Yes. Set UserPassword to the user or the owner password, and StartPageNumber and EndPageNumber to the pages to convert. A document that cannot be read or converted throws PdfToExcelException.
How is it licensed?
PDF to Excel is part of ExpertPdf Anywhere, with every other ExpertPdf tool, from $700. Without a license key it runs in demo mode and each converted file carries an evaluation line. License it on the pricing page.

Convert PDF to Excel from .NET.

Install ExpertPdf Anywhere from NuGet and try every feature in evaluation mode. License it on the pricing page when you are ready.

Targets.NET Standard 2.0 · .NET 8 · .NET 10 · Windows · Linux · macOS
Versionv22.0.0