Skip to main content

         This documentation site is for previous versions. Visit our new documentation site for current releases.      

Exporting and importing IDs in Workforce Intelligence

Updated on December 28, 2022

In Pega Workforce Intelligence™, administrators can export information, such as data collection users, to a CSV file. 

"Export users option"
Export users option

Programs like Microsoft Excel might change the format of your data when you open the exported CSV file. For example, values such as Primary or Alternate ID might include leading zeros that uniquely identify data collectors. If you use Excel to open and manage the exported CSV file, Excel removes leading zeros. Before you submit the file to Pega Support to import back to Workforce Intelligence, it is important to check for this issue and restore all leading zeros.

To restore leading zeros, refer to documentation for the tool you use to manage the exported data. For example, if you use Excel, consult the  Keeping leading zeros and large numbers  article available from Microsoft Support to resolve this issue.

Note: This issue only applies when you export existing data and open the CSV in Excel. Leading zeros remain in place when you create and edit a CSV file directly in Excel.


  • Previous topic Updating Workforce Intelligence hierarchy information
  • Next topic Enabling Workforce Intelligence for Pega Attended RPA clients

Have a question? Get answers now.

Visit the Support Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best. is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us