AnalysisMicrosoft Excel

Lease Roll Builder

By Angel Campa, Founder · Updated March 2026 · Saves 3–6 hours per property vs. manual abstraction

The Problem

Building a lease roll from a set of PDF lease documents requires extracting tenant name, premises, rent, term, and options from each document and assembling them into a single spreadsheet. Without extraction tooling, this is a days-long manual project for any property with more than a handful of tenants.

Step-by-Step Workflow

  1. 1
    Collect all executed lease PDFsSource

    Gather all executed lease PDFs for the property, including amendments and side letters.

  2. 2
    Upload all PDFs to LextractLextract

    Upload each lease PDF to Lextract for batch processing.

  3. 3
    Extract rent roll fields for each tenantLextract

    Lextract extracts tenant name, suite or unit, RSF, base rent, lease commencement, lease expiration, renewal options, and security deposit — the standard columns in a commercial rent roll.

  4. 4
    Export consolidated rent rollDestination

    Download all lease abstracts as a single Excel export with one row per tenant and standard rent roll column headers.

  5. 5
    Format and validate the final rent rollDestination

    Review the assembled rent roll for completeness. Add calculated columns: remaining term, annualized rent, and expiration year bucket. Validate total RSF against the building RSF.

Who Uses This Workflow

Property ManagersAcquisition TeamsPortfolio Managers

How Lextract integrates with Microsoft Excel

Learn about the full integration between Lextract and Microsoft Excel, including supported export formats and critical fields.

View Microsoft Excel integration →

Frequently Asked Questions

What columns does a standard commercial rent roll include?

A standard commercial rent roll includes tenant name, suite/unit, rentable square feet, lease commencement, lease expiration, current base rent, rent per SF, escalation schedule, renewal options, and security deposit. Lextract extracts all of these fields.

How do I handle multiple floors or suites for the same tenant?

Each executed lease produces one abstract row. For tenants with multiple suites under separate leases, each lease is processed separately and appears as a separate row that can be merged in Excel.

Related Workflows

Related Articles

Related Resources

Start the Lease Roll Builder workflow

Upload your lease PDF and get 125+ structured fields ready to import into Microsoft Excel. Just $20 per lease — no subscription required.

Start Extracting — $20/lease