Merging Dates into a Multi-Page InDesign Planner Template


As requested: here is the video where I show you how to perform a merge in InDesign to import dates (and other information) from an Excel file. Please note that in this video I assume you have a working knowledge of both InDesign and Excel and don’t go in depth into how to use either. (Unfortunately, that would be a really, really long video and I would rather make sure you get the information that I had to figure out on my own.)

If you would like more information on creating a basic planner template in InDesign, Maryanne Moll has a video on her channel explaining how:

Website tutorials I used when I was trying to figure this out:

Sample excel file available for download here. The excel file contains an entire year. To use as is, simply update cell C2 with the start date you would like to use, and the entire file should auto-update. Save the file as a tab-delimated .txt file to use in an InDesign merge.


Sewist, knitter, reader, dancer. Wife. Lover of things vintage and retro.

%d bloggers like this: