HOWTO: Export a list with SP

When you try to export a SharePoint list you get an error messages saying it can’t be done.

SharePoint ExportList

“To export a list, you must have a Microsoft SharePoint Foundation-compatible application.”

Searching this error message easily finds the root of the problem. There is a problem with the Office 64 bit version. It doesn’t work with SP. These solutions generally tell you to uninstall your 64 bit office and install a 32 bit version. Happily there is a much easier solution.

Despite the error message the export actually works! Notice the yellow bar at the bottom of your browser. Simply save the .iqy file normally and open it with Excel. It’s that simple. The error message is certainly a nuisance but does not actually stop the export.


See our IT Services Page for more information on ways we can help you!

For more information about Microsoft, visit the Official Site:

1 reply
  1. David
    David says:

    Thanks – you were right, i was eventually able to export. Save to desktop, open with excel, and it grabs the data. Annoying but this saved my hide. Thank you.


Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *