I'm using SharePoint 2007. I have created custom-list.

The list contains one column from "Person and group" type, show field: E-mail.

I fill in data in the list column and export this list to excel list.

In the Excel list, I see the Email with employee number.

It looks like: [email protected];#397

How can I export a custom list into Excel without the number?

  • Anyone found a solution for this ? Commented Feb 17, 2012 at 6:31

2 Answers 2


I had a similar situation when I was working on workflows. In my workflow I wanted to attach the name of the employee. I inserted the employee field (Column Type: Person/Group) and got more data than I needed.

The reason is that the Column Type Person/Group was a String and in that string it contains information on the name, the email, the id (for you thats #397) and the login name. In sharepoint, your list is able to determine which details you wanted (ie. email only) but when you export to Excel it will export the whole thing.

For the workflow I had to the ability to set a mask 'Return Field As.' For you its going to be little different. You would think that the simple solution would be to create a calculated Field that looks at the information Person Group column and retrieves the email only. Unfortunately for you, Sharepoint does not allow for a calculated field based on a Person/Group. So, you will actually be joining my methods by creating a workflow to do the parsing for you.

Read this: http://social.technet.microsoft.com/Forums/sharepoint/en-US/a463eefe-4a07-40b7-a489-b896b93219ea/workaround-to-using-person-or-group-field-in-a-calculated-column-formula

  1. Create your soon to be populated column as Type Text
  2. Create a simple workflow to auto-populate; read the article I gave you 2b. Note that when you work with the workflow be mindful of 'Return Field As'

I hope this helps.


Use calculated fields in excel sheet. Or in sharepoint list

  • Welcome to SharePoint SE! While this helps to answer the question, we prefer more details such as why your answer works. Please edit your post with additional details.
    – Alex Angas
    Commented Jul 4, 2011 at 7:24
  • You can't use a calculated field because calculated fields can't read look up fields like the people picker. Does anyone have a real solution?
    – user8060
    Commented Apr 26, 2012 at 16:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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