Tuesday, March 15, 2011

Import / Export data from a SharePoint page (which is not a List / Library) to Excel

To export a data from a page (not Document Library / List) to Excel
  • Open MS Excel 2007
  • Go to Data Tab
  • Select From Web option

  • Put in the URL with http://URL/_layouts/storman.aspx > Click GO

  • It will display the Storage Space Allocation page in the pop up window
  • Select the area which you want to import
  • Click on import button
  • It will import the data from Storage Space Allocation page to Excel

Please let me know in case of any queries.

Thank you.

1 comment:

Anonymous said...

This is really working...
Thanks man for sharing with us.