Others

How to Fix School Data Sync UnmatchedEntry Errors in Microsoft 365

WPS Editor Sep 27, 2026 869 views

Question details

Users encounter UnmatchedEntry errors during School Data Sync (SDS) processes, particularly after migrating from Classic SDS.

How to Fix School Data Sync UnmatchedEntry Errors

Product: Microsoft School Data Sync
Device & OS: not provided
Scenario: Syncing StaffRoster or StudentEnrollment data after a Classic SDS migration or academic-year transition.
Observed behavior: The system returns an UnmatchedEntry error because class source IDs fail to match the corresponding entries in the JSONSourceDirectory.

Before you start

Ensure you have global administrator or SDS administrator permissions in your Microsoft 365 tenant to access error logs and make directory changes.

Solution 1Recommended

Verify Class Source IDs and JSONSourceDirectory Entries

Identify and correct mismatched IDs causing the UnmatchedEntry error.

The most common cause of this error is a mismatch between the data provided in your roster files and the established directory mapping, especially following a Classic SDS migration.

Review SDS Error Logs

Navigate to the School Data Sync portal and download the latest sync error log to identify which specific IDs are failing.

Check StaffRoster and StudentEnrollment Files

Open your source data CSV files and locate the class source IDs flagged in the error report.

Compare with JSONSourceDirectory

Ensure that the class source IDs in your roster files exactly match the active entries listed in your JSONSourceDirectory.

Update and Re-sync

Correct any discrepancies in your source data files, upload the updated files to the SDS portal, and trigger a new sync cycle.

Verify Class Source IDs and JSONSourceDirectory Entries

Academic Year Transitions: Review Microsoft's academic-year transition guidance, as expired terms or archived classes frequently cause ID mismatch errors during migrations.

Solution 2

Contact Microsoft School Data Sync Support

Escalate the issue to dedicated SDS support if data verification does not resolve the error.

Free Microsoft Office alternative

Manage Your Educational Data with WPS Office

While troubleshooting Microsoft School Data Sync errors, you can use WPS Office to efficiently manage, edit, and clean your StudentEnrollment and StaffRoster CSV files. It offers a familiar interface and full compatibility with Microsoft Excel formats without the heavy subscription costs.

1. Install WPS Office: Download and install WPS Office on your computer to handle spreadsheet data.
2. Import Roster Data: Open WPS Spreadsheets and import your StaffRoster or StudentEnrollment CSV files.
3. Clean Data: Use the 'Find and Replace' or 'Data Validation' tools to quickly locate missing or incorrectly formatted source IDs.
4. Save and Upload: Save the corrected CSV file and upload it back to your School Data Sync portal.

Fully compatible with Microsoft Excel (.xlsx) and CSV formats used in SDS.Lightweight and runs smoothly on older school district devices.Free to use with a familiar, easy-to-learn interface.Built-in data cleaning tools to help spot mismatched IDs quickly.

microsoft office alternative - wps office

Frequently Asked Questions

What causes an UnmatchedEntry error in School Data Sync?

This error typically occurs when the class source IDs in your StaffRoster or StudentEnrollment files do not correspond to the existing entries in the JSONSourceDirectory, often happening after migrating from Classic SDS.

Where can I find the exact IDs causing the sync failure?

You can identify the failing IDs by navigating to the School Data Sync portal and downloading the detailed sync error log for your most recent profile run.

Can I use WPS Office to prepare my SDS data files?

Yes, WPS Office Spreadsheets fully supports opening, editing, and saving CSV files, making it an excellent free tool for cleaning up roster and enrollment data before uploading it to School Data Sync.

Office Quick Solutions