Power Up Planner Page Creation with Data Merge in Affinity Publisher
*** CLICKABLE CONTENT INDEX BELOW ***
Data Merge in Affinity Publisher takes the toil out of creating planner pages one at a time! Design a page once and use Data Merge to generate hundreds or even thousands of pages based on that design and custom information from your data source.
⏰ TIMINGS
00:00:00 - Start
00:50:00 - Introduction
00:05:18 - What is Data Merge?
00:12:50 - The Data Source in Excel
00:19:13 - Handling Leap Years
00:23:25 - 1 Page Data Merge
00:33:20 - 2 Page Spread Data Merge
00:37:25 - Extending the Data Merge with Custom Time Blocks
00:52:08 - Add Sections to the Merged File
00:58:40 - Assembling the Final Planner
01:08:12 - Creating a Clickable Table of Contents for the Monthly Dividers
01:17:50 - Exporting the Final Planner to PDF
01:25:04 - Compressing the Final Planner PDF
01:27:10 - Integrating the Merged Planner Pages (Explanation)
01:28:16 - Wrap Up
01:34:28 - Q & A
It’s perfect for daily pages, daily spreads and much more.
Learn how to design optimal data source files in Excel and CSV format, layout files in Affinity Publisher and merge the two to create perfection Planner Pages every time.
It's planner page creation ... FAST!
💌 Want more free training? Check out: https://elainegiles.com/vip
❤️ Connect with me, I love to hear from you!
✍️ Blog: https://elainegiles.co.uk
🎬 YouTube: https://www.youtube.com/ElaineGiles?sub_confirmation=1
🐦 Twitter: https://twitter.com/elainegiles
📸 Instagram: https://www.instagram.com/elainegiles
🔗 LinkedIn: https://uk.linkedin.com/in/elainegiles
🟦 Facebook: https://facebook.com/elainegiles
#affinitypublisher #planner #datamerge
If you want to learn more about Affinity Publisher check out the recordings below:
💎 Affinity Publisher (FULL TUTORIAL): https://youtu.be/98cWyoStN_Q
💎 Mastering Page Layouts in Affinity Publisher: https://youtu.be/yqNwxPKMGcE
💎 Mastering Master Pages in Affinity Publisher: https://youtu.be/Kr5je_swyJU
💎 Mastering Text Styles in Affinity Publisher: https://youtu.be/b952gAxVnT0
💎 Working with Images in Affinity Publisher: https://youtu.be/FhpYQC5X2Cc
💎 Create Creative Tables in Affinity Publisher: https://youtu.be/8PiWMNzoVLQ
💎 Affinity Publisher: Build With Me: https://youtu.be/oghUASJ6zZQ
💎 Working with Colour in Affinity Publisher: https://youtu.be/PxyBqfL-dK8
💎 How to Create a Newsletter in Affinity Publisher: https://youtu.be/MKcdb6OGo7U
💎 Deep Dive Data Merge in Affinity Publisher: https://youtu.be/wav8wuucZUY
💎 Creating and Managing Assets in Affinity Publisher: https://youtu.be/2tp5hFOntiI
💎 How to Create a Table of Contents in Affinity Publisher: https://youtu.be/y3EPZWp2DhQ
💎 How to Create an Index in Affinity Publisher: https://youtu.be/BcJcV51JNxM
💎 Designing a Photo Book in Affinity Publisher: https://youtu.be/P904B6-C18A
💎 Advanced Photo Book Techniques in Affinity Publisher: https://youtu.be/h5EoiD4ffGY
💎 Design a Magazine in Affinity Publisher: https://youtu.be/d5BjWgbFG-I
💎 Create Tutorials in Affinity Publisher: https://youtu.be/KKH5Uoeqfls
💎 Create Planner Pages in Affinity Publisher: https://youtu.be/XTFCY8Yxewg
💎 Design an Interactive Digital Planner in Affinity Publisher: http://youtu.be/WS2VZLHBzd4
💎 Creating Snapshots in Affinity Publisher (FULL Tutorial): https://youtu.be/VyUgucxu8_w
💎 Affinity Publisher Beta (FULL TUTORIAL): https://youtu.be/wDfq4zOmmKk