How to balloon a drawing in Excel (and a faster free way)

If you don't own dedicated ballooning software, Excel is where most quality engineers end up. You screenshot the drawing, drop numbered circles on top, and type each characteristic into a worksheet by hand. It works — but for a part with 80 dimensions it eats half a day, and one mis-typed tolerance can fail the whole submission.

This guide shows you how to balloon a drawing in Excel properly, gives you a free template layout to copy, and then shows a faster method that auto-numbers the dimensions and builds the inspection sheet for you. By Rajadurai R, Founder — 14 years plant head experience.

What "ballooning a drawing" actually means

A ballooned drawing is an engineering drawing where every dimension, tolerance and note is tagged with a unique numbered circle — a balloon. Each balloon number maps to one row in your inspection sheet, so balloon #12 on the print equals row #12 in the report, with its nominal value, tolerance, actual measurement and pass/fail status. This is the foundation of any First Article Inspection (FAI), AS9102 Form 3, or PPAP dimensional results sheet.

Excel can hold the inspection sheet comfortably. The hard part is the drawing itself: Excel was never built to place balloons on a PDF, so you are working around the tool the entire time.

How to balloon a drawing in Excel, step by step

Step 1: Get the drawing onto the sheet

Export the drawing as an image (Insert → Pictures) or take a high-resolution screenshot of each PDF page. Lock the image so it doesn't drift: right-click the picture, Size & Properties, then "Don't move or size with cells." Zoom to 150–200% so dimension text stays readable.

Step 2: Build the balloon shapes

Insert → Shapes → Oval. Hold Shift to keep it a perfect circle. Set fill to white with a coloured outline, then add the number as text inside the shape. Copy-paste that first balloon so every balloon is identical in size. Place each one next to its dimension and, for clarity, add a thin line (Insert → Shapes → Line) as the leader.

Step 3: Number in reading order

Number top-left to bottom-right, sheet by sheet. Stay consistent — auditors expect a logical sequence, and a random order makes review slow. For a repeated feature like "4× ∅5.0", decide up front whether it is one balloon with quantity 4 or four separate balloons, and match your customer's requirement.

Step 4: Build the inspection table

On a second worksheet, create these columns. This layout doubles as a free balloon drawing template you can reuse:

Step 5: Add a pass/fail formula

In the Result column, use a simple limit check so the sheet flags out-of-tolerance values automatically. With nominal in D2, plus-tol in E2, minus-tol in F2 and actual in G2:

Where the Excel method breaks down

In my 14 years running plants, the Excel route was fine for a 20–30 characteristic part. Past that, three problems show up every time:

• Renumbering pain. Delete balloon 23 of 80 and every later number is now wrong on both the drawing and the table. There is no link between the circle and the row.
• Transcription errors. You read 5.00 off the print and type 50.0. A 5–8% error rate on hand-keyed dimensions is normal, and each error is a potential customer rejection.
• Time. An 80-dimension drawing takes 4–6 hours in Excel. Multiply by 15–30 reports a month and the cost is real.

The faster way: balloon on the drawing, export to a sheet

The shortcut is to balloon directly on the PDF and let the software keep the drawing and the table in sync. CadNexa's auto-ballooning runs in the browser and works two ways:

• Smart Detect: scans the whole drawing, finds dimensions, tolerances and GD&T callouts, and drops numbered balloons in one pass. You review and correct rather than start from zero.
• Box+Balloon OCR: draw a box around any dimension and CadNexa reads the text, parses the value and tolerance, and places the balloon with the data pre-filled.

Because the balloon and the row are linked, deleting a balloon renumbers the rest automatically. When you're done you convert the drawing straight to an inspection sheet and export it as CSV — which opens in Excel exactly like the template above, but populated for you. If you prefer to start from the PDF side, the same flow is covered in how to balloon a PDF drawing online.

When Excel is still the right call

Excel ballooning genuinely makes sense for small, simple parts, a one-off you'll never repeat, or when company policy mandates a specific spreadsheet format. The template in Step 4 plus the pass/fail formula in Step 5 will serve you well there. Tools you might also weigh up include InspectionXpert, High QA and Net-Inspect, though those are paid desktop packages aimed at higher volumes. Once you are doing FAI regularly, the time saved by ballooning on the drawing pays for itself quickly.

For more step-by-step guides, visit the CadNexa learning center and the FAI walkthrough in create FAI reports in 10 minutes.

Frequently asked questions

Is there a free balloon drawing template for Excel?

Yes — the nine-column layout in Step 4 (Char #, Zone, Type, Nominal, Tol +, Tol −, Actual, Method, Result) is a complete template. Add the pass/fail formula from Step 5 and you have a working inspection sheet. For the drawing itself you still place balloons manually as shapes, or export a populated sheet from an online balloon tool.

Can Excel place balloons on a PDF automatically?

No. Excel has no way to read a PDF drawing or detect dimensions, so every balloon is a manual shape. Automatic detection needs OCR-based ballooning software. CadNexa's Smart Detect and Box+Balloon OCR do this in the browser, then export the data to CSV for Excel.

How long does ballooning a drawing in Excel take?

Roughly 4–6 hours for an 80-characteristic drawing, including placing shapes, numbering, and typing each dimension into the table. Auto-ballooning the same drawing online and exporting to Excel typically takes under 15 minutes.

Does a ballooned drawing have to match AS9102?

AS9102 Rev C requires every design characteristic to be uniquely identified with traceable results, which is exactly what ballooning provides. Most aerospace customers expect a ballooned drawing in the FAIR package even though the standard does not word it as a hard requirement.

Is my drawing data kept private?

With CadNexa, the PDF is processed in your browser and never uploaded to a server, so your customer drawings and design IP stay on your machine.