Merging Dates into a Multi-Page InDesign Planner Template

by

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: https://www.youtube.com/watch?v=lHaUvSYpW1E&t=1449s

Website tutorials I used when I was trying to figure this out:
https://redokun.com/blog/data-merge-indesign
https://gcostudios.com/how-to-data-merge-in-indesign-cs6-tutorial/

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.

Share

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

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: