How-to guide · how to extract block attributes in autocad

How to extract block attributes to a schedule in AutoCAD

DWGDXFFree1,231 words

By Saumyajit Maity · Published 19 Nov 2023 · Updated 29 Mar 2025

When your blocks carry attributes — a door number, a furniture code, a luminaire type, a room name — the drawing is quietly holding a database. Attribute extraction is how you get that data out: AutoCAD reads every attributed block and writes the values into a table on the sheet or an external file like Excel or CSV. The result is a door schedule, a furniture schedule, a window schedule or a fittings list, generated from the drawing rather than typed up by hand.

The tool is the Data Extraction wizard, run with the EATTEXT or DATAEXTRACTION command, and it walks you through choosing which blocks, which properties and where the output goes. This guide takes you through the wizard step by step, then covers keeping the schedule linked so it updates when the drawing changes, and the common reasons an extraction comes out empty or wrong.

The prerequisite is that your blocks actually have attributes; if they are plain geometry blocks, there is nothing to extract beyond counts and basic properties — though even those can be useful.

Step 1 — Start the Data Extraction wizard

Type DATAEXTRACTION (or the older alias EATTEXT) and press Enter. The wizard opens and first asks you to create a new extraction or use a previous template (.dxe). Choose 'Create a new data extraction', give the file a name and location when prompted, and click Next. The .dxe file stores all your choices so you can re-run the same extraction later in seconds — invaluable when a schedule must be regenerated each time the drawing updates.

This first save feels like a detour, but it is what makes attribute extraction repeatable. Name the .dxe after the schedule it produces — 'door-schedule.dxe', 'fittings-list.dxe' — so it is obvious which extraction belongs to which table.

Step 2 — Choose the drawings and the blocks

Next the wizard asks which drawings to extract from. You can extract from the current drawing, selected objects, or several drawings at once — extracting from a whole sheet set is how you build a project-wide schedule across many plans. Pick your scope and continue.

The wizard then lists every block in the selected drawings. Tick only the blocks you want in this schedule — for a door schedule, just the door block; untick furniture, symbols and everything else so they don't clutter the output. If you only want attributed blocks, filter the view to show those. Narrowing the selection here is what keeps the resulting table focused and readable rather than a dump of every block in the file.

Step 3 — Pick the properties (attributes) to include

Now choose which properties of those blocks to extract. The wizard offers attributes (your custom fields like 'Width', 'Fire rating', 'Door no'), geometry properties (position, rotation, scale) and general properties (layer, colour). For a schedule you usually want the attributes plus maybe the layer or a count column; untick the dozens of geometry properties you don't need.

This is the heart of the extraction — the columns of your schedule are exactly the properties you tick here. Order and rename them on the next page so the table reads like a proper schedule (a 'Door No.' column, a 'Size' column, a 'Fire rating' column) rather than raw property names. You can also combine identical rows into a quantity count, so ten identical doors show as one row with a count of 10.

Step 4 — Choose the output: table or external file

Finally, decide where the data goes. You can insert it as an AutoCAD table directly onto the sheet — the usual choice for a schedule that lives on the drawing — and pick a table style so it matches your other tables. Or you can output to an external file: XLS for Excel, CSV for any spreadsheet, MDB or TXT for other tools. Choosing both an on-sheet table and an external file at once is common when the design team wants the schedule on the drawing and procurement wants a spreadsheet.

Finish the wizard and place the table in the drawing if you chose that option. You now have a schedule built entirely from the blocks' own data — no manual typing, no transcription errors, and a clear audit trail back to each block in the model.

Keeping the schedule live

An extracted table can be linked so it tracks the drawing. When you insert the data as an AutoCAD table, AutoCAD can keep it associated with the extraction, so if you add doors, change an attribute, or delete a block, you can update the table rather than rebuilding it. Right-click the table or re-run the saved .dxe and choose update, and the schedule re-reads the current blocks.

This live link is the real prize: the schedule is no longer a snapshot that drifts out of date the moment someone moves a wall. Treat the blocks and their attributes as the single source of truth, and let the table be a view onto that data. When a reviewer queries a quantity, you regenerate rather than recount, and the drawing and its schedule never disagree.

Why an extraction comes out empty or wrong

A handful of issues account for most failed extractions. First and most common: the blocks have no attributes, so there is nothing to pull beyond counts — confirm with the ATTDISP or BATTMAN tools that the blocks really carry attribute data. Second, you unticked the relevant blocks or attributes in the wizard, so the columns came out blank; step back and make sure the right blocks and properties are selected. Third, exploded blocks won't appear, because extraction reads block references, not loose geometry or burst text.

Other traps: attributes that are present but empty (someone skipped the prompt on insertion) show as blank cells — fix the source blocks with BATTMAN or by editing each instance. And if a count looks doubled, suspect duplicate stacked blocks, exactly as with the COUNT command. Clean the blocks, confirm the attributes hold real values, and re-run the saved .dxe; a tidy, consistently-attributed set of blocks extracts into a clean schedule every time.

Free download

Browse the full library — DWG & DXF, no signup.

Download CAD blocks

Questions

Frequently asked

Which command extracts block attributes in AutoCAD?+

Use DATAEXTRACTION (older alias EATTEXT) to open the Data Extraction wizard. It walks you through choosing the blocks, the attributes and other properties to pull, and whether to output an on-sheet table or an external file like Excel or CSV.

Can I export block attributes to Excel?+

Yes. In the final step of the Data Extraction wizard, choose an external output and select XLS for Excel or CSV for any spreadsheet. You can also insert an AutoCAD table on the sheet at the same time, so the design team and procurement both get the schedule.

Why is my attribute extraction coming out blank?+

Usually the blocks have no attributes, or the attributes are present but empty because someone skipped the prompt on insertion. Confirm with BATTMAN that the blocks carry real attribute values, and check you ticked the right blocks and properties in the wizard. Exploded blocks won't extract at all.

Does the extracted schedule update when the drawing changes?+

It can. If you insert the data as an AutoCAD table linked to the extraction, you can update the table after adding, editing or deleting blocks rather than rebuilding it. Re-running the saved .dxe file re-reads the current blocks and refreshes the schedule.

Related downloads