Importing from Microsoft Excel

You can import data from a Microsoft Excel file into a Hansoft project. This helps you quickly add existing data and start working it in Hansoft. It also provides flexibility for exporting existing Hansoft data, modifying it in Excel, and then reimporting it to Hansoft.

During an import, Hansoft automatically maps columns in the Excel sheet with Hansoft columns and adds an item for each valid row in the sheet.

Preparing the Excel file

Before you import an Excel file, you may need to add additional information to it to adjust the indentation of items and the type used for items added to Hansoft.

By default, items imported from an Excel file are added as scheduled tasks at the bottom of the current view and placed at the same indentation level as the last item in the view. For example, if the current item is at the first indentation level (level 1), all imported items are added as scheduled tasks at level 1.

To override this behavior and use different indentation and item types, add Indentation and Type columns to the Excel file before importing.

Column mappings

The first row of content in the Excel sheet is interpreted as a header row and used to map columns in Excel with Hansoft columns. Columns are successfully mapped if the values in the first row match a Hansoft column name. Case is ignored. Hansoft only maps Excel data to columns active in the current view.

Empty rows at the top of the sheet and between rows are ignored. All other rows are imported to Hansoft as items to the current view. Items are added under any selected items in the current view or at the bottom if no items are selected.

Note:  Mappings may no longer work if you change between Agile and Scheduled mode, change the project template, or rename a column between imports.

Data mappings

During the import, data is added to a column only if the it matches the column format. If the format does not match, the data is not imported.

Performing an import

If the Excel file has multiple sheets, only the sheet that was active last time the file was saved is imported. Items are added under any selected items in the current view or at the bottom if no items are selected.

1. Go to the project view (Planning, Backlog, or QA) to import the data to.

2. Choose More > Export and import > Import from Excel.

3. Select the file to import. Only .xlsx format is supported.

The Import spreadsheet dialog box opens. The successful and unsuccessful column mappings between the Excel sheet and Hansoft are displayed.

4. If the column mappings are correct, click Import to start the import.

If you need to make changes to the Excel sheet to correct column mappings, click Cancel, make any changes, and start the import again.