Import WBS from Excel

ExtrAXION

 

Import WBS from Excel imp_exp_excel_16 

This button allows you to import a WBS from Excel. This way, you can save time and avoid re-creating the WBS in the application. The file should have the following 3-column format:

Description

Measurement Unit

Price

You may enter the columns' headers in the first row of the spreadsheet.

alarm_16 This row will not be taken into account on import. Therefore, the first row of the Excel spreadsheet should either contain the columns' headers or be blank. If the first row contains e.g. the first group and the following rows contain the items, it will not be imported.

alarm_16 A work item row should be preceded by a group row. If not, the following message is displayed:

alarm_16 Importing stops when it encounters the first blank row in the excel sheet. Make sure there are no blank rows between groups, work items etc.

alarm_16 If there are more than one sheets (tabs) into the excel file, then only the current one is imported (current is the visible sheet when you open the excel file).

alarm_16 There is a 500 characters limit of the work items descriptions. If there are longer descriptions into the Excel spreadsheet, they will be truncated.

Below, you will find an example of an Excel spreadsheet for a WBS that can be imported directly:

Description

Unit

Unit Price

Main building

 

 

Earthmoving

 

 

General earthy excavations

m3

3,10

Concrete

 

 

C12/15

m3

30,00

C16/20

m3

36,00

Mechanical

 

 

Steelworks

 

 

Black Steel Plate

kg

1,10

Plumbing

 

 

Galvanized Steel Pipe OD 1/2’

m3

17,50

 

The rows containing groups are distinguished from work items by the fact that the ‘Unit’ and ‘Unit Price’ cells of a group row should be blank.

The groups’ hierarchy is set at a later stage, using the arrowleft_green_16 button and the arrowright_green_16 button.

When the import process is completed, the following message appears.

lightbulb_16 Importing WBS from Excel may also be carried out gradually. The data of each Excel spreadsheet are added in the end, following any existing work items.