PDF to Google Sheets for real estate rent rolls and T12s
Deal packages arrive as PDFs and underwriting happens in a spreadsheet. PDF to Sheets converts rent rolls, operating statements and closing statements inside Google Sheets, so the model starts with the seller's numbers and not with an afternoon of typing.
4.5 out of 5 on the Google Workspace Marketplace
| Unit | Tenant | Sq ft | Rent | Lease end |
|---|---|---|---|---|
| 101 | Alvarez | 742 | 1,495 | 03/31/27 |
| 102 | Whitfield | 742 | 1,450 | 08/31/26 |
| 103 | Vacant | 910 | 0 | |
| 104 | Okafor | 910 | 1,725 | 01/31/27 |
| 105 | Lindqvist | 1,080 | 1,940 | 11/30/26 |
The short answer
To get a rent roll or T12 into Google Sheets, open the PDF to Sheets add-on from the Extensions menu, upload the PDF and convert it to the current sheet. A rent roll becomes one row per unit, and a T12 becomes one row per income or expense line with the monthly columns across. Reconcile total rent and annual totals against the PDF before the figures go into your model.
Real estate documents that convert
Financial exhibits convert. Narrative pages do not, because there are no rows to recover.
| Document | Who uses it | What you get in the sheet |
|---|---|---|
| Rent roll | Analysts, lenders, property managers | One row per unit with tenant, size, rent and lease dates |
| T12 operating statement | Acquisitions and asset management | One row per line item with twelve monthly columns and a total |
| Closing or settlement statement | Buyers, sellers and closing attorneys | Debit and credit lines with amounts |
| Offering memorandum | Acquisitions teams | The financial tables and rent roll pages, not the marketing copy |
| Utility and tax bills | Property managers | Charge lines by period |
| Lease agreement | Lease administration | Little of use. A lease is prose, so abstract it by hand. |
Why property PDFs are awkward
Rent rolls are wide
Fifteen columns on a landscape page is normal. Copy and paste collapses them, while table detection keeps each value under its own heading.
T12s are grids of numbers
Twelve months by sixty line items is more than seven hundred figures. Keying them invites the one error that changes net operating income.
Broker packages are scans
Seller financials are often printed, marked up and scanned. OCR reads those pages so they can still be converted.
Every property system prints differently
Exports from different property management systems share no layout. The converter works from the table on the page, not from a template per system.
How to convert a rent roll or T12 to Google Sheets
Add PDF to Sheets to Google Sheets
Install it from the Google Workspace Marketplace. It takes one click and adds nothing to your computer.
Open it from the Extensions menu
In any spreadsheet, go to Extensions, choose PDF to Sheets and open the converter in the sidebar.
Upload your PDF and pick an output
Choose the file, then choose where the data should go: the current Google Sheet, an Excel file, CSV or XLS.
Convert and check the totals
The tables land as rows and columns. Compare one total against the PDF before you build on the data.
Reconciling a deal package
Converting the documents is step one. The value is in checking them against each other, which is quick once everything is in one workbook.
Rent roll checks
- Total the rent column and compare it with the rent roll footer.
- Count vacant units with
=COUNTIF(B:B,"Vacant")and compare with the stated occupancy. - Sort by lease end to see how much rent expires inside your hold period.
T12 checks
- For each line, the twelve months should sum to the annual figure. A helper column with
=SUM(B2:M2)-N2should show zero all the way down. - Rebuild net operating income from the income and expense subtotals and compare it with the figure printed on the statement.
Check them against each other
Annualise in-place rent from the rent roll (monthly total times twelve) and compare it with rental income on the T12. A wide gap usually means concessions, bad debt, recent rent increases or a rent roll from a different date. It is a question for the seller either way.
Collections
If the package includes bank statements, convert the bank statements too and compare monthly deposits with the income the T12 reports.
- Marketplace rating
- 4.5
- Installs
- 60K+
- Free to try
- 5 pages
Reviews
4.5 out of 5
Real estate: common questions
How do I convert a rent roll PDF to Google Sheets?
Open PDF to Sheets from the Extensions menu, upload the rent roll and convert it to the current sheet. Each unit lands on its own row. Total the rent column and compare it with the total printed at the foot of the rent roll.
How do I get a T12 into a spreadsheet?
Upload the trailing twelve month statement and convert it. Each income and expense line keeps its row and the months stay in columns. Check that each row's months add up to its annual total.
Can I convert a scanned offering memorandum?
Yes, for the pages that are tables. OCR reads scanned pages, so the rent roll exhibit and financial summary convert. Marketing pages and photos have no table to extract.
Can I export to Excel for my underwriting model?
Yes. Choose Excel (.xlsx) as the output and paste or link the data into your model. CSV and XLS are available too.
Why does my converted rent not total correctly?
Check for amounts stored as text and for a header row repeated at a page break, which adds a stray row. Set the column to Format > Number > Number and delete repeated headers.
Does it work with reports from my property management software?
If the software can print or export the report as a PDF with a table in it, it can be converted. No per-system setup is needed.
Related converters
- Accountants and bookkeepersConvert client bank statements, invoices and financial reports from PDF to Google Sheets, Excel or CSV. Less retyping at month end and tax time.
- Bank statementsTurn a PDF bank statement into Google Sheets, Excel or CSV rows with date, description, debit, credit and balance columns. Works on scanned statements.
- Scanned PDFs (OCR)Convert scanned PDFs and photographed pages to Google Sheets, Excel or CSV. OCR reads the page, then tables are rebuilt as rows and columns you can edit.
- ProcurementConvert supplier quotes, price lists and purchase orders from PDF to Google Sheets, Excel or CSV and compare vendors side by side without retyping.
Stop retyping PDFs into spreadsheets
Add PDF to Sheets to Google Sheets and convert your first 5 pages free.