Convert Rent Roll PDF to Excel and CSV
Upload a rent roll PDF and get a structured spreadsheet back in seconds. PDFXLSX reads every unit line and pulls the unit, tenant name, lease start and end dates, square footage, and monthly rent into separate Excel or CSV columns, so you can underwrite a deal, total the income, or track lease expirations without retyping a single row.
Works with rent rolls exported from Yardi, AppFolio, RealPage, Buildium, and scanned printouts. Files are encrypted and deleted after conversion.
Drop your PDF here or click to browse
PDF files up to 50MB
First conversion is free. No software to install.
The short answer
To convert a rent roll PDF to Excel, upload the PDF to a converter that reads tenant tables, then download an XLSX or CSV. A good converter keeps each unit on its own row and splits the unit, tenant name, lease start and end dates, square footage, and monthly rent into separate columns, with amounts as real numbers so the rent still totals. For scanned rent rolls, use a tool with built-in OCR, then reconcile the rent total and unit count against the original before you underwrite.
Last updated July 2026
Any System
No template needed
One Row
Per unit or lease
XLSX + CSV
Export formats
50MB
Max file size
Turn a PDF rent roll into a spreadsheet you can underwrite
The rent roll sits at the center of every property deal. It tells you who occupies each unit, how much rent they pay, when their lease ends, and how much income the property really produces. The problem is that it almost always arrives as a PDF, exported from a property management system or scanned from a broker package, and a PDF is not something you can total, sort, or model. Retyping a hundred units into Excel by hand is slow, and every keystroke is a chance to fat-finger a rent figure that flows straight into your valuation.
This converter does that work for you. It reads the rent roll unit by unit, keeps each lease on its own row, and writes the unit, tenant name, lease start date, lease end date, square footage, and monthly rent into separate columns. Amounts come out as real numbers, so gross potential rent totals correctly and the file is ready to filter, sort by expiration, and build vacancy assumptions on the moment it opens.
It is the same engine behind our brokerage statement converter and our PDF table extractor, so every document in a deal package lands in the same clean format. When the numbers arrive as text instead, our guide on fixing numbers stored as text gets the totals working again.
| Unit | Tenant | Sq Ft | Rent |
|---|---|---|---|
| 101 | Acme Design LLC | 1,240 | 3,100.00 |
| 102 | Northside Dental | 2,050 | 5,380.00 |
| 103 | Vacant | 980 | |
| 201 | Harbor Freight Co | 3,400 | 7,650.00 |
| 202 | Lakeview Studio | 1,120 | 2,900.00 |
One row per unit, with rent as real numbers that total.
Built for the people who underwrite property
Every feature targets the real work of getting a rent roll out of a PDF and into a spreadsheet you can model.
Every field in its own column
Unit, tenant, lease start, lease end, square footage, and monthly rent each land in their own column. One unit becomes one row, so the rent roll sorts, filters, and totals exactly the way your model expects.
Rent stays as numbers that total
Every rent and square footage figure comes out as a real number, not text. Sum the rent column to confirm gross potential rent, compute rent per square foot, and start underwriting, all without cleaning the data first.
Scanned rent rolls work too
Whether it is a clean export or a scanned page from a broker package, built-in OCR reads it and still returns structured rows. No retyping unit numbers and rents off a printout before you can analyze them.
Export to Excel or CSV
Download an XLSX for underwriting and analysis or a CSV ready to import into your model, portfolio tracker, or asset management system. Same clean rows, your choice of format.
Lease dates stay aligned
Lease start and end dates stay tied to the right unit, so you can sort by expiration and see your rollover schedule at a glance. Multifamily and commercial layouts both extract cleanly, whatever the source system printed.
Private and secure
A rent roll lists tenant names and lease terms. Files are encrypted in transit and at rest, processed in isolation, and deleted automatically after conversion. Nothing is stored or shared.
How to convert a rent roll to Excel
Three steps, no manual data entry required.
Upload the rent roll PDF
Drag your rent roll PDF into the box at the top of this page, or browse to select it. Exports from Yardi, AppFolio, RealPage, Buildium, and scanned broker packages up to 50MB are supported.
Let it read the units
The engine walks the rent roll unit by unit, captures each tenant, lease date, and rent figure in the right column, and applies OCR if the document is scanned. Even a large multifamily property finishes in well under a minute.
Download Excel or CSV
Review the preview, confirm the rent total matches the source, then download a clean XLSX or CSV. Open it in Excel or Google Sheets, drop it into your underwriting model, or import it into your portfolio tracker.
Who uses this converter
Anyone who receives a rent roll as a PDF but has to build something from it. If a seller, a broker, or a property manager hands you the units and rents as a printout, this is how you get them back into columns you can total and model.
-
CRE analysts and acquisitions teams underwriting a deal off a seller rent roll that only arrives as a PDF, and who need it in Excel to build gross potential rent and vacancy assumptions.
-
Commercial lenders and mortgage brokers who receive the rent roll as a PDF and need it in a spreadsheet to size a loan, test debt service coverage, and check lease rollover.
-
Property managers and asset managers pulling a rent roll out of one system to reconcile occupancy, track expirations, or migrate the data into a new platform as CSV.
-
Real estate investors and appraisers valuing a multifamily or commercial property and needing the in-place rents in Excel to run a quick income approach. See the workflow for finance teams.
Rent roll exports we convert
Any layout works, because the converter reads the structure of each document rather than a fixed template. Commercial, multifamily, and mixed-use rent rolls all extract the same way.
Rent roll to Excel: common questions
Upload your rent roll PDF to the converter at the top of this page, let it read each unit line, and download the result as an Excel file. It takes seconds and needs no software. The unit, tenant name, lease dates, square footage, and monthly rent each land in their own column, one lease per row, ready to sort, total, and model.
The fastest way is to upload the rent roll PDF here and let the converter rebuild it as a spreadsheet with one row per unit. Copying and pasting a PDF rent roll into Excel usually collapses every column into one, because a PDF stores text by position, not as a real table. A converter reads the layout and keeps each field in its own column.
A typical rent roll comes out with unit or suite, tenant name, lease start date, lease end date, square footage, monthly or base rent, and occupancy status. Some add deposit, concessions, annual rent, and rent per square foot. Each unit sits on its own row so you can total the rent, count vacancies, and sort by lease expiration.
Once the rent roll is in Excel with clean numeric columns, sum the monthly rent to get gross potential rent, count occupied versus vacant units, and sort by lease end date to see expirations. Add a column for rent per square foot with a simple formula, then build vacancy and rollover assumptions on top for underwriting.
Yes. Whether the rent roll is a clean export from a property management system or a scanned printout, built-in OCR reads it and still returns structured rows. You get the same unit, tenant, lease date, and rent columns without retyping figures off a printed page, then you reconcile the rent total against the source.
If the rent column will not sum, the amounts most likely came in as text rather than numbers, so Excel treats them as words. Select the rent column, use Data then Text to Columns and click Finish, and the values become real numbers. After that the monthly rent total should match the total printed on the original rent roll.
It is safe here because files are encrypted in transit and at rest, processed in an isolated environment, and deleted automatically once the conversion finishes. A rent roll lists tenant names and lease terms, so it is never stored long term, shared, or reused. Be cautious with free tools that keep uploads on unknown servers.
Related converters
Convert Bank Statement PDF to Excel in Seconds
Convert bank statement PDFs to Excel for fast reconciliation and bookkeeping. Preserves transaction dates, amounts, and descriptions.
Use casesConvert Invoice PDF to Excel for Faster Accounts Payable
Extract invoice data from PDF into Excel spreadsheets. Line items, totals, tax amounts, and vendor details parsed automatically.
Use casesExtract Data from PDF to Excel or Any Spreadsheet
Extract data from PDF to Excel and other spreadsheets automatically. Pull tables, line items, and form fields into clean columns, with OCR for scanned files.
Use casesConvert Financial Report PDF to Excel and Financial Statements
Convert financial report and statement PDFs to Excel with the structure intact and figures kept numeric. Balance sheets, income statements, and cash flow.
Convert your rent roll now
Drop a PDF at the top of the page and download a clean Excel or CSV in seconds. Your first conversion is free. When the deal package also includes the seller's operating statements, our sister tool converts a bank statement to Excel so you can verify actual collected rent against the rent roll. For everyday conversion of any document, start with the PDF to Excel converter.