Excel integration with MTM
Allow testers to open test cases in Excel and edit them and sync them back into MTM. It would also be nice if I could mark test case pass/ fail status in Excel and upload to MTM directly
This is i the feature team’s backlog.
It's crazy that Team Explorer has better integration with Excel than MTM. Testers like me spend out entire days in excel and so coming to MTM 2012 was shocking at the dearth of excel integration. I wish I could vote this higher but I'm out of votes.
Chris F commented
+1 on Better MTM integration with Test Plans | Test Suites. I want to bluck update area/iterations/owners/dates on multiple test plans from excel. I also want to be able to edit test steps in excel and publish those updates from Excel, along with being able to mark test runs as passing or failing from excel en mass.
I really want the ability to IMPORT and EXPORT from MTM into Excel for Test Plan fields, Test Suite hierarchies, test cases (WITH Test Steps), and bulk update Test run results (resolution/triage/bug association). I also would love to have this report integrated into MTM: http://qastuff.wordpress.com/2012/01/12/simple-excel-dashboard-to-monitor-your-test-progress/.
As a Tester I live in excel all day long and I want EXCEL to be the main interface I use when working with TFS for testing purposes.
What a concept Microsoft products integrating with each other! Who would have ever thought of that.
Add ability to be able to upload new user story/test cases and link the test cases to the story - including test steps
Excel integration with MTM would make my (and my team's) work a bit easier. Hopefully this will come about soon? :)
Sam Rodney commented
I would like a way to have manual test case parameters be tried to an excel spread sheet.
I would like a way from MTM (NOT from Team Explorer) to be able to create excel based reports from my queries.
I also want to be able to have excel involved in updating multiple test run failures and resolutions.
Andrew Halliday commented
I too would like to add that this would be a massive value-add for the tool. More specifically:
- Test cases should be **** out in the cells such that they can be formatted for easy reading by business users (reviews)
- Making this view of test cases also usable when doing a tree query would also be fantastic ... so reports can be shown to business users showing their requirements at the top level - demonstrating that their requirements are being tested and then showing them HOW they are being tested
- Therefore, may I suggest that the implementation of the feature be a tree list where steps are seen as subordinate to the test case items
- Finally, with all these features implemented, it should only be a small step to allow test RUNS to be displayed in the same way.
For your consideration. Please let me know if you'd prefer to have these ideas documented as individual suggestions.
THRIUGNANAM V commented
Please work on this ASAP and as a end-user I feel lot of pain without this functionality.
Marianne Moe-Helgesen commented
When you say it is in the backlog, when do you predict it will be released? This functionality is an absolute must in my company.
Hello Shankar et al,
The Test team is working on some planning prioritizing our backlog and future efforts.
Based on your earlier feedback we were wondering if you could let us know what we should be doing more of/differently.
One of my coworkers has created a survey to facilitate this process:
Charles (aka Chuck) Sterling
lior regev commented
This would be very handy also for the system analyst's who want's to see and Add some comment in the TC's and sync them back to the MTM in an easy way (there is no other way to do it as far as i know).
Bhaskar Mishra commented
This is a huge painpoint of many. Export to excel spoils the format of test cases. And also we shaould get away from tcmimport of uploading of test cases.
Anna Russo commented
Parameter values also need integration with Excel
Its true. The QA teams the only license MTM need better ability to interact with work items and changeset info with in MTM and in excel.
This would be very handy as most of out testers are end users who do not and will not want to use a full testing tool. The testing tool is handy only for a few select people within our company who want to manage the test cases, reporting and linking.