Planner export - Checklist fields ( All popoulate in one excel cell but out of sequence ?)

%3CLINGO-SUB%20id%3D%22lingo-sub-879959%22%20slang%3D%22en-US%22%3EPlanner%20export%20-%20Checklist%20fields%20(%20All%20popoulate%20in%20one%20excel%20cell%20but%20out%20of%20sequence%20%3F)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-879959%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%20-%20When%20I%20export%20a%20plan%20from%20the%20Planner%20app.%20The%20task%20card%20information%20populates%20into%20various%20cells%20in%20excel.%20If%20you%20have%20a%20checklist%20it%20exports%20all%20of%20the%20checklist%26nbsp%3B%20items%20into%20one%20cell%20-%20which%20is%20not%20great.%20Furthermore%20it%20misses%20up%20the%20sequence%20of%20the%20checklist%20within%20the%20cell.%20I%20cannot%20undersatnd%20how%20to%20make%20the%20checklist%20at%20least%20arrive%20in%20sequence%20.%20Is%20this%20a%20bug%20%3F%20Has%20anyone%20found%20a%20way%20to%20make%20the%20export%20arive%20in%20sequence%3F%20Any%20help%20gratefully%20received%20on%20how%20to%20resolve%2C%20Thanks%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-879959%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EHow-to%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESettings%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETips%20%26amp%3B%20Tricks%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EUser%20Interface%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1845490%22%20slang%3D%22en-US%22%3ERe%3A%20Planner%20export%20-%20Checklist%20fields%20(%20All%20popoulate%20in%20one%20excel%20cell%20but%20out%20of%20sequence%20%3F)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1845490%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F414830%22%20target%3D%22_blank%22%3E%40suzaroo%3C%2FA%3E%20I%20don't%20have%20a%20solution%20for%20the%20export%20process%2C%20but%20I've%20noticed%20the%20tasks%20in%20the%20checklist%20are%20separated%20by%20a%20%22%3B%22.%26nbsp%3B%20My%20solution%20was%20to%20use%20the%20%22Text%20to%20Columns%22%20function%20to%20create%20additional%20columns%20for%20each%20item%20in%20the%20check%20list.%26nbsp%3B%20You%20have%20to%20move%20the%20column%20to%20the%20end%20(after%20the%20Labels%20column)%20then%20it%20will%20open%20the%20wizard%20and%20create%20all%20the%20tasks.%26nbsp%3B%20I%20know%20this%20isn't%20a%20permanent%20Microsoft%20solution%2C%20but%20it%20got%20me%20through%20my%20issues%20with%20export%20rather%20quickly.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22missyllane_0-1604339213364.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F230879iE9801688008C67DC%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22missyllane_0-1604339213364.png%22%20alt%3D%22missyllane_0-1604339213364.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi  - When I export a plan from the Planner app. The task card information populates into various cells in excel. If you have a checklist it exports all of the checklist  items into one cell - which is not great. Furthermore it misses up the sequence of the checklist within the cell. I cannot undersatnd how to make the checklist at least arrive in sequence . Is this a bug ? Has anyone found a way to make the export arive in sequence? Any help gratefully received on how to resolve, Thanks 

1 Reply
Highlighted

@suzaroo I don't have a solution for the export process, but I've noticed the tasks in the checklist are separated by a ";".  My solution was to use the "Text to Columns" function to create additional columns for each item in the check list.  You have to move the column to the end (after the Labels column) then it will open the wizard and create all the tasks.  I know this isn't a permanent Microsoft solution, but it got me through my issues with export rather quickly.

missyllane_0-1604339213364.png