How to import Planner task data from MS-Excel, Access or SharePoint List?

%3CLINGO-SUB%20id%3D%22lingo-sub-1714923%22%20slang%3D%22en-US%22%3EHow%20to%20import%20Planner%20task%20data%20from%20MS-Excel%2C%20Access%20or%20SharePoint%20List%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1714923%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I'm%20using%20MS-planner%20to%20track%20user%20acceptance%20testing%20across%20global%20teams.%20i.e.%20each%20test%20script%20is%20a%20task.%20The%20Kanban%20is%20easy%20to%20update%20for%20the%20superusers%2C%20as%20they%20can%20quickly%20add%20test%20results%20and%20change%20the%20test%20status%3B%20merely%20by%20dragging%20the%20task%20into%20a%20new%20bucket.%20For%20End-To-End%20testing%2C%20the%20testers%20can%20also%20easily%20see%20when%20it's%20their%20'turn'%20to%20run%20a%20step%20in%20an%20End-To-End%20test%20script%20(each%20test%20steps%20is%20a%20checklist%20item%20within%20the%20task)%20.%20This%20is%20really%20great%20during%20Corona%20times%20when%20the%20testing%20team%20can't%20physically%20meet-up%20in%20the%20same%20room.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20see%20there%20is%20an%20export%20to%20MS-Excel%20feature%2C%20but%20I%20can't%20see%20how%20to%20import%20data%20into%20Planner%20from%20MS-Excel%2C%20MS-Access%2C%20SharePoint%3B%20like%20you%20can%20with%20SharePoint%20Lists.%20This%20would%20be%20very%20useful%20as%20I%20often%20have%20many%20parallel%20plans%20with%20100's%20of%20test%20scripts%20-%20which%20I'm%20tracking%20across%20many%20teams.%20It's%20very%20tedious%20to%20create%20these%20manually.%3C%2FP%3E%3CP%3EThanks%20for%20any%20help%20and%20workaround%20ideas.%3C%2FP%3E%3CP%3EColin%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Visitor

Hi, I'm using MS-planner to track user acceptance testing across global teams. i.e. each test scenario is a task. The Kanban is easy to update for the superusers, as they can quickly add test results and change the test status; merely by dragging the task into a new bucket. For End-To-End testing, the testers can also easily see when it's their 'turn' to run a step in an End-To-End test script (each test steps is a checklist item within the task) . This is really great during Corona times when the testing team can't physically meet-up in the same room.

 

I see there is an export to MS-Excel feature, but I can't see how to import data into Planner from MS-Excel, MS-Access, SharePoint; like you can with SharePoint Lists. This would be very useful as I often have many parallel plans with 100's of test scripts - which I'm tracking across many teams. It's very tedious to create these manually.

Thanks for any help and workaround ideas.

Colin

0 Replies