Microsoft Lists was designed to be used as a web site. The one limitation of that situation is that you haven't been able to view or edit a list while disconnected from the internet.
Now, on Windows (Windows 10 and later) devices running the OneDrive sync app, lists are available for viewing and editing when you're offline, too. With List sync, we synchronize the list data from the cloud to your Windows device, making fast list operations possible and allowing you to continue your work even when you're offline, you lose your internet connection, or you run into a service disruption in the app.
List sync lets you work seamlessly with a very large list; it will respond promptly when you sort, filter, or group your data, or when you change the view.
List sync doesn't change how you work with the Lists web app. It's still available for you to work on in a browser as before.
To verify that a list is synced and available for offline editing
Open the list.
Near the upper left of the page, examine the symbols next to the list name:
The "list is syncing now" symbol
The "list is synced" symbol
When you edit a list, the changes you make are synced back to the cloud—either right away (if you're online) or later (if you're offline at the time you make the changes).
Synced list data on your device is only available to you. If someone else were to sign in on your device, the synced data on the device wouldn't be available to them. We adhere to privacy guidelines outlined in the Microsoft Privacy Statement.
Resolve conflicting simultaneous changes
With Lists sync, it's possible for a conflict to occur if two people change the same item at the same time in different ways. The Lists app tries to automatically resolve the conflict, but if it can't do that, it notifies you about the conflict so that you can resolve it in an appropriate way.
To resolve a conflict
A red dot appears on the Switch view options menu to indicate a conflict exists:
Select Switch view options:
Select Items with sync issues.
You resolve conflicts by dismissing them or by manually correcting them. Select the conflicts you want to resolve, then select either Dismiss or Save items.
If you select Save items, info about the selected conflicts will be saved to a .csv file. Then you can examine that file and determine how you want update the list to manually correct each conflict.
Stop syncing a list
Open the start page of the Lists app.
Point your mouse at the list that you’d like to stop syncing, and then select the three-dot (...) Open actions menu.
Select Stop syncing.
After you stop syncing the list, next time you open that list you will no longer see the “sync” icon next to list name and that list will no longer be available offline.
A list that is syncing is indicated by a circled check-mark.
A list that's not syncing has no Sync symbol on it.
To resume syncing for the list, you simply repeat steps 1 and 2 and then select the Sync in step 3.
Current limitations of List sync
List sync is currently supported only on Windows 10 and later devices.
A full offline experience for lists—where you can perform all of the operations that are available online—is not yet supported. See item 3 below.
Currently, not all types of lists can be synced. The lists that are not supported right now are prevented from syncing, and no “sync icon” appears on the list. Following are the kinds of lists that aren't synced:
Lists that have the “Allow items from this list to be downloaded to offline clients” set to “No”
Lists that have display mode set to Classic experience
Lists with Lookup fields
Besides the restrictions above in item 3, there is the limit regarding which lists can be synced to your device: Only eligible lists created by you, or lists that were shared with you and opened by you, will be synced to your device. This includes lists that are visible in the Lists web app (Favorites, My Lists, Recent Lists). And if you delete a list or lose access to a list, it will be automatically un-synced from your device.
Working with a list while offline
When you're working offline, you can still open and work with your lists that have been synced to your device. Features that aren't available while you're offline are grayed out to indicate that you can't us them at the moment, as illustrated by the options circled in this picture:
Similarly, on the start page for the Lists app, if a specific list isn't synced to your device, you won't be able to open that list in the standalone app while you're working offline, as illustrated by the dimmed list in the middle below:
Bandwidth involved in List sync
When compared to OneDrive file sync, bandwidth consumed by List sync is minimal, and largely depends on the size of the list and how frequently the list is modified. Initial sync of the list results in syncing the entire list, but subsequent updates to the list result only in changes being synced.
Troubleshooting List sync issues
For troubleshooting common List sync issues, check out Common issues syncing Microsoft SharePoint lists offline.
Use Group Policy to control Lists sync settings
For preventing Lists sync to run and users from silently signing in, check out Lists sync policies.