Sign inStart my diary

A free template to keep track of your puzzles

1 min

If your puzzle list lives in a phone note, in an Excel file you cannot find any more, or only in your head, this template is the shortcut: it is exactly the set of columns Jigsaw Diary uses, one row per box, and importing it saves you typing them one by one.

What is in it

  • Title: the name of the box, as it comes.
  • Brand: who made it (Ravensburger, Clementoni, Educa...).
  • Pieces: the number, just the number (1000, not "1000 pcs").
  • Status: finished, building, on the shelf or on your wishlist.
  • Finished on: the date, as YYYY-MM-DD (the day you finished it).
  • Barcode: optional. With it, the app recognises the box even if you do not write the title.

How to use it

  1. Download the template (it is a CSV: Excel, Numbers and Google Sheets all open it).
  2. Fill in one row per box. The order does not matter; the only thing you really need is the title.
  3. Create your account in Jigsaw Diary and go to Import.
  4. Paste the cells or upload the file. First it shows you how many boxes are going in and which ones are left out.

And if you already have it in a spreadsheet

You do not have to convert anything. The importer understands the column names in all seven languages of the app (Title, Brand, Pieces, Status, Finished on...) and also the ones Excel uses in English (Title, Brand, Pieces, Status, Date finished). Paste the cells as they are.

A wishlist item is not a box: it is what you want, not what you own. In the app it is marked separately, just like in the template.

The real data: how long each puzzle takes →

The columns

The same ones the importer uses, so there is nothing to change when you upload it.

A CSV with the columns the app understands, in the language you are reading. Open it with Excel, Numbers or Google Sheets.

Upload it to Jigsaw Diary

Create your account, go to Import and paste or upload the file. It shows you what is going in before it does.

Import my collection

Keep your own puzzle diary

Free, no ads, in your browser. Log what you build, time it if you want to and see what other puzzlers finish.

Start my puzzle diary

All the guides