While exporting a list/library to excel using ribbon option, we can see only CreatedBy user's Display name.

Any idea how can I expand CreatedBy to CreatedBy:Email in OOTB list view in SharePoint 2013, so that it gets captured in Export to Excel as well.


In the column settings there is section as show field, in there select Work email in dropdown and then try. You should get the email. But this is only for the People picker fields which you create. The other pre defined fields like Created By and Modified By cant have the email as they are read only and have predefined structure to follow. However you can run scripts/powershell commands to get the email from Created By and Modified By field.

  • I'm able to get email address of Created By through powershell, However I want this feature to be available to end users through browser – Kushal Bhabra Dec 17 '16 at 11:17
  • You can create a coulumn and then extend the script to add that value (email id) in the column – Ankit Kumar Dec 19 '16 at 12:45
  • Can you please elaborate what kind of script, will it need periodic updating? – Kushal Bhabra Dec 20 '16 at 8:52
  • it can be a event reciever which will update the column on Item Adding/ Updated – Ankit Kumar Dec 20 '16 at 11:54

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.