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?

1 Answer 1


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.

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.