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
We used to use test case extractor to copy our test cases to excel and it worked very well on TFS 2010. Now that we have upgraded to 2012 they Steps field does not have any formatting and steps do not export properly.
Currently test users need to add expected results for test step manually in Test Manager or use Test Case Migrator. The Expected Results field should be exposed for Excel Upload to match uploaded test steps. This is something basic that is available in HP Quality Center and is missing in MTM.
This is i the feature team’s backlog.
We are not looking for un-supported tools. We are looking forward to see these features integrated into the core product.
Eric, take a look at http://tcmimport.codeplex.com (Test Case Migrator Plus). This allows you to import test cases present in Excel to TFS.
Eric Carter commented
We just setup a TFS 2013 release candidate server and I began playing around with the test grid. Is there any way to bulk update test tests in the grid via excel. I have tabs and tabs of test cases in spreadsheets on my machine and I want a way to bulk upload the tabs from excel into test cases...without having to copy and paste dozens of times...that's error prone and slow. Is there any way to work with the grid in the excel program itself? I am running Excel 2010 but can install Excel 2013 if that version is required.
I have all of these spreadsheets with test cases that have embedded formulas and generated sql statements, copying and pasting them into TFS test cases means I lose the formulas and have to manually update the excel spreadsheet and then re-import the changes into TFS. Is there any way to embed excel files into Test Steps (not the attachment of an excel file to a work item), but embedded the excel sheet from a work book?
Sarah Adler commented
Our QA team relies heavily on excel and using formulas in excel spreadsheets for test data and test reporting. We've shown them MTM a number of times and they've opted not to use the tool because of it's lack of integration with excel. We want our testers more closely integrated with our developers and right not that means using excel spreadsheets on our sharepoint site. Please help our QA team by giving MTM hooks that work with excel.
Camilo Motta commented
UNDER REVIEW ·
Visual Studio team (Product Team, Microsoft) responded · Feb 8, 2012
This is i the feature team’s backlog
Has this been selected yet????
Hello Product team, Any update on - mark test case pass/ fail status in Excel and upload to MTM directly. Are you releasing this feature any soon?
I for one wanted this feature and also requested it here. but TFS 2012 now has a Web Interface for end users to perform their tests. So this seems like a better a web interface than Excel integration.
This inefficiency drives my team and me absolutely nuts. How can Microsoft not have Excel implemented yet a main competitor, HP Quality Center, easily works with spreadsheets? Amazingly short sighted!
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.
Similarly, excel integration should be improved by providing ability to import/export test steps in addition to expected results.
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.