How do I import Work Items from MS Excel file including parent/child links (RTC 6.0.1 and later)?
![](http://jazz.net/_images/myphoto/bc9e13702af126db36d441ba5dd6c328.jpg)
Hi,
Is there any way to import work items from an MS Excel sheet into RTC 6.0.1?
I know there is an extension to import data from MS Excel/Word into RQM but not sure if there's an equivalent one for RTC.
Does any one know the answer to my question? Any useful guidance will be appreciated.
Thanks in advance.
Victoria.
Is there any way to import work items from an MS Excel sheet into RTC 6.0.1?
I know there is an extension to import data from MS Excel/Word into RQM but not sure if there's an equivalent one for RTC.
Does any one know the answer to my question? Any useful guidance will be appreciated.
Thanks in advance.
Victoria.
One answer
![](http://jazz.net/_images/myphoto/bc9e13702af126db36d441ba5dd6c328.jpg)
Hi Victoria,
You will need to save your Excel sheet as a.csv format first and then follow these instructions. You can import work items in RTC from a CSV file, but not from other MS Excel formats like .xls or .xlsx.
You will need to save your Excel sheet as a.csv format first and then follow these instructions. You can import work items in RTC from a CSV file, but not from other MS Excel formats like .xls or .xlsx.