- Use ribbon command to export the document to Excel (take steps in this video - Export your document library listing to Excel)
- You'll get an Excel with 1 sheet called owssvr, that contains these columns:
- Name,
- Modified
- Modified By
- Item Type
- Path
- Filter the sheet by Item Type = 'Item' (uncheck 'Folder' and any other value)
- Put this formula to a cell right under cell F1:
- =CONCATENATE([@Path];"/";[@Name])
- This will create a new column and fill it automatically
- Copy and paste the content of the newly created column to notepad
If your doclib has checkouts enabled, you'll see column D 'Checked out to'
If your farm column titles are localized, edit the formula accordingly.