To open any link in a new tab, preserving your position in the current article, just hold down the <CTRL> key on your keyboard before clicking the link or click using your mouse wheel.

Import from Excel Tool Plugin (Creating Items from an Excel Spreadsheet)

Overview

This plugin allows users to create PlanSwift parts from their own Excel spreadsheets and make them available on the Templates Tab ribbon-bar.

The PlanSwift Import from Excel Tool Plugin adds an Excel Import Tool icon to an Import group on the Templates Tab ribbon-bar...

 

How To Use the Excel Import Tool Plugin


Notes

First, you'll need to download and install your Plugin, see: Downloading, Installing, and Uninstalling a Plugin or Starter Pack

Once your new Plugin is installed, follow the steps below to use it.

We encourage you to purchase a training package for accelerated learning and faster customization, see: https://www.planswift.com/support/personalized-training/ for details on scheduling training.

How to Prepare an Excel Spreadsheet for Importing into PlanSwift


There are several things to consider in preparing an Excel spreadsheet for importation into PlanSwift. Keep in mind that this is a basic example and you are not limited to the properties listed.

  • Plan out what properties you want to add and populate for each item.
  • Try to be as global as you can with your properties, because each column you create will be added as a property on each item you are importing whether it is used by the item or not.
  • To simplify the cleanup work after the import, you can also import the calculations for any given property.
  • Formulas need to be written in the same manner as in PlanSwift and NOT Excel.

Here is an example of a spreadsheet that is ready to be imported into PlanSwift. The name of the template is Test Template.xlsx. The data in your spreadsheet should be created in a similar way.

The first row of your spreadsheet (row 1 on Figure 3) must contain the Property Headings

  • Name (column A) is self-explanatory.
  • Material Type (column B) helps you to create a folder structure for PlanSwift and will keep your items sorted into tidy categories. Note that your spreadsheet must be sorted by this column before importing; otherwise you will end up with a duplicate folder.
  • Item Number (column C) is optional and can contain a text description.
  • Description (column D) contains a text description.
  • Cost Each (column E) may be included so that cost each can be added as a property.
  • Type (column F) can contain any of numerous types of properties, some of the most common of which include Area, Linear, Segment, Part, Count, or Labor.
  • Size (column) may include the size of the item.
  • Size UOM (column H) can include the unit of measure (UOM) as a text value (FT, SQ FT, etc.)
  • QTY (column I) contains a quantity or a formula for a quantity to get the result for the part being counted. You are not limited to the "QTY property" for this. You may add other calculations in the properties you create. Entering formulas is optional, but it can save a great deal of time if you have a lot of items.
  • QTY UOM (column J) can include the unit of measure (UOM) as a text value (FT, SQ FT, CU FT, etc.) During the import process, you can specify which fields are Units.
  • Depth (column K) may be used to include a depth value.
  • Depth UOM (column L) contains a unit of measure (UOM) for the depth column as a text value (FT, SQ FT, etc.)

 Note: you will have the opportunity to edit the names that appear in PlanSwift after you run the import tool.           

How to Import the Excel Spreadsheet

Once the spreadsheet is formatted (including sorting on column B) and the data complete, you can start the import process. With the Excel spreadsheet open and PlanSwift open, click on the Excel Import Tool in the Import group of the Templates tab ribbon bar (Figure 2). This launches the tool and opens the Excel Import Tool 1.3 window. The Excel spreadsheet data will load the columns headers automatically. PlanSwift automatically associates column names with default PlanSwift properties when the names are the same. 

This top area of the Excel Import Tool 1.3 window allows you to select where the parts are to be imported to. The options are Current Job, or Templates. The Storage default is Local, so if you have other than local, such as a network drive, you can select that. The Tab field allows you to give a name to the tab that will be created in the Templates screen. Select a name for the Tab. For this example, we’ll use “Test Template” (Figure 4), so type “Test Template” in the Tab field.

The Excel Column in the window (Figure 5) contains the headings from row one in the

Excel Test Template.xlsx file (Figure 3). You can now edit the data in the PlanSwift

Property, Type, and Units columns. Clicking once on any of the cells under the PlanSwift Property column and then clicking on the down-arrow opens a drop-down menu (Figure 6).


This drop-down menu allows you to select the PlanSwift properties that will be assigned to the Excel Column headings. These properties include but are not limited to Name, Description, Price Each, QTY, Type, Item #, Folder and Subfolder. If you want a property that is not in the drop-down menu, simply type it in and press Enter.

Below is the PlanSwift Property column cells filled in with valid PlanSwift properties.

Notes

Material Type (arrow 1) is not a property in PlanSwift; selecting <Folder> as its property ( arrow 1) will allow you to create an organized structure for the imported parts using Material Type as the group. Selecting <Sub Folder> as a type allows for a subfolder of a folder to be created as well; subfolders of subfolders, however, are not supported.

Depth is not in the drop-down menu but can be typed in (arrow 2). For the Size, Depth, and QTY properties, multiple Excel columns have been assigned to a single PlanSwift property.

The Type column (arrow 4) requires the selection of either Text or Number for the type. Click on the cell, then on the down-arrow to make the selection.

The Units column (arrow 5) should be checked for any property that is a unit of measure. The Size UOM, QTY UOM, and Depth UOM should all be checked because they are units of measure. Note that if you have any item that you want to have use the other item’s unit of measurement, make certain that both items have the same PlanSwift property. For instance, if you want the Size UOM to be the unit of size, then it must have the same PlanSwift property of Size

Once everything is set the way you want it, click on the Import button (arrow 6) in the lower right corner.

Once the import tool has finished, you will see the Test Template tab showing in the PlanSwift Templates tab window. Figure 8 shows the imported parts from the Excel spreadsheet. 

To verify the parts came in correctly, right click on Vapor Barrier and select Properties (see Figure 9).


This opens the Properties – [Vapor Barrier] window (Figure 10).

Click on the Advanced button.

Clicking on Advanced opens the advanced Properties window for Vapor Barrier.

For comparison purposes, the screenshot below shows the Excel spreadsheet, the top part of the advanced properties window for Vapor Barrier, and the imported results in the PlanSwift Template tab. Arrow 1 shows that the advanced properties window is open. Arrow 2 shows that Vapor Barrier was imported from the spreadsheet, and arrow 3 shows that the Vapor Barrier material was placed in the Accessories folder in the Template tab. Note that the other Accessories in the spreadsheet (Test Linear and #4 Rebar) were also placed in the Accessories folder.

We can see the correlation between the spread sheet and some of the spreadsheet properties. As examples, arrows 1, 2, 3, and 4 of Figure 13 show the Vapor Barrier Item Number, Description, Cost Each, and QTY respectively on both the spreadsheet and the advanced properties window.

PlanSwift recommends you always do a spot check to make sure the information loaded properly.

You are now ready to apply your new parts to a takeoff.

Any parts that a user imports into PlanSwift should always be tested and verified by that user to ensure the parts are imported correctly. PlanSwift cannot verify the importation of parts created by the user.

Any parts or assemblies that a user creates should always be tested and verified by that user to ensure quantities and calculations are accurate. PlanSwift cannot verify the accuracy of parts and assemblies created by the user.

FAQ

Question: I’ve read this user guide, and I still have questions. What do I do?

Answer: PlanSwift recommends that you purchase a training package. We highly recommend new users purchase a training package, because training is customized to each user. We offer one-on-one training and classroom training. Contact PlanSwift® Training Department Training-ops@ConstructConnect.com.

 

Question: Can I import custom properties for the items I have created?

Answer: Yes. If you want a property that is not listed in the drop-down menu, simply type it in and press Enter. It will then be added when you import the spreadsheet.


Question: Can I have subfolders inside of subfolders?

Answer: No. PlanSwift only allows two levels deep of folders, a main folder and a subfolder within the main folder.


Question: What do I do if I import and it is not what I wanted?

Answer: You can delete what you imported, modify the spreadsheet, and then import it again (it is our experience that you may not get it right on your first import).

More Plugins and Starter Packs

Information on Plugins and Starter Packs is available directly on the Plugins Tab in PlanSwift...

If you encounter technical difficulty, consult this guide (including the FAQ section of this user manual) or contact the technical support department at: 

PlanSwift® Technical Support support@PlanSwift.com

1-888-752-6794 ext. 2

PlanSwift also offers additional training. For training options, contact the training department at:

PlanSwift® Training Department Training-ops@ConstructConnect.com


Copyright 2023 ConstructConnect