Fix SharePoint Showing Files with ~$ Prefix After Migration
Question details
Users notice files beginning with a ~$ prefix appearing in SharePoint document libraries after migrating files from a local shared drive to Microsoft 365.

- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Migrating on-premises Word or Excel files to Microsoft 365 using the Migration Manager.
- Observed behavior
- Temporary Office lock files (prefixed with ~$) are visibly synced to the SharePoint library alongside the original files.
Ensure you have global administrator access to the Microsoft 365 admin center, as resolving backend migration errors may require opening a support ticket.
Verify File Accessibility and Create a Support Request
Check if the original documents are intact, and ask your administrator to contact Microsoft 365 support if the migrated files fail to open.
When using the Migration Manager in the SharePoint admin center to move on-premises files, hidden temporary lock files (indicated by the ~$ prefix) may be copied if documents were left open or improperly closed on the shared drive.
While the ~$ files themselves are harmless remnants, it is crucial to ensure your actual source files migrated correctly without corruption.
Locate the original Word or Excel files in your SharePoint library (the ones without the ~$ prefix) and attempt to open them using the Microsoft Word or Excel desktop application.
If the original files cannot be opened or display error messages, have a Microsoft 365 global administrator log into the Microsoft 365 admin center.
Navigate to 'Support' on the left-hand menu, click on 'New service request', and provide the details of your migration issue to initiate a backend investigation.

Manage Documents Efficiently with WPS Office
If you are frustrated by cloud migration complexities, temporary lock-file clutter, and backend support delays, try WPS Office. It provides a lightweight, highly compatible alternative for everyday document editing.
- 1. Download WPS Office: Visit the official WPS Office website to download the free installation package for your device.
- 2. Install the Application: Run the downloaded installer and follow the simple on-screen instructions to complete the setup.
- 3. Open Your Files: Launch WPS Office to easily open, edit, and save your existing Word, Excel, and PowerPoint documents.

Frequently Asked Questions
What exactly does the ~$ prefix mean in a file name?
The ~$ prefix signifies a temporary 'lock file' or 'owner file' created by Microsoft Word or Excel. Office uses these hidden files to track who currently has a document open, preventing multiple users from overwriting each other's changes simultaneously.
Can I safely delete files starting with ~$ in SharePoint?
Yes, if you verify that the original document (without the prefix) is fully migrated and opens correctly in the desktop application, you can safely delete the leftover ~$ temporary files from your SharePoint library.
Why did the SharePoint Migration Manager move temporary lock files?
Migration Manager duplicates the exact state of files on your source drive. If users left documents actively open during the migration, or if an Office application crashed previously and failed to clean up its hidden lock files, those ~$ files were synced over as standard files.




