Join 34,000+ subscribers and receive articles from our blog about software quality, testing, QA and security.
 

Need help converting excel to xml and import into Testrail


#1

I’m working for company called ‘Teachscape’ and we are using Testrail for Testcase management. I do have some test cases in excel format. I need to convert the excel files to xml and import into Testrail. Tried to do using quite a few online documentations but didn’t work:(
Please help
Note: Probably detailed steps with screenshots (if possible) would really help

Thanks
Priya


#2

Hello Priya,

Thanks for your posting. We can highly recommend looking into TestRail’s new CSV/Excel import:

http://blog.gurock.com/postings/start-your-migration-flexible-csv-import-in-testrail-4-1/3076/
http://docs.gurock.com/testrail-userguide/howto-import-csv

This makes it much easier to import CSV or Excel files and is now the recommended way to import those files. The (previous) XML-based import approach is still supported but would only apply for very complex CSV/Excel files that aren’t covered by TestRail’s new CSV import.

Which TestRail version do you currently use? The CSV import was added with TestRail 4.1.

Regards,
Tobias


#3

Hello Tobias,

       Thanks for your reply. Actually we are using v3.0 but I have put a request to upgrade the version. As of now downloaded the trail version for v4.1 and was able to upload successfully.

Thank you so much for your help

Thanks
Priya


#4

Great to hear that and please let us know in case any further questions come up, we are happy to help!

Regards,
Tobias