---
title: How to Upload Assemblies from Excel into Estimation
description: With Takeoff and Estimation, you can upload your own library of assemblies directly into the Assemblies tab using a simple Excel template. This allows you to quickly add multiple assemblies at once, saving time compared to creating them manually.
---
[Skip to content](https://knowledgebase.planhub.com/knowledge/uploading-assemblies-from-excel#main-content)
English
Show submenu for translations
[Submit a Ticket](https://knowledgebase.planhub.com/knowledge/kb-tickets/new?hsLang=en)
![NEW\_PlanHub\_Logo\_Navy.png\]](https://knowledgebase.planhub.com/hs-fs/hubfs/Design/PH%20Logos/NEW%202024%20PH%20Logos/NEW_PlanHub_Logo_Navy.png?height=40&name=NEW_PlanHub_Logo_Navy.png)
- [Have an Issue? Submit a Ticket](https://knowledgebase.planhub.com/knowledge/kb-tickets/new)
Open main navigation
Close main navigation
- [Have an Issue? Submit a Ticket](https://knowledgebase.planhub.com/knowledge/kb-tickets/new)
- English
Show submenu for translations
- [Submit a Ticket](https://knowledgebase.planhub.com/knowledge/kb-tickets/new)
What can we help you with?
- There are no suggestions because the search field is empty.
1. [Knowledge Base](https://knowledgebase.planhub.com/knowledge?hsLang=en)
2. [Takeoff & Estimation](https://knowledgebase.planhub.com/knowledge/takeoff-estimation?hsLang=en)
3. [Estimating](https://knowledgebase.planhub.com/knowledge/takeoff-estimation?hsLang=en#estimating)
# How to Upload Assemblies from Excel into Estimation
## With Takeoff & Estimation, you can upload your own library of assemblies directly into the Assemblies tab using a simple Excel template. This allows you to quickly add multiple assemblies at once, saving time compared to creating them manually.
Upload Assemblies via XLS in the Estimation System
Easily upload custom assemblies using an XLS template right from the estimation system. Follow these streamlined steps to make your workflow faster and more organized.
Prerequisite: You have to have a subscription that includes Takeoff & Estimation to add assemblies.
**Step 1:** Go to the **Takeoff** page.
- Click the **project name** from your Takeoff list to open it in order to access the Assembly area.
- Once the project loads, select the **Assembly** tab.
**Step 2:** In the upper right, click **Add Assembly**.
**Step 5:** Choose **Upload XLS**.
**Step 6:** Download the provided **template** to get started.
The template has three tabs:
- **Read Me**: Step-by-step instructions for completing the file.
- **Example**: Sample filled-out templates for reference.
- **Template**: The sheet you’ll populate with your data. 
**Step 7:** Enter your assembly details—name it on the assembly line (like "Shingled Roof"), and measurement type.
**Step 8:** Add all cost items (shingles, underlayment, nails, etc.). Make sure to fill out the required fields—look for red columns or asterisks at the top.
**Step 9:** Enter the necessary formulas. If you forget a formula or required field, you’ll see an exclamation point in a red circle after upload, signaling you need to complete something before the assembly can be used.
**Step 10:** Save your filled-out XLS file on your computer.
**Step 11:** Back in the estimation system, click **Add Assembly** again, then **Upload XLS**.
**Step 12:** Browse to your saved file, select it, and click **Open**, followed by **Upload**.
**Step 13:** Check that your new assembly appears at the top of the list, named as you set it (e.g., "Shingle Roof").
**Step 14:** To inspect your assembly's details, click the **pencil** icon to enter edit mode.
**Step 15:** Review the included items and formulas by clicking the **FX** button. Adjust or test formulas as needed.
Your uploaded assembly is now ready to use. It appears in your takeoff list and can be paired with any measurements you make using the slope tool.
Upload assemblies via XLS for more efficient project setups and consistent, error-free estimating.
- [General Contractor](https://knowledgebase.planhub.com/knowledge/general-contractor?hsLang=en#main-content)
- [Overview](https://knowledgebase.planhub.com/knowledge/general-contractor?hsLang=en#overview)
- [Projects](https://knowledgebase.planhub.com/knowledge/general-contractor?hsLang=en#projects)
- [Networking](https://knowledgebase.planhub.com/knowledge/general-contractor?hsLang=en#networking)
- [Subcontractors](https://knowledgebase.planhub.com/knowledge/subcontractors?hsLang=en#main-content)
- [Overview](https://knowledgebase.planhub.com/knowledge/subcontractors?hsLang=en#overview)
- [Projects](https://knowledgebase.planhub.com/knowledge/subcontractors?hsLang=en#projects)
- [Bid Board & Tracking](https://knowledgebase.planhub.com/knowledge/subcontractors?hsLang=en#bid-board-tracking)
- [Networking](https://knowledgebase.planhub.com/knowledge/subcontractors?hsLang=en#networking)
- [Takeoff & Estimation](https://knowledgebase.planhub.com/knowledge/subcontractors?hsLang=en#takeoff-estimation)
- [Manage Your Team](https://knowledgebase.planhub.com/knowledge/subcontractors?hsLang=en#manage-your-team)
- [Account & Settings](https://knowledgebase.planhub.com/knowledge/subcontractors?hsLang=en#account-settings)
- [Job Board](https://knowledgebase.planhub.com/knowledge/subcontractors?hsLang=en#job-board)
- [Request for Information](https://knowledgebase.planhub.com/knowledge/subcontractors?hsLang=en#request-for-information)
- [Supplier](https://knowledgebase.planhub.com/knowledge/supplier?hsLang=en#main-content)
- [Overview](https://knowledgebase.planhub.com/knowledge/supplier?hsLang=en#overview)
- [Projects and Leads](https://knowledgebase.planhub.com/knowledge/supplier?hsLang=en#projects-and-leads)
- [Bidding & Estimating](https://knowledgebase.planhub.com/knowledge/supplier?hsLang=en#bidding-estimating)
- [Networking](https://knowledgebase.planhub.com/knowledge/supplier?hsLang=en#networking)
- [Account & Settings](https://knowledgebase.planhub.com/knowledge/supplier?hsLang=en#account-settings)
- [Takeoff & Estimation](https://knowledgebase.planhub.com/knowledge/takeoff-estimation?hsLang=en#main-content)
- [Getting Started](https://knowledgebase.planhub.com/knowledge/takeoff-estimation?hsLang=en#getting-started)
- [Takeoff Tools & Measurements](https://knowledgebase.planhub.com/knowledge/takeoff-estimation?hsLang=en#takeoff-tools-measurements)
- [Trade-Specific Takeoffs](https://knowledgebase.planhub.com/knowledge/takeoff-estimation?hsLang=en#trade-specific-takeoffs)
- [Estimating](https://knowledgebase.planhub.com/knowledge/takeoff-estimation?hsLang=en#estimating)
- [Managing & Sharing Your Work](https://knowledgebase.planhub.com/knowledge/takeoff-estimation?hsLang=en#managing-sharing-your-work)
- [Account & Billing](https://knowledgebase.planhub.com/knowledge/account-billing?hsLang=en#main-content)
- [Account & Billing](https://knowledgebase.planhub.com/knowledge/account-billing?hsLang=en#account-billing)
- [Account Closure](https://knowledgebase.planhub.com/knowledge/account-billing?hsLang=en#account-closure)
- [Troubleshooting](https://knowledgebase.planhub.com/knowledge/troubleshooting?hsLang=en)
- [About PlanHub](https://knowledgebase.planhub.com/knowledge/about-planhub?hsLang=en)
- [New General Contractor Experience](https://knowledgebase.planhub.com/knowledge/new-general-contractor-experience?hsLang=en#main-content)
- [Overview](https://knowledgebase.planhub.com/knowledge/new-general-contractor-experience?hsLang=en#overview)
- [Projects](https://knowledgebase.planhub.com/knowledge/new-general-contractor-experience?hsLang=en#projects)
- [Networking](https://knowledgebase.planhub.com/knowledge/new-general-contractor-experience?hsLang=en#networking)
- [Takeoff & Estimation](https://knowledgebase.planhub.com/knowledge/new-general-contractor-experience?hsLang=en#takeoff-estimation)
- [Account & Settings](https://knowledgebase.planhub.com/knowledge/new-general-contractor-experience?hsLang=en#account-settings)
- [Manage Your Team](https://knowledgebase.planhub.com/knowledge/new-general-contractor-experience?hsLang=en#manage-your-team)
- [Submit Feedback](https://knowledgebase.planhub.com/knowledge/submit-feedback?hsLang=en#main-content)
- [Feedback](https://knowledgebase.planhub.com/knowledge/submit-feedback?hsLang=en#feedback)
- [Have an Issue? Submit a Ticket](https://knowledgebase.planhub.com/knowledge/kb-tickets/new)
[](http://planhub.com)
[Knowledge Base Home](https://knowledgebase.planhub.com/knowledge?hsLang=en)
[Submit a Ticket](https://knowledgebase.planhub.com/knowledge/kb-tickets/new?hsLang=en)
Copyright © 2026, ©2026 PlanHub, Inc. All rights reserved