Peelback

How to open a plum.sqlite file from Windows Sticky Notes

plum.sqlite is the file Windows 10 and 11 use for your Sticky Notes. You can read it without the app: in the browser with Peelback, or in a database browser with a little decoding.

Checked 5 November 2026

Peelback: a stack of coloured notes with a peeled corner and the file names plum.sqlite and StickyNotes.snt plum.sqlite StickyNotes.snt

Open the Sticky Notes files

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.

ColumnWhat it holds
TextThe note, one line per block. Each line starts with an anchor such as \id= and a GUID, then the words.
ThemeThe 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.
LastServerVersionA JSON copy of a note that was synced with a Microsoft account, with its blocks and any pictures.

Open it with Peelback

  1. Close Sticky Notes, then copy plum.sqlite together with plum.sqlite-wal and plum.sqlite-shm from %LocalAppData%\Packages\Microsoft.MicrosoftStickyNotes_8wekyb3d8bbwe\LocalState.
  2. 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.
  3. 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.

Have the file? Open it here: nothing is uploaded. Open plum.sqlite or StickyNotes.snt

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

Checked 5 November 2026. Peelback is made by Peak Apps Studio and is not affiliated with Microsoft. Sticky Notes is a Microsoft product.