Blog

How to convert a PDF balance sheet to Excel

How to convert a PDF balance sheet to Excel

The balance sheet highlights the financial condition of a company and is an integral part of the financial statements. It’s also called a Statement of Financial Position.

The balance sheet is a crucial document to analyse when figuring out the state of a company’s financial health, and it’s often used by investors deciding whether to invest in the company, or by creditors who are planning to lend it money.

In this post, I’ll be showing you how to convert a PDF balance sheet to Excel using PDFTables.com, so that you can perform your own balance sheet analysis in the comfort of an Excel spreadsheet.

Before we start

As an example, we’ll be converting the Nestlé Group's Consolidated Balance Sheet for 2016 (pages 8 and 9), and converting it into a single-sheet Excel document.

The Nestlé balance sheet is contained within a larger report, so in order to avoid converting the whole document, you should extract pages 8 and 9 first. We show you how to do this in another tutorial, How to extract pages from a PDF document.

Step 1

Go to PDFTables.com, and click the green Convert a PDF button.

How to open a PDF in PDFTables.com

Step 2

Find the Nestlé Group's Consolidated Balance Sheet for 2016 that you extracted earlier, and select Open.

Select a PDF to convert in Windows Explorer

Step 3

Once the conversion has completed, click the Download as Excel button.

Download the PDF as an Excel spreadsheet

Step 4

Choose a download location for your converted balance sheet, then press Save.

Save the downloaded Excel to your computer

Step 5

Open the downloaded balance sheet from the Downloads bar or notification of your browser, and you’re done! You’ve successfully converted a PDF balance sheet to Excel.

A PDF converted to Excel

Further Reading

If you’re converting PDF balance sheets to Excel on a regular basis, and you have some programming experience (or a colleague who does), you can automate these conversions with our PDF to Excel API, and integrate it directly into your in-house processes. We’ve even written a tutorial on implementing page selection with our API, if you’re feeling particularly adventurous!