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.

Popular Posts


The opinions expressed on this blog are the personal views of Pratik's SharePoint Blog, and do not represent or reflect the viewpoints or policies of any past, present, or future employer, colleague, or customer, or any other entity. The posts on this blog are provided ‘as is’ with no warranties, express or implied, and confer no rights. Use of information contained within this blog, including specific technical steps mentioned herein, is at your own risk. References to specific software products, processes, resources, or companies do not imply any endorsement.