{"id":7479,"date":"2022-03-30T05:20:23","date_gmt":"2022-03-30T05:20:23","guid":{"rendered":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/?post_type=article&p=7479"},"modified":"2026-04-27T15:35:58","modified_gmt":"2026-04-27T10:05:58","slug":"how-to-export-and-import-workitems","status":"publish","type":"article","link":"https:\/\/www.nimblework.com\/knowledge-base\/nimble\/article\/how-to-export-and-import-workitems\/","title":{"rendered":"How to Export and Import Workitems"},"content":{"rendered":"

This article explains how to export and import workitems using Microsoft Excel. You will learn how to export workitems, make updates offline, and import the file back into the application to add, update, or close workitems.<\/p>\n\n\n\n
\n

Skip Ahead to:<\/strong><\/p>\n

Overview<\/a><\/a><\/p>\n

Steps to Export Workitems<\/a><\/p>\n

Steps to Import Workitems<\/a><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Overview<\/h2>\n

Exporting workitems enables sharing files and helps in adding and modifying workitems offline using MS Excel. Export the structure to add and upload items or all content for all fields to modify and\/or close items. On Importing the files back into the application, items are added\/updated\/closed.<\/p>\n

To bring in workitems from other systems into the application, export the structure of that workitem i.e., Skeletal Export, and then enter data formatted to the columns in the file. This will allow the smooth import of workitems i.e. <\/a>without any errors.<\/p>\n

\"\"<\/p>\n

Steps to Export Workitems<\/h2>\n

You can export workitems in Excel format as a compressed file. Select one or more workitems and download them along with their attachments. You can choose to export all fields or only the fields displayed in the List view.<\/p>\n

To export workitems:<\/p>\n

    \n
  1. In the Workitem Listing view, select the required workitems.<\/li>\n
  2. Click the Export<\/strong> icon.<\/li>\n
  3. The file is downloaded automatically in Excel format.<\/li>\n<\/ol>\n

    \"File<\/p>\n

    Note:<\/strong><\/p>\n