Forum Discussion
suzaroo
Sep 27, 2019Copper Contributor
Planner export - Checklist fields ( All popoulate in one excel cell but out of sequence ?)
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 ...
missyllane
Nov 02, 2020Copper Contributor
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.