--- title: Bringing Historical Data into Join description: Learn the best practices for bringing your historical data into Join --- [Skip to content](https://success.join.build/en/knowledge/bringing-historical-data-into-join#main-content) [Contact Join Support](https://success.join.build/en/knowledge/kb-tickets/new?hsLang=en) [![Join Help Center](https://success.join.build/hubfs/Join%20Help%20Center.svg)](https://success.join.build/en/knowledge?hsLang=en) Open main navigation Close main navigation - [Contact Join Support](https://success.join.build/en/knowledge/kb-tickets/new) - [Login](https://app.join.build/) [Login](https://app.join.build/) Hi! 👋 How can we help? - There are no suggestions because the search field is empty. 1. [Join - Help Center](https://success.join.build/en/knowledge?hsLang=en) 2. [Join Benchmarking](https://success.join.build/en/knowledge/join-benchmarking?hsLang=en) 3. [Project Comparisons Report](https://success.join.build/en/knowledge/join-benchmarking?hsLang=en#project-comparisons-report) # Bringing Historical Data into Join ## Learn the best practices for bringing your historical data into Join Join Benchmarking unlocks the potential to utilize the historical data you have in Join. But what if you have historical projects that are not in Join yet? This guide will provide some best practices for preparing and importing your company’s historical data into Join. ### Analyzing and Preparing Historical Data Before bringing historical data into Join, you should first take some time to make sure all of your data is prepared and ready to go. This may require some effort up front, but it will save you time in the long run and it will ensure that your data is organized and usable once it is in. #### Analyze the Data The first step is to analyze your data and determine which projects have useful data. Start by making a list of all potential past projects and ask yourself the following questions to determine if they are good candidates for bringing into Join. - How old is the data, and is it still relevant? Projects from 20 years ago are probably too old to be useful. How old is too old? There are a variety of factors like economic conditions, material costs, labor shortages, etc. that may affect your decision. Keep in mind that [location and time escalation factors](https://success.join.build/en/knowledge/escalating-historical-costs?hsLang=en) can be used in the Project Comparisons report to account for some of these. - Does your project estimate have enough cost detail to be useful for future projects? It’s recommended to import estimates with as much cost detail and breakdowns as possible to provide flexibility when using this data for future estimates. - What format is your data currently in? Join makes it easy to bring in estimates from several estimating platforms, spreadsheets, and even using copy-paste. [This article](https://success.join.build/en/knowledge/estimate-overview?hsLang=en) will help you get started with preparing and importing your data into Join. - If you have several estimates for a single project, which one(s) will you need? It’s recommended to bring in the latest version of your project estimate, but you may find additional value in bringing in the full cost history of your project across multiple milestones. - What types of projects do you plan on pursuing in the future? It’s recommended that you have at least three historical projects for each project type (healthcare, K-12, multi-family, etc.). - What project metadata is important to bring in with your estimate? Consider any key metrics like location, GSF, number of units, number of floors, structure type, etc. After thinking through these questions you should be able to narrow down your original list of projects to a list that has good-quality data. #### Standardizing Work Breakdown Structure The next step is to come up with a standardized work breakdown structure (WBS) across your organization. Standardizing your WBS is necessary if you want to be able to compare costs across all your projects consistently. Get ready, this is potentially the most time-consuming step. If your historical estimates were not coded to your standard WBS codes then you will have to go back and recode them so they are all in alignment. ***Tip:*** *Once you finalize your new WBS standards, create [company standard Categorizations](https://success.join.build/en/knowledge/standard-categorizations?hsLang=en) to ensure they are used across all new projects moving forward.* Preparing the File/Data The next step is to gather all the files and make sure they are ready to go. This means you will need an estimate file or spreadsheet to import your cost data or you can simply copy-paste it into Join. [This article](https://success.join.build/en/knowledge/estimate-overview?hsLang=en) has links to step-by-step instructions for exporting estimate files from supported estimating platforms and setting up a spreadsheet import template. ### Bringing Historical Data into Join Now that you completed all the preparation, it’s time to get the data into Join. #### New Project Setup To bring in your historical data you first need to [create a new project](https://success.join.build/en/knowledge/create-a-new-project?hsLang=en). While creating the project it’s important to:  1. Enter a **Project Name** (consider a naming convention that identifies the project as a historical project) 2. Set the **Project Status** as **Completed** 3. Select a **Project Type** (for filtering your list or projects by type) 4. Enter an accurate **Location** (for location escalation factors) 5. Enter an **Active Milestone Name** After you create the project you’ll be redirected to the **Settings** tab. While you’re here you should consider making the following changes: 1. In the **Description** field, add as much information and project metadata as you can. This will help inform other people at your company about the project so they can determine if this is a comparable project. 2. Turn on the [Units of Measure](https://success.join.build/en/knowledge/units-of-measure?hsLang=en) that are relevant to your project. #### Bringing the Data in The final step is to bring the data into the project you just created. Start by navigating to the **Milestones** tab and opening the Milestone that you created with your project. 1. On the **Basics** tab, enter a Milestone **Start Date** (for time escalation factors) 2. On the **Metrics** tab, enter quantities for each Unit of Measure that you turned on from the **Settings** tab. These quantities will be used to calculate unit prices. 3. On the **Estimate** tab, [import](https://success.join.build/en/knowledge/importing-an-estimate-file?hsLang=en) or [copy-paste](https://success.join.build/en/knowledge/import-your-spreadsheet-estimate-into-join?hsLang=en) your estimate data. Don’t forget to publish the Estimate when you are done. ### Use the Data! Congratulations🎉 on getting your valuable historical data into Join! Now it’s time to put it to good use. Create a [Project Comparisons report](https://success.join.build/en/knowledge/project-comparisons-report?hsLang=en) to quickly create a new conceptual estimate from the historical data you just brought in. ***Note:*** *If your company doesn’t have access to the Project Comparisons report then please reach out to your account manager or send an email to* [*support@join.build*](mailto:support@join.build)*. If your company has access but you don’t see it, then reach out to your company administrator and ask them to* [*change your company role*](https://success.join.build/en/knowledge/managing-employees-in-join?hsLang=en#setting_employee_role) *to Manager or above.*   - [Getting Started with Join](https://success.join.build/en/knowledge/getting-started-with-join?hsLang=en#main-content) - [Join Overview](https://success.join.build/en/knowledge/getting-started-with-join?hsLang=en#join-overview) - [I'm a new Join user](https://success.join.build/en/knowledge/getting-started-with-join?hsLang=en#im-a-new-join-user) - [My company is new to Join](https://success.join.build/en/knowledge/getting-started-with-join?hsLang=en#my-company-is-new-to-join) - [I want to use Join on my project](https://success.join.build/en/knowledge/getting-started-with-join?hsLang=en#i-want-to-use-join-on-my-project) - [Workflow Best Practices](https://success.join.build/en/knowledge/getting-started-with-join?hsLang=en#workflow-best-practices) - [Getting Started for Project Admins](https://success.join.build/en/knowledge/getting-started-with-join?hsLang=en#getting-started-for-project-admins) - [Getting Started for General Contractors](https://success.join.build/en/knowledge/getting-started-with-join?hsLang=en#getting-started-for-general-contractors) - [Getting Started for Design Team Members](https://success.join.build/en/knowledge/getting-started-with-join?hsLang=en#getting-started-for-design-team-members) - [Getting Started for Owners](https://success.join.build/en/knowledge/getting-started-with-join?hsLang=en#getting-started-for-owners) - [Product Updates](https://success.join.build/en/knowledge/product-updates?hsLang=en#main-content) - [What's New](https://success.join.build/en/knowledge/product-updates?hsLang=en#whats-new) - [Early Access](https://success.join.build/en/knowledge/product-updates?hsLang=en#early-access) - [Join for Pursuit](https://success.join.build/en/knowledge/join-for-pursuit?hsLang=en#main-content) - [Pursuit Resources](https://success.join.build/en/knowledge/join-for-pursuit?hsLang=en#pursuit-resources) - [Dashboard](https://success.join.build/en/knowledge/dashboard?hsLang=en#main-content) - [Dashboard](https://success.join.build/en/knowledge/dashboard?hsLang=en#dashboard) - [Charts](https://success.join.build/en/knowledge/dashboard?hsLang=en#charts) - [Milestones](https://success.join.build/en/knowledge/milestones?hsLang=en#main-content) - [Milestones](https://success.join.build/en/knowledge/milestones?hsLang=en#milestones) - [Estimates and Budgets](https://success.join.build/en/knowledge/milestones?hsLang=en#estimates-and-budgets) - [Importing](https://success.join.build/en/knowledge/milestones?hsLang=en#importing) - [Items](https://success.join.build/en/knowledge/items?hsLang=en#main-content) - [Items](https://success.join.build/en/knowledge/items?hsLang=en#items) - [Options](https://success.join.build/en/knowledge/items?hsLang=en#options) - [Status](https://success.join.build/en/knowledge/items?hsLang=en#status) - [Scenarios](https://success.join.build/en/knowledge/items?hsLang=en#scenarios) - [Item Library](https://success.join.build/en/knowledge/items?hsLang=en#item-library) - [Schedule Impact](https://success.join.build/en/knowledge/items?hsLang=en#schedule-impact) - [Ideas](https://success.join.build/en/knowledge/items?hsLang=en#ideas) - [Markups](https://success.join.build/en/knowledge/markups?hsLang=en#main-content) - [Markups](https://success.join.build/en/knowledge/markups?hsLang=en#markups) - [Milestone Markups](https://success.join.build/en/knowledge/markups?hsLang=en#milestone-markups) - [Item Markups](https://success.join.build/en/knowledge/markups?hsLang=en#item-markups) - [Contingencies and Allowances](https://success.join.build/en/knowledge/markups?hsLang=en#contingencies-and-allowances) - [Cost Display Settings](https://success.join.build/en/knowledge/markups?hsLang=en#cost-display-settings) - [Risk Register](https://success.join.build/en/knowledge/risk-register?hsLang=en#main-content) - [Risk Register](https://success.join.build/en/knowledge/risk-register?hsLang=en#risk-register) - [Timeline](https://success.join.build/en/knowledge/timeline?hsLang=en#main-content) - [Timeline](https://success.join.build/en/knowledge/timeline?hsLang=en#timeline) - [Reports](https://success.join.build/en/knowledge/reports?hsLang=en#main-content) - [Reporting](https://success.join.build/en/knowledge/reports?hsLang=en#reporting) - [Customizable Reports](https://success.join.build/en/knowledge/reports?hsLang=en#customizable-reports) - [Team](https://success.join.build/en/knowledge/team?hsLang=en#main-content) - [Team](https://success.join.build/en/knowledge/team?hsLang=en#team) - [Roles and Permissions](https://success.join.build/en/knowledge/team?hsLang=en#roles-and-permissions) - [Project Settings](https://success.join.build/en/knowledge/project-settings?hsLang=en#main-content) - [Project Settings](https://success.join.build/en/knowledge/project-settings?hsLang=en#project-settings) - [Categorizations](https://success.join.build/en/knowledge/project-settings?hsLang=en#categorizations) - [Units of Measure](https://success.join.build/en/knowledge/project-settings?hsLang=en#units-of-measure) - [Item Schedule Impact and Display](https://success.join.build/en/knowledge/project-settings?hsLang=en#item-schedule-impact-and-display) - [Default Item Template](https://success.join.build/en/knowledge/project-settings?hsLang=en#default-item-template) - [Notifications](https://success.join.build/en/knowledge/project-settings?hsLang=en#notifications) - [Print Header](https://success.join.build/en/knowledge/project-settings?hsLang=en#print-header) - [Customize Display](https://success.join.build/en/knowledge/project-settings?hsLang=en#customize-display) - [Projects and Programs](https://success.join.build/en/knowledge/projects-and-programs?hsLang=en#main-content) - [Projects and Programs](https://success.join.build/en/knowledge/projects-and-programs?hsLang=en#projects-and-programs) - [Projects](https://success.join.build/en/knowledge/projects-and-programs?hsLang=en#projects) - [Programs](https://success.join.build/en/knowledge/projects-and-programs?hsLang=en#programs) - [Company Settings](https://success.join.build/en/knowledge/company-settings?hsLang=en#main-content) - [Company Settings](https://success.join.build/en/knowledge/company-settings?hsLang=en#company-settings) - [Company Standards](https://success.join.build/en/knowledge/company-settings?hsLang=en#company-standards) - [Join Benchmarking](https://success.join.build/en/knowledge/join-benchmarking?hsLang=en#main-content) - [Project Comparisons Report](https://success.join.build/en/knowledge/join-benchmarking?hsLang=en#project-comparisons-report) - [Join Insights](https://success.join.build/en/knowledge/join-insights?hsLang=en#main-content) - [Join Insights](https://success.join.build/en/knowledge/join-insights?hsLang=en#join-insights) - [Integrations](https://success.join.build/en/knowledge/integrations?hsLang=en#main-content) - [Integrations](https://success.join.build/en/knowledge/integrations?hsLang=en#integrations) - [Security](https://success.join.build/en/knowledge/security?hsLang=en#main-content) - [Frequently Asked Questions](https://success.join.build/en/knowledge/security?hsLang=en#frequently-asked-questions) - [Single Sign-on](https://success.join.build/en/knowledge/security?hsLang=en#single-sign-on) - [AI](https://success.join.build/en/knowledge/ai?hsLang=en) [![Artboard 3@4x-8](https://success.join.build/hs-fs/hubfs/Artboard%203@4x-8.png?width=100&height=69&name=Artboard%203@4x-8.png "Artboard 3@4x-8")](https://join.build) © 2026 - Join | All rights reserved.