Checked-out files report
Who has what checked out
Lists every checked-out file in the sites, libraries or folders you pick: who holds it, when it last changed, and whether it has ever been checked in. A file that has never been checked in is invisible to everyone except the person holding it, and a migration cannot see it either.
Reads only. Nothing in SharePoint is changed.
On this page
What does it tell you?
How it runs
What do you get?
What do you need?
What will it not do?
What does it tell you?
- Which files are checked out, and to whom.
- Which files have never been checked in, so nobody else can see them.
- What to chase before a migration, so the latest changes are not left behind.
How it runs
- Pick where to look. Clicking the tile asks which account to use and how to connect, signs you in if you are not already, and drops you straight on the site list. No feature page asks you to connect a second time. Tick sites, libraries or folders.
- Choose subsites and hidden libraries. Only when you ticked a whole site. A library or folder needs no second page.
- Read the list, then chase the holders. Ask each person to check their files in. A file never checked in can also be taken over in the library's settings, under Manage files which have no checked in version.
What do you get?
An Excel workbook, named like contoso-checked-out-files-20261114-101500.xlsx, kept in Report History whether or not you save it. One row per checked-out file. Filter on Never checked in to find the invisible ones.
Summary sheet
What was checked and the totals.
Checked-out files sheet
Every checked-out file.
| Column | Example |
|---|---|
| Location | Projects / Documents |
| File | /sites/projects/Shared Documents/Plans/Budget.xlsx |
| Checked out to | Pat Example |
| Last modified | 2026-11-02 09:14 |
| Never checked in | No |
| What to do | Ask the person to check it in first. |
Findings sheet
The same files as findings, worst first.
Rules sheet
The two checks and how often each fired.
Locations sheet
Each library or folder read.
Skipped sheet
Only when something could not be read: each location and why.
What do you need?
- Read access to the libraries in scope. Files never checked in are read the way the library's own Manage files which have no checked in version page reads them.
What will it not do?
- It reads and reports. Nothing is checked in, taken over or changed.
- SharePoint does not record when a checkout began, so the report shows when the file last changed.
- A file never checked in that you hold yourself is visible to you, so it is listed as checked out rather than as never checked in.
- A library whose checked-out files could not be read is named on the Skipped sheet - it is not counted as having none.