PDF to Excel for Real Estate: Convert Rent Rolls, T12s, and Operating Statements

Upload the PDF to the converter at the top of this page and download an XLSX or CSV. It works on rent rolls, operating statements, closing statements, and any other document built on a table. Each line lands in its own row with the columns intact and the amounts as real numbers, so totals calculate the moment the file opens.

Drop the rent roll PDF into the converter above and download the spreadsheet. Unit, tenant, lease start, lease end, square feet, and monthly rent each keep their own column, one row per unit. Once it is in Excel you can total in-place rent, filter by expiration date, and build a rollover schedule.

Upload the trailing twelve month operating statement and download an XLSX. The converter keeps every income and expense line on its own row and preserves the twelve monthly columns plus the annual total. Because the figures come out as numbers rather than text, effective gross income and net operating income sum correctly right away.

At a minimum you need the rent roll, the trailing twelve month operating statement, and recent bank or lender statements to verify collections. Most deal packages add a property tax bill, insurance quote, and capital expenditure history. Nearly all of them arrive as PDFs, which is why analysts spend so much time retyping them into a model.

Yes, for the parts that are tables. Built-in OCR reads scanned pages, so the rent roll exhibit, the financial summary, and the expense schedule inside an offering memorandum extract into rows. Narrative pages and marketing photos have no table structure to recover, so the converter focuses on the financial exhibits that matter.

Almost always because the amounts came across as text instead of numbers, so Excel refuses to add them. Select the column, choose Data then Text to Columns and click Finish, and the values become real numbers. After that, check for a repeated header row from a page break, which quietly inflates a unit count or a subtotal.

It is safe here. Files are encrypted in transit and at rest, processed in an isolated environment, and deleted automatically once the conversion finishes. Rent rolls carry tenant names and operating statements carry ownership financials, so nothing is stored long term, shared, or reused. Be careful with free tools that keep uploads on unknown servers.

Most start with Adobe Acrobat or copy and paste, then move to a purpose-built converter once a wide rent roll or a twelve month grid shifts columns. What matters for property documents is that the row structure survives, scans are readable, and amounts stay numeric, because a single misread figure flows straight into net operating income and valuation.