Export List of Checked Out files to Excel

This report allows you to export a list of all checked out files in your SharePoint / Office 365 environment, including never checked in documents. You can run this report for a Site (incl. Subsites), Document Library or for a particular selected Subfolder. The exported report contains the following columns:

  • Title
  • Filename
  • URL
  • Created Date
  • Last Modified Date
  • User who created the file (Created by)
  • User who last modified the file (Last modified by)
  • User who checked out the file (Check out User)
  • File Size
  • File Type
  • Version Label
How to generate a list of checked out files

1. Select a Site, Document Library or folder and perform the report “Export List of Checked out files…” (per right mouse click and selection in context menu).

Sharepoint / Export list of checked out files

2. The tool collects all checked out files (if there are any inside the selected structure) and displays a confirmantion dialog. Hit the “Yes” button to complete or “Cancel” to abort the Operation.

Office 365 / Export list of checked out files to Excel Sheet

3.  A “Save as” dialog appears, where the user can select the target folder and the file name of the generated report.

Export list of Checked Out files to Excel

4. Once the generated report is saved in the specified location, the tool asks you, if you want to open the report in Excel.

Office 365 / report checked out documents

 


Home / Documentation / Built-in Reports