Join Spreadsheet Import Template

Accessing a Spreadsheet Template

There are two ways to access the spreadsheet template for the import process:

1. Download a blank spreadsheet template from this article
2. Export a spreadsheet template directly from Join

Download a Blank Spreadsheet Template

Use the following links to download blank spreadsheet templates, which can be modified and imported back into Join. Each spreadsheet template includes the required columns depending on the cost breakdown.

1. Join Spreadsheet Template - Totals Only 
   
2. Join Spreadsheet Template - Quantity, Unit, Unit Price
   
3. Join Spreadsheet Template - Break Down by Cost Type
   

Export a Spreadsheet Template from Join

The spreadsheet templates can also be exported from Join by following these steps:

1. Click Milestones in the navigation panel
2. Create a new Milestone using the + New Milestone button
3. Click the name of the new Milestone
4. Click on either the Estimate or Budget tab
5. Click the Create a new blank Estimate button
6. Select the desired cost breakdown type by using the Cost Breakdown  button  in the Total column header
7. Click the Publish button
8. Click the Export  button and select "Export Estimate (or Budget) as .xlsx" to download the blank spreadsheet

Modify the Spreadsheet Template

Modify the Lines Worksheet

The Lines worksheet in the exported spreadsheet is used to import the estimate line items.

1. Open the downloaded .xlsx file and click on the Lines worksheet at the bottom

2. Insert two columns for each new custom categorization

   1. Label the first column "[Your Categorization Name] - Number" (replacing "New Categorization" with the actual name of your categorization). The values in this column map to the Category column shown in the screenshot below.
   2. Label the second column "[Your Categorization Name] - Name". The values in this column map to the Description column shown in the screenshot below. This column is optional.
   3. The text you use in place of “New Categorization” becomes the Name of the categorization in Join, as shown in the screenshot below.
      
3. Type or copy-paste the line item data (categorization codes, descriptions, quantities, and costs) from your estimate into the spreadsheet

Modify the Markups Worksheet

The Markups worksheet in the exported spreadsheet is used to import the estimate markups.

1. Open the downloaded .xlsx file and click on the Markups worksheet at the bottom
2. In the Description column, enter the name or description of the markup 
3. In the Value Type column, enter either of the following:
   1. "MARKUP" for standard markups
   2. "CONTINGENCY" for contingency markups
   3. "ALLOWANCE" for allowance markups
4. In the Type column, enter either of the following:
   1. "PERCENT" for percentage markups
   2. "FIXED" for lump sum markups
5. In the Value column, enter the percentage or lump sum dollar value of the markup
6. In the Allocate column, enter either of the following:
   1. "true" to enable markup allocation
   2. "false" to always keep the markup separated
7. The Total column can remain blank and will be calculated in Join

Modify the Owner Costs Worksheet

The Owner Costs worksheet in the exported spreadsheet is used to import owner costs.

1. Open the downloaded .xlsx file and click on the Owner Costs worksheet at the bottom
2. In the Description column, enter the name or description of the owner cost
3. In the Value Type column, enter either of the following:
   1. "MARKUP" for standard owner costs
   2. "CONTINGENCY" for owner contingencies
   3. "ALLOWANCE" for owner allowances
4. In the Type column, enter either of the following:
   1. "PERCENT" for percentage owner costs
   2. "FIXED" for lump sum owner costs
5. In the Value column, enter the percentage or lump sum dollar value of the owner cost
6. In the Allocate column, enter either of the following:
   1. "true" to enable owner cost allocation
   2. "false" to always keep the owner cost separated
7. The Total column can remain blank and will be calculated in Join