Import / Export Planner Tasks using Excel

Export / Import tasks using Excel solves many purposes and saves time. This helps users in following ways:
  • For reporting purposes
  • Use for ad-hoc needs such as filtering, categorizing, sorting.
  • Create new tasks in bulk
  • Import tasks from Trello, Project or other task management systems
  • Can be used as plan templates for creating new plans from scratch
Planner fields supported for Export / Import
  • Title
  • Plan
  • Bucket
  • Created By
  • Assigned By
  • Assigned Date Time
  • Completed Date Time
  • Completed By
  • Categories
  • Description
  • Checklist
  • Attachments
  • Assigned To
  • Start Date
  • Due Date
  • Percent Complete

How to Export Planner Tasks to Excel?

How to Import Planner Tasks using Excel?