Door Hardware Schedule Extraction

Extract Door Hardware Schedules from PDF to Excel, Without Re-typing

Conversant turns Division 08 hardware schedules and specifications into a structured take-off. Upload the PDF and get back an Excel workbook with every hardware set, door, manufacturer, model, finish and quantity, plus the issues an estimator should check before pricing.

PDF upload. No account needed. Results by email.

What do you get from a hardware schedule PDF?

One Excel workbook with four tabs. Every door and every hardware item carries the page it was read from, so a reviewer can check any line against the original before it goes into the estimate.

Hardware Set Items

Every line of every hardware set, with the doors that carry the set.

  • Set ID
  • Doors
  • Fire Rating (min)
  • Description
  • Manufacturer
  • Model
  • Finish
  • Size
  • Handing
  • Quantity
  • Notes
  • Page

Door Schedule

Every opening, linked to its hardware set.

  • Doors
  • Door Width / Height / Thickness
  • Material
  • Fire Rating (min)
  • Location From / To
  • Frame Type
  • Frame Material
  • Door Type
  • Handing
  • Hardware Set ID
  • Page

Take-off

Quantities rolled up across doors, with part numbers and list prices where the brand is covered.

  • Category
  • Manufacturer
  • Model
  • Finish
  • Description
  • Quantity
  • Resolved MPN
  • Unit Price
  • Ext. Price
  • Confidence
  • Hardware Sets
  • Doors
  • Needs Input

Review Flags

What needs a second look, ranked by severity.

  • Flag Type
  • Severity
  • Set ID
  • Doors
  • Field
  • Reason
  • Raw Text
  • Page

Why are hardware schedules hard to extract from PDFs?

Hardware schedules are rarely clean tables. Their layout changes with every architect and hardware consultant, so pulling out the text isn't enough: the result has to keep which item belongs to which set, and which set goes on which door.

Merged columns

Quantity and description share a cell, or a header spans several columns. Table boundaries disappear when the PDF is converted.

Wrapped descriptions

A product description wraps onto a second row, and the manufacturer, model and finish end up separated from the item they belong to.

Many sets, many formats

A large package holds dozens of hardware sets, often formatted differently by the architect and the hardware consultant. Each one needs its own cleanup.

Missing or misread lines

Generic converters drop rows or read a note as a hardware item, and the error carries straight into the take-off quantities.

How does a PDF hardware schedule become a take-off?

1

Upload the PDFs

Hardware schedules, door schedules, the Division 08 specification, drawings. Up to ten files, 50 MB each.

2

Read sets and doors

Each hardware set is read line by line: quantity, description, manufacturer, model, finish, size and handing, with the page it came from.

3

Link and check

Doors are matched to their hardware sets, even across files, and every opening is checked against the rules below. Problems become flags, not silent edits.

4

Get the workbook

An Excel workbook arrives by email with the door schedule, hardware sets, take-off and review flags.

Each page is read the way it was produced: text PDFs through layout analysis, scans and oversized sheets visually, and CAD-drawn tables rebuilt from their ruling lines. When a set runs across a page break, its heading is carried onto the next page so no row loses its set.

More than PDF-to-Excel conversion

A converter gives you a spreadsheet of the text. A take-off also has to know that the items under a set heading belong together, that the set goes on specific doors, and that the quantities follow from both. Conversant links doors to sets, multiplies each item by the doors that carry its set, and checks every opening. Problems are flagged for the estimator; quantities are never changed silently.

Checks that run on every upload

  • Hinge count against door height: at least 3 hinges per leaf up to 84", 4 up to 96", 5 up to 108", 6 above that
  • Fire-rated openings whose hardware set lists no fire-rated or labeled hardware
  • Doors with no hardware set, and doors pointing to a set the schedule doesn't contain
  • Hardware sets applied to zero doors
  • Take-off quantities that don't match the schedule, and items counted twice
  • Duplicate door tags with conflicting data
  • Pairs with vertical rod devices but no coordinator
  • Electrified hardware with no power transfer or power supply in the set
  • Missing manufacturer, model, finish or door dimensions

The checks need the information to be in the documents. A hinge count can only be checked when the door height is printed, and a missing height is itself flagged.

Extraction is the first step of the bid

  1. PDF schedules and specs
  2. Hardware sets
  3. Doors linked to sets
  4. Checked take-off
  5. Quoting system

The same upload runs the full Bid Response Automation workflow. The take-off resolves extracted lines to manufacturer part numbers and list prices where the brand is covered, and marks the lines that need more input. With a Conversant account you can edit hardware sets and recalculate the take-off, export the door schedule and hardware sets as PRO-TECH import files, and export the door schedule as a Comsense file.

Why schedules arrive in so many formats, and what it takes to get from a schedule line to an orderable part number: why hardware schedules never arrive order-ready.

Hardware schedule extraction FAQs

How do I extract a door hardware schedule from a PDF into Excel?

Upload the PDF: the hardware schedule, the door schedule, the Division 08 specification, or the whole bid package. Conversant reads every hardware set and door, links each door to its set, and emails back an Excel workbook with four tabs: Door Schedule, Hardware Set Items, Take-off, and Review Flags. Review the flags, then carry the take-off into your estimate. No account is needed.

Can AI extract hardware sets from Section 08 71 00 specifications?

Yes. Hardware sets printed in the Door Hardware section are read the same way as a stand-alone hardware schedule: set number, item quantity, description, manufacturer, model and finish. When a package has no hardware schedule at all, Conversant builds the sets from the specification text instead, and those results deserve a closer review because the specification describes products rather than listing them line by line.

Can Conversant extract manufacturer, model, finish, and quantity?

Yes, along with size, handing, notes and the source page for every item. Manufacturer abbreviations are kept as printed. When the schedule leaves the manufacturer, model, finish or door dimensions blank, the Review Flags tab records it so the gap is visible before pricing.

How does Conversant handle multiline descriptions and merged PDF columns?

Each page is read the way it was produced. Text PDFs go through layout analysis, scanned and oversized sheets are read visually, and tables drawn in CAD are rebuilt from their ruling lines. Stacked headers, merged column bands and door lists that wrap onto a second line are handled when the table is parsed. When a set runs across a page break, its heading is carried onto the next page so no row loses its set. Every item keeps its source page, so a reviewer can check any line against the original.

Can I use the extracted hardware sets in Comsense or PRO-TECH?

With a Conversant account, the door schedule and hardware sets export as PRO-TECH import files, and the door schedule exports as a Comsense file of openings with size, hardware set, material, fire rating and location. The Comsense file carries openings, not hardware line items. The free upload returns the Excel workbook only.

Can I upload a complete bid package instead of a single hardware schedule?

Yes. Upload up to ten PDFs of up to 50 MB each: hardware schedules, door schedules, specifications, drawings and addenda. Doors from one file are matched to hardware sets from another, and the take-off counts each item once per door that carries its set. This is the same workflow as Bid Response Automation.

Stop rebuilding hardware schedules by hand

Upload a hardware schedule or a Division 08 specification from a current or recent project. We'll email back the structured, checked workbook. No account required.

Bid package documents

Your files are processed securely and never shared.