Export Test scripts from QC to Excel in Bulk

[Rati Saxena]

The script given to export the testcases and test scenario from QC to Excel doesn't work. Can anyone provide the updated script and let me know how to Export the data from QC to Excel????

[Jan Czajkowski]

The Excel macro works, provided you installed the correct version and followed the instructions in the manual.

[Rati Saxena]

From where can I install Excel macro as I don't have it now

[Jan Czajkowski]

Follow the Add-Ins Page link on the QC start page.

[Rati Saxena]

Thanks for the answer Jan. Is it known as "Microsoft Excel Add-in" or something else. I have this add-in already installed.

[Jan Czajkowski]

Yes, that's it. What is the problem you are getting?

[Rati Saxena]

I am not getting error, but that is only used for transferring the Excel data into QC where as I am looking for exporting from QC to Excel. I am not sure as to how can that be done??

[Jan Czajkowski]

The easiest way is to right click and choose Export (Save As) from any grid view and save to Excel.

If that doesn't do what you want, there is an Excel report generator integrated with QC 9.2.

[Rati Saxena]

Hi Jan, This export can only be done for one Test case at a time, where as I have aroung 250 to export which is very time consuming.
So looking for an easier way to do that or bulk export it.

[Jan Czajkowski]

From Test Grid you can export all the information except the design steps.

[Rati Saxena]

But I want to export all(250) the test cases including all the test steps to excel.

[Jan Czajkowski]

OK. Your options are:
If you are on 9.2, run the Excel generator.
Or create your own OTA API script and write to Excel

Or run one of the reports found under Analysis that includes the Design Steps. Then right click the report and choose Export to Microsoft Excel. I am not sure you will like the layout, but you could try it.