What plum.sqlite holds
It is a SQLite database. The table Note has one row per note. Three columns matter when you read it by hand: the body, the colour and the times.
| Column | What it holds |
|---|---|
| Text | The note, one line per block. Each line starts with an anchor such as \id= and a GUID, then the words. |
| Theme | The colour as a word: Yellow, Pink, Blue, Green, Purple, Gray or Charcoal. |
| CreatedAt, UpdatedAt, DeletedAt | .NET ticks: 100-nanosecond steps since 1 January of year 1. DeletedAt is filled while a deleted note is still in the table. |
| LastServerVersion | A JSON copy of a note that was synced with a Microsoft account, with its blocks and any pictures. |
Open it with Peelback
- Close Sticky Notes, then copy plum.sqlite together with plum.sqlite-wal and plum.sqlite-shm from
%LocalAppData%\Packages\Microsoft.MicrosoftStickyNotes_8wekyb3d8bbwe\LocalState. - Drop the files on the tool page. The page merges the finished changes of the -wal file into the database, as SQLite does, and lists the notes with their colours and dates.
- Search, open a note, copy its text, or save the first five as one text file. Pro saves all of them in other formats.
Open it in a database browser
A tool such as DB Browser for SQLite shows the Note table. The Text column will show the anchors, and the time columns will show long numbers. This query turns the ticks into dates, as in the Sticky Notes query of the kacos2000 forensics repository:
SELECT Text, Theme,
datetime(UpdatedAt/10000000 - 62135596800, 'unixepoch') AS changed
FROM Note ORDER BY UpdatedAt DESC;
Why a note can be missing
Sticky Notes writes new edits to the -wal file first. A copy of plum.sqlite taken while the app was open, without its -wal file, misses the newest changes. Add both files. A note that was deleted in the app can still be in the table with a DeletedAt time, and Peelback marks it as deleted.
Questions
Can I open plum.sqlite in Excel or Notepad?
Not usefully. It is a binary database, so Notepad shows noise and Excel does not open it. Use a SQLite viewer or Peelback.
Is it safe to drop my plum.sqlite on the page?
The page reads the file in your browser tab and sends nothing. You can switch the network off after the page has loaded and it still works.
Sources
- kacos2000/Win10: Sticky Notes folders and the Note columns
- winotes (MIT): the Note table, \id= blocks, themes
- omi stickyNotes.ts (MIT): reading plum.sqlite with its -wal and -shm
- SQLite file format (database file, write-ahead log)
Checked 5 November 2026. Peelback is made by Peak Apps Studio and is not affiliated with Microsoft. Sticky Notes is a Microsoft product.