SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.
Sign up to join this community
I am using SharePoint 2007..
I have a document library with folders and folders inside folders and documents in each folder. How can I export a list of all my documents to excel or CSV to give me this.
DocumentFolder DocumentName DocumentURL
Home abc http://example.com/Home/abc.xlsx
Home\Car tlz http://example.com/Home/Car/tlz.xlsx
Home\Car\Black kzn http://example.com/Home/Car/Black/kzn.xlsx
You can use out of the box export to excel feature for this:
In your SharePoint site, on the top link bar, click Documents and Lists.
On the Documents and Lists page, click the list that you want to export to Excel.
On the page that displays the list, under Actions, click Export to spreadsheet.
In the File Download dialog box, click Open.
In the Opening Query dialog box in Excel, click Open.
If no workbook is open, Excel creates a new blank workbook and inserts the list on a new worksheet.
If a workbook is open, in the Import Data dialog box, select one of the following options:
To insert the list in the active worksheet, click Existing worksheet.
In the worksheet, click the cell where you want to place the upper-left corner of the list, and then click OK.
To insert the data in a new worksheet, click New worksheet and click OK.
To insert the data in a new workbook, click New workbook and click OK.
To create a PivotTable report based on the list, click Create a PivotTable report, and follow the steps in the PivotTable and PivotChart Wizard.
For more details:
