Skip to content

Generating reports from your models

3 minutes read
| |
August 18, 2022

Share this post:

SketchUp Pro can generate tabular reports (fancy lists, basically) from the groups and components in your models. It's a simple operation, and provided you've set things up properly, it can save you a ton of time. Let's look at a pretty straightforward example: a picket fence.

I’m designing a simple wooden fence (SketchUp model) to encircle my yard. The fence is made from copies of three different components: Posts, Rails, and Pickets. Here's what it looks like:

My pickets fence is made from instances of three components.

I need to know how much lumber to buy, so I use SketchUp Pro to generate a report (File > Generate Report...) in CSV format which I can open in any spreadsheet program. I use Google Docs so that my spreadsheet is online. Take a look at the resulting raw report in its entirety, or view the screenshot below:

A CSV-format report from SketchUp Pro, imported into Google Docs' spreadsheet tool. (Click to enlarge)

Looking closely at the report, you can see that each component gets its own row and that each row contains a whole bunch of information contained in a number of columns. Each column represents a different attribute associated with the component; attributes are things like "Definition Name", "Layer" and "LenZ" (length in the Z, or blue, direction).

I'm only interested in using this report to figure out how much wood I need, so I delete all of the attribute columns except the following:

  • Definition Name: Tells me which component I'm looking at

  • LenX: Tells me the length along the X (red) axis of the component. This is important for my rails, which span horizontally.

  • LenZ: Tells me the length along the Z (blue) axis of the component. This is important for my posts and pickets, since it's their height that I'm interested in.

"LenZ" and "LenX" refer to lengths along the Z (blue) and X (red) axes, respectively.

Now my report is a lot easier to look at. To make it even clearer, I rename the columns. LenX becomes "Width" and LenZ becomes "Height". Lastly, I sort by the column "Definition Name" to group each component together. You can look at the complete, simplified report to see the whole thing. A screenshot is below:

The report after I've deleted unnecessary columns and renamed the remaining ones.(Click to enlarge)

To calculate how many feet of lumber I'll need, all I have to do is sum (add together) the relevant values for each component type:

Posts:

 Sum all values in Height (LenZ) column for all Post components

Rails:

 Sum all values in Width (LenX) column for all Rail components Pickets: Sum all values in Height (LenZ) column for all Picket components

The report lets me easily sum any range of numbers. In this case, I'm figuring out how much 4x4 (3.5 x 3.5, actually) lumber I'll need for my fence posts.

It gets better. Using custom attributes that I can assign with SketchUp Pro's Component Attributes dialog box, I can do even more. I can write a simple formula that calculates area, which would tell me how much paint to buy. I can assign a cost to each component to figure out how much this fence is going to set me back. I can create a new "Length" attribute that takes into account the kerf (thickness) of the saw blade I'll use to cut the lumber. Geeky, but 100% useful.

Stay tuned -- I'll talk about combining report generation with custom attributes in another post in a couple of weeks.

NOTE: Anticipating confusion that might ensue... The horizontal length of my fence's rails will always be LenX (red), even if I turn them 90 degrees so that they're actually oriented in the Y (green) direction. Why? Every component has its own set of axes. The width of Rail extends along the X (red) axis for that component, so I can always know its length by looking at its LenX value. Please use the comments for this post to let me know if I'm not making any sense.

Related articles

Article

Orchestrating a global design sprint for the JAL Lounge at Liverpool's Anfield football stadium

Long-distance collaboration and a short deadline complicated completion of a new hospitality lounge ...
Read full article
Article

SketchUp Pro for set design: A conversation with Andy Walmsley

Ready to hear what an Emmy award-winning set designer has to say about stage design? Join us as Andy...
Read full article
Article

Has AI leveled the visualization playing field?

Through Industry Voices, Trimble SketchUp partners with industry leaders to explore the ideas, innov...
Read full article
Attention

We tried to combine the products in your guest cart with your saved cart, but we encountered an issue while merging them. When choosing a subscription, please select either monthly or yearly as they cannot be combined. Kindly review your cart before proceeding to checkout.

Cart updated
Some items in your cart are not available for purchase in your region, so we removed them. Please review your cart before proceeding.

Items Removed:
Attention

The software you are trying to purchase is not available in your country or region.

Cart updated
The items in your cart have been updated for two reasons. Firstly, the prices now match the currency linked to your account address. Secondly, some items have been removed because they are not available for purchase in your region. Please review your cart before proceeding.

Items Removed:
Cart updated
The items in your cart have been updated for two reasons. Firstly, you've added too many of one item to your cart. Secondly, some items have been removed because they are not available for purchase in your region. Please review your cart before proceeding.

Items Removed:
Cart updated
The items in your cart have been updated for three reasons. Firstly, the prices now match the currency linked to your account address. Secondly, you've added too many of one item to your cart. Thirdly, some items have been removed because they are not available for purchase in your region. Please review your cart before proceeding

Items Removed:
Cart updated

Your currency has been changed to match the currency associated with your account address.

Cart updated

Your cart has been updated for two reasons. First, the prices now reflect the currency associated with your account address. Second, you've added too many of one item to your cart. Please review your cart before proceeding.

Cart updated

While combining the products in your guest cart with your saved cart, at least one item in your cart has exceeded the maximum allowable quantity. Please review and correct your cart before proceeding to checkout.

Attention

We were unable to access your account information. Please contact customer support for assistance.

Attention
Unable to update shopping cart information. Please refresh the page to resolve the issue. If this issue persists, please contact Trimble support.
© 2026 Trimble Inc.

Trimble is a global technology company that connects the physical and digital worlds, transforming the ways work gets done. With relentless innovation in precise positioning, modeling and data analytics, Trimble enables essential industries including construction, geospatial and transportation. Whether it's helping customers build and maintain infrastructure, design and construct buildings, optimize global supply chains or map the world, Trimble is at the forefront, driving productivity and progress.