Share via

SharePoint 2007: Import and Export Data from a SharePoint Page (Which Is Not a List or Library) to Excel

  • Article

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

http://sharepointpratik.files.wordpress.com/2011/03/031511_1002_exportdataf1.png

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

http://sharepointpratik.files.wordpress.com/2011/03/031511_1002_exportdataf2.png

  • 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

http://sharepointpratik.files.wordpress.com/2011/03/031511_1002_exportdataf3.png