Follow

Import from Excel

This article guides you how you can migrate information from Excel to Hansoft.

You have two options:

1. Simple import to just get the item names into Hansoft.

2. Advanced import incl. mapping columns in Excel to columns in Hansoft.

Simple Import

  1. Copy the data representing item names from Excel
  2. Right-click in the are in Hansoft where you would like to import (Planning, QA or Backlog) and select Paste text as items

 

 

The items will now be listed where you pasted them.

 

Advanced Import

 

  1. Download the attached .rar file including everything you need (the .NET Framework 4.5 must first be installed to run this program)
  2. Run hsimport.exe
  3. Select the Excel file to populate the left-most column
  4. Map to the Hansoft columns to the right (if you are using custom columns there are instructions in the readme with the download)
  5. Click Save to generate the Hansoft XML
  6. In the product backlog in Hansoft, click More > Export and Import > Import Hansoft XML and select the file you generated.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments