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.
There were two independent problems being raised as part of this uservoice item:
1. Test case authoring (with or without test steps) is a very tedious process in MTM
2. No easy way to execute tests offline and then upload the results into TFS
- - TEST CASE AUTHORING:
For #1 – the core underlying needs were:
a. Being able to author test cases (without test steps) quickly – useful when evaluating/brainstorming the different test scenarios and not necessarily being focused on individual steps
b. Being able to author test cases along with test steps at one go – useful when tester has full clarity on what to author
c. Being able to see all test cases/steps in one view and make relevant/related changes at one shot
d. Being able to easily copy steps from one test case to another
MTM was coming in the way for all the above – it forced testers to open the “test case work item form” one at a time for each test case, either for create/edit scenarios.
Starting with TFS 2013, we have now enabled the “grid view” for Test case authoring, which addresses all the issues raised above, related to test case authoring.
Few of the capabilities enabled in Grid view include:
• Create new test cases in a suite, in bulk, using the grid view (with or without test steps) irrespective of whether the suite already contains test cases or not
• Bulk edit all or specific test cases in grid view (add steps, remove steps, edit steps)
• Copy test cases/steps (including Shared Steps) from one test case to another in grid view
• Copy test cases/steps from Excel to grid view and vice versa
• Remove test cases from the suite using the grid view
• Directly open the test case work item form from within grid view for advanced scenarios such as creating shared steps from steps, editing parameter values, adding step attachments etc.
• Use Column Options to select the test case fields you want to see in the Grid view (this capability is scheduled for upcoming update of TFS 2013)
The Grid view for test cases has also been enabled on Visual Studio Online (see: http://www.visualstudio.com/en-us/news/2013-sep-9-vso & http://www.visualstudio.com/en-us/news/2013-sep-30-vso )
More info about the grid view can be found here: http://msdn.microsoft.com/en-us/library/dd286729.aspx
Note: We do acknowledge that the grid view lacks capabilities such as computed columns/formula support, search & replace, offline editing etc.
If these are critical, please create new uservoice items so that they can be tracked & prioritized accordingly.
- - OFFLINE TEST EXECUTION:
We understand and acknowledge the need for this ask. A new user voice item has been created to track this –
Offline test Execution: Allow users to execute test cases in an offline manner (when not connected to TFS)
Given that we have addressed #1 in the product and created a separate item to track #2, we are marking the current uservoice item as COMPLETED.
Yes after working for couple of days in MTM me and my team are feeling that why Excel export/import feature is not in built in Test Manager. We thought its a basic need in prevaling MS tools in order to socialize with in tools. Hope this will be priority item in your backlog so that your customers will feel happy
@Mohammed Uddin - I meant "copy from grid view and paste it into Excel OR copy from Excel and paste it into grid view".
Mohammed Uddin commented
Admin, as you responded, among the few of the capabilities of TFS 2013, "Copy test cases/steps from Excel to grid view and vice versa" is one. Do you mean "copy and paste" or "an Excel integration with MTM?"
@Phil - these changes are exclusive to TFS 2013. There will not be a client update for TFS 2012.
@Julia - as I mentioned, there are few capabilities like search/replace, which are missing in the grid view. If these are critical, please create uservoice items for them.
@Toby - you are referring to the Offline Execution scenario - please mark the corresponding uservoice item (http://visualstudio.uservoice.com/forums/121579-visual-studio/suggestions/3596154-offline-test-execution-allow-users-to-execute-tes)
I agree you need excel integration. Using the Team Web Access still requires users to have an expensive license to complete tests. Allowing UAT users to SIMPLY use excel to run the test and mark the tests as completed and any comments, and to have these sync'd with TFS would be great. The options mentioned above is just another feature in TFS, which is not what this request is about. It is about EXCEL integration with TFS.
While grid view is a nice feature, this request was specifically for EXCEL integration. Seems to me that you've developed a workaround. Excel features such as find & replace are not available. I don't find this to be a completed request.
Are these changes exclusive to TFS 2012, or will there be a client update for TFS 2012 users?
And (many) thanks for including this feature! Many of us who are using MTM were definitely missing the ability to write our test cases in Excel...
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.