I have 1,150 test cases in my QC ALM and in Excel spreadsheet I have 1,075 test cases. There are 75 test cases which are duplicate in QC ALM and I need to remove them so that it matches the Excel test case count of 1,075.

Is there any way to find and remove duplicate records from QC ALM?

  • Can't you export all tests from QC to excel? and remove duplicate using excel. Commented Aug 23, 2016 at 11:35
  • Delete the test cases from ALM; import from Excel. Should cover the requirement.
    – Dave
    Commented Sep 6, 2016 at 9:49
  • 1
    The TC ID is always unique in QC ALM (assuming all the test cases are present under one folder). So, your duplicated tests should be having TC IDs that are not present in your excel sheet. In this scenario, you can export TCs from QC to an excel sheet and do a vlookup against the original excel sheet. If the TCs are present in different folders, then there is a possibility that a single TC exist in different folders with the same ID. In this case, the solution provided by @NarendraC is the best.
    – Janaaaa
    Commented Sep 28, 2016 at 8:20
  • Still this Q is in active queue. Can you accept any answer if found helpful, please? Commented Sep 30, 2016 at 5:24
  • OK, will try today with your scenario. If I get any issue will let you know.
    – Bharat Mane
    Commented Sep 30, 2016 at 5:32

1 Answer 1



  • Export all the tests from QC to excel
  • Using power of Excel you can remove duplicate test easily

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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