SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I noticed that the create date field of a list item is not returned when you create a data connection to it using Excel.

The technique I am using is to go to the list and export it from the ribbon to download the *.qry file. Then use that file in Excel to create the connnection.

Does anyone know of another way to get the create date imported into excel?

share|improve this question
up vote 0 down vote accepted

Make sure the Created Date field is in the view that the IQY is derived from. I've got a library filled with dozens of data sources from Sharepoint lists and the created filed is included be cause it was in the view when the IQY file was created.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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