Take the 2-minute tour ×
Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. It's 100% free, no registration required.

We use QC for test management tool in our project. Usually we write test cases & test steps in spreadsheets and load into QC using 'Export to QC' excel add-in. We have a set of test cases already present in QC and they need to be updated.

Is there a way I can export the test cases (along with test steps for each test case) from QC back to excel so that I can update them to load it back to QC??

share|improve this question

4 Answers 4

This is how I do it:

  1. Login to Quality Center.
  2. Click Test Lab/Test Plan/Wherever you keep your test cases.
  3. After creating the test set, configure the columns to display in the desired order.
  4. Right click within the Test Set list and select Export > All.
  5. Name the Export file and click save.

Exporting a test set is a lot easier than exporting from the test plan section, I've found. So if possible, consider bundling the tests, then exporting.

However if you really want to export from the Test Plan, click View > Test Grid. Then use a column to filter the displayed tests and export as explained above.

The third option is to export using SQL within Quality Center, but I've never explored that option too much as I've always had success with the first two methods.

share|improve this answer
    
I have attempted your solution from both the Test Lab and the Test Plan and unfortunately it does not export the Test Steps is the OP had requested. This only exports one line for the Test with Test level details. –  Harrison Jan 30 at 21:50

there's a sample .vbs (but it was uploaded as .txt) in this forum -> http://h30499.www3.hp.com/t5/Quality-Center-Support-and-News/Test-Plan-export-from-QC-to-Excel/td-p/4807563

I haven't tried it myself though, but I do hope it helps you.

share|improve this answer

https://sites.google.com/site/quickinfopocket/qtp-probs-solve/tools

small functionality with respect to end user requirement. Currently this tool is proving the functionality of exporting manual test cases(Bulk export) from Quality center to predefined excel file and download qtp result from QC to local drive

share|improve this answer

Don't need to download anything below works fine:

Click Test Lab/Test Plan/Wherever you keep your test cases. After creating the test set, configure the columns to display in the desired order. Right click within the Test Set list and select Export > All. Name the Export file and click save.

share|improve this answer
    
is there something we have missed here? we want to export test cases with the test step and description of every steps in the test cases. When i follow your advise, when i configure the column there is no option to select step name and step description. Thanks in advance –  Dian Sep 5 at 10:11

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.