Software Quality Assurance & Testing Stack Exchange is a question and answer site for software quality control experts, automation engineers, and software testers. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Has anyone tried using an Excel template/macro for updating defects in Quality Center?

Currently, I can use the Excel add-in to create new bug reports and then upload it to QC. But afterwards, I'd have to maintain it in QC. If I could pull the data back into Excel, then modify from there and then re-upload, that would make things easier.

(Excel is for folks outside the development team (e.g., during UAT) who provide us with bug reports).

share|improve this question

couple of points/questions

1) what number of defects are we talking about ? If it's UAT and you are getting too many defects to enter manually then maybe you have other problems ? :)

2) Maintaining the defects in QC means there is a history behind them, doing it in Excel loses that. So maybe you gain from ease of use by using Excel but you could lose out by not having the defect history

I'd rather have 'one version of the truth' and keep QC maintained

share|improve this answer
Re: (1) For the recent set of comments that came in, there were 20+ but after weeding them out for duplicates and non-issues, only 2 merit actual fixing. I'm thinking about just logging only those that would require change. – Keis Nov 25 '11 at 12:11

Your Answer


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.