How to create a digital planner + SAVE TIME

[@epfreezer33]

Very helpful video. One suggestion in Excel to save a little time would be to use the SEQUENCE function. It would look something like this: In cell A1 put the formula =SEQUENCE(365,1,DATE(2022,1,1),1), where 365 = number of rows, 1 = number of columns, DATE(Year, Month, Day) = start number, and 1 = step size. Change the Year, Month, Day to your desired start date. Once you press enter, you will simply need to format the column with the desired date format.

[@bmas44]

that didnt work for me, the dates just spilled :(

[@houseofrelaxation2002]

This really helped :)

[@lucier5527]

I knew there had to be a more sophisticated way to create digital planners. I love my Adobe programs. Canva may appear like a fast solution, but the "teachers" of the tutorials leave much to be desired. A 15-minute lesson is presented as one-hour, rather clumsy, videos - ugh! Besides, Canva feels like stealing someone else's work every step of the way. THANK YOU for being the grown up and for being original!

[@MelissaPicconeart]

Great Tutorial. When you create a second master page - now known as Parent pages, you can base it on your original - so your B master should be based on A master and it will contain all of your tabs so you don't have to copy and paste.

[@cassielovesgreen]

Thank you so much, i used to type everything😭. Now this saves my time and effort♥

[@CarrieReagh]

It's always interesting seeing how people do things in InDesign. Great tutorial. I had to do the text import a bit different but finally got it to work as you did it. Interesting...I'm looking forward to experimenting with this method. Thank you!

[@ashleybramwell9680]

Wow, the excel text box trick blew my mind. Great video, thank you for sharing.

[@designerprintables160]

Thank you for your kind words! I’m always looking for ways to work smarter not harder!

[@thegypsycouple]

Thank you so much! You just saved me hours of typing….

[@designerprintables160]

My pleasure! I’m so happy to hear it saved you time!

[@BrannonSG]

This is ABSOLUTELY BRILLIANT. Thanks for sharing the time saving tip.

[@paolarico206]

Thank you so much for this video. It totally worked. I did my last digital planner on Canva and you just saved me days and days of work haha. Thanks!

[@valeriechausse5589]

Wow, I was looking for something else, but this was so helpful too! Thanks for your express course!

[@chrisbabygirl88]

This video helped me save so much time, you should definitely create more of these.Thanks so much!

[@designerprintables160]

I’m am so thankful my video helped save you time. I will be posting more. Thank you so much for sharing your kind words!!

[@pale924]

Thank you so much for the tutorial, It helps when working on planners. Thank you

[@mequable]

I needed this tutorial for something completely different, thank you for sharing!

[@shelleydenison]

*Exactly* what I was looking for. Thank you so much!

[@mcc267]

I don't want to spend a lot of money on templates I don't like. Looks like I'll be spending time to make something will actually use and enjoy! Time to put that graphic design degree to use haha thanks for the tips!!

[@KatherineFerguson-b5x]

Hi! Thanks for such a great video. Wanted to know what the best document setup/layout for it to be compatible with an ipad. Can it be changed later if I've used standard A4? Thank you!

[@michaelballinger1154]

That's class thanks a million for creating this video :)

[@rehanahmad1306]

The video is great. I just want to ask, if I have to hyperlink all the days to daily pages and so on, do I need to do it manually or is there any other way to save time?

[@cynthiamichelle033]

omg girl yes. This is what I have been needing! Thank you so much.

[@benosborne413]

Great video Excell trick great. I would have loved to see how the planner were created.

[@luxuryplanner8576]

Do you have this excel file? If you have please give me.

[@anyasker7055]

Very glad I found your channel.

[@designerprintables160]

Thank you for your kind words!

[@Nkhmwahl]

ThanQ so much I watch this 2 times and I will watch it agin and agin please if have any more videos or course about how to design this step by step for beginners I will be happy to know about it 🥰

[@designerprintables160]

Excellent. So glad you found the video helpful. I do have another video in the works ... hope to post this weekend. Thank you!!

[@Nkhmwahl]

@@designerprintables160 I hope that too 🌸💓

[@neraknerak1]

Thank you for the helpful excel tip.

[@ValeRougeS]

This is great! thank you!. Id like to know if it is possible to add 2 text flows per page? I am looking to include the date divided into the numbers and the days of the week (one above the other but in 2 different text boxes since the font will be different for numbers). E.g. 20 Monday. Hopefully you could help me with this. Thanks! :)

[@arhalia]

Ame tu video, claro, sencillo y conciso y el diseño de tu agenda limpio y completamente útil, ame todo 😍😍

[@mistyedilson9629]

It makes me want to give it a try! Thanks.

[@ismauribe]

Thanks for your knowledge, I created my first digital planner. I imported it on GoodNotes, every works as expected, but I have an issues. When I go back to GoodNotes and reopen my planner, it opens on the last page I was working on. What do I need to do so it opens on the cover every time I access it?

[@Lizhugs89]

Thins was really helpful. Looking forward to more in design planner tutorials ☺️

[@designerprintables160]

I’m thankful the tutorial helped you! Thank you for your kind words! 😊

[@blford7]

@@designerprintables160 Thank you so much for your quick reply! I’ll try that next!!

[@designerprintables160]

@@blford7 my pleasure Bianca! Thank you kindly for subscribing. I plan to make more of these tutorials...would love to know anything in particular you’d like to see. ☺️

[@blford7]

@@designerprintables160 So initially when I created my document I did not have Primary text on!! I googled it and found that’s what I was missing!!

[@designerprintables160]

@@blford7 awesome!!

[@_abbadoo_]

I have my calendars set up numerically in a table (like your year at a glance page). How would you go about updating that since it’s not a text box.

[@Redhanium]

Amazing video!!! Thank you so much exactly what I needed. Just one question, for the daily calendar, did you hyperlink each day to the pages you created or is there a way to automate?

[@designerprintables160]

Thank you, I’m so happy it helped. Yes, I do hyperlink each day individually…wish I could discover a way to automate that too. 🤣 let me know when you discover how please.

[@melvynpaulino6183]

You have opened my mind and I thank you for that. ❤️❤️❤️

[@melvynpaulino6183]

Please, do more videos explaining the process of designing digital planners, just like this one.

[@iebolas]

you. are. a. life saver. THANK YOUUU

[@SonnyBurnett2012]

To create a pdf planner to be opened on ipad, do i need an (doh!) an ipad? Or a simple pdf with editable/fillable fields will work flawlessy on ipad? Do we need a page specification size for ipad or any size will work? Thx

[@luxuryplanner8576]

How I can get your excel file? Thank you so much for great tutorial.

[@36badass]

Hi - nice clear movie, you make it easy ;-) I have a question about the links to the different days on "The year at a glance", are they made manually or is there a smarter way?

[@xime0674]

This is magic, thanks for sharing this! love ir

[@designerprintables160]

Happy you enjoyed. Thank you kindly!! 😊

[@xime0674]

@@designerprintables160 I wonder if there is a method to automate the hyperlinks of the whole document? Or the only way is to link one by one?

[@designerprintables160]

@@xime0674 that is a very good question. I have not discovered a way to do that just yet. But...that sure would save some time. 😊

[@angelahatch9329]

Great video I have a question , can use any font tu create any digital item and sell ?

[@designerprintables160]

You can use any fonts that allow commercial use. Typically, fonts installed on your computer are typically fine to use to create planners and sell. Hope this helps. Thanks for your kind words. 😊

[@MaggieMoon1000]

This is great, thank you. May I ask what paper size you used? Thanks.

[@ignacioquevedo7156]

look at the rulers, it is probably us letter size, due tuo the 8,5 x 11 inches

[@MaggieMoon1000]

@@ignacioquevedo7156 you're absolutely right. I completely missed the rulers. Thanks 👍🏼

[@ChandraSkinner]

This is a great tutorial. There is an easier way to insert the date on the daily, weekly page as well. Data Merge. If you need help with that please let me know.

[@designerprintables160]

Thank you Kindly, Chandra! I am familiar with data merge...that is a little bit more advanced than what I was showing on this video. Data merge is a great tool to import multiple sections of data at one time...just love technology.

[@ChandraSkinner]

@@designerprintables160 Yes, and I love to learn new things all the time. Are you going to show how you did the 12 month view click?

[@CarrieReagh]

@@ChandraSkinner @DesignerPrintables The only thing with doing a data merge is you would have to create that first, then do a data merge (connecting it with a CSV file with box 1 having "date" and not the first date in the file or it will start with Jan 2) which will create the 365 page file. Then you can add the other pages. If you do a data merge with the other pages already included (cover, or whatever) when you do the data merge it'll add those too. Unless there's another way. ?

[@SandyCruzHeySandyCruz]

My placed text has quotes on beg and end-of-date text. Is there something that has changed since you recorded this video that requires an additional step to eliminate the quotes?

[@Dula_95]

I totally love that tutorial! Tell me please, is there any way to save time on hyperlinks for daily pages?

[@designerprintables160]

Unfortunately, I have not found a time saving way to link multiple sets at one time. I will definitely make a video if and when I do! Thank you for your kind words!

[@chenelrexckrex710]

Wow this is sooooo helpful! Thank you

[@janesfavsvideos]

WOW!!!!!!! Can you do the same thing for the days of the week???

[@amypiersol1705]

I am so loving this tutorial and thank you for your efforts and taking the time to make it available. Very much appreciated. I do have a quick question and that is - it looks as though you're using the standard "letter" as your document in landscape mode, am I correct? Thanks in advance for your answer :)

[@designerprintables160]

Thank you for your kind words! Yes, I am using an 8.5” x 11” size page. This way they can be printed as PDF on Letter size as well. Thank you again, glad you enjoyed the video!

[@blford7]

This is such a helpful video! For whatever reason after I create my text box inside the rectangle and I click the selection tool- the option to flow text on master does not appear. I can’t figure it!

[@designerprintables160]

I’m so glad you found the video helpful! That tool is a bit finicky for me as well. Have you tried resizing the text box after grabbing the selection tool?

[@savedbygraceofjesus6074]

I’m wondering…(and u may not have the answer) but would it be possible to use the excel date trick with say text? If I have a set of quotes I wanted to add can I list them in excel and have them auto populate similar?

[@designerprintables160]

Yes, that would work. You’d have to type the quotes in excel but they should transfer over to InDesign accordingly! Great idea! Good luck! ☺️

[@savedbygraceofjesus6074]

@@designerprintables160 thanks girl your awesome

[@mouhssine8244]

Very helpful ❤

[@jasonhunter3429]

So these documents would work on a ipad?

[@designerprintables160]

Yes. With an app like GoodNotes or Notability.

[@karlaleon8000]

How do you hyperlink each day of the month in month at a glance ?

[@TheTops98]

Thank you very much. This is very good. Could you please tell me what is the Dimension you use for a Digital Planner ?

[@annastanphill7142]

Did you have two different hyperlinks for the circle in the right hand corner? How do you do that?

[@SandyCruzHeySandyCruz]

How can this merge be used on weekly horizontal and weekly vertical pages?

[@Whatnolareads]

My planner is kind of big my question is do I have to make pages and master pages for all the items that I have on my index page.

[@shrutisaini03]

Plesse mam add a tutorial to design the full yearly digital planner please mam, it will help me alott

[@Last222]

Is it fillable?...

[@piusl3237]

How can i create the Hyperlinks in my Doc?

[@juliadora69]

Work on Android tablet? Thanks

[@angelaaa]

Great tutorial! Is there an easy way/shortcut to hyperlink? Do you do it manually?

[@designerprintables160]

Thank you!! I have not been able to figure out a shortcut to hyperlink many items at one time. I do them manually and then copy them to other places to save time. Hope that helps!

[@thedesignflo]

How do you link to the daily pages from the yearly? Do you have a way to save time on that part too? I like your time saver! Awesome 😊

[@designerprintables160]

Unfortunately, I have not found a time saving way to link multiple sets at one time.

[@chrisbabygirl88]

Hi there, Is there a way to create a 2021 page with clickable links to all dates, without having to manually link each page? Thanks!

[@designerprintables160]

Not that I’m aware of. Would LOVE to be able to do that. If it helps, I link them all once and then copy paste. Even if you add pages after linking...the hyperlinks adjust to the new page number.

[@chrisbabygirl88]

@@designerprintables160 ahh I see thanks again!

[@designerprintables160]

@@chrisbabygirl88 my pleasure!

[@janmartenlocher]

Would this kind of work in Powerpoint, too..? ( I'm a PC User- with no InDesign, yet .. Thanks !!)

[@designerprintables160]

Not that I’m aware of. inDesign has a feature where you can continue text from text box to text box. Please let me know if you discover something differently. Thank you!

[@janmartenlocher]

@@designerprintables160 Thanks for your answer. And Ok, I will 🙂

[@NicoleMattos-fs6hw]

Can someone help me? It appears all dates equal in all pages, even with the excel trick. Thanks!

[@tinkataylor]

This is such a great video but unfortunately your screen is so blurry! I can’t read the little words on the Indesign site and it would be so helpful if I could, anyway to upload it with higher quality??

[@shannonmorey9388]

Hi I'm completely new to making digital planners. How big do you make your page?

[@designerprintables160]

So sorry for the delayed response. I make my pages letter size. 8.5” x 11”. This way the PDF files can be used as printed planner pages.

[@chibamoon6410]

When I export as a pdf, the interactive buttons no longer work, any idea of what's going on?

[@efarias]

It kind of work for me, but it created more pages than the 365 I created... it seems that it is including the extra rows in the excel file. Has anyone has a solution?

[@saraphanar6507]

Thank you.Where is part 2?

[@bmas44]

can you give a tutorial on weekly pages? My students would love this :o

[@NS2Las]

*// EDIT //* working on NOv 2021, week 47 ? could be my EYES, Sunday starts? 14, ends saturday, 20 , then week 48 starts corrected at 28, ends Dec 4 // worth checking the master files...

[@partypao]

I was wondering why you didnt talk about the final exporting of the file in a format that is compatible with different devices.

[@ariela_]

What do you mean

[@EvelynGonzalez-cb5yb]

hi, is there a way i can get the indesign file from you?

[@blford7]

Is there a formula weekly dates? I’ve watched a ton of KZbin videos- having no luck!

[@designerprintables160]

I found this... It seems to work for me.. I'm using excel on a Mac.

[@designerprintables160]

I was able to add 7 days... is that what you mean by weekly dates?

[@blford7]

@@designerprintables160 yes!

[@designerprintables160]

@@blford7 I’m realizing my image didn’t attach. I’ll type it out in another response to you.

[@chrisbabygirl88]

Hiya, I just have one question. I am trying to insert week numbers using the same process as my dates (which worked perfectly), but for some reason the indesign creates an additional 365 pages instead of using the 365 pages that were already there. Is there a reason why it may be doing that? I hope i'm making sense... Thanks!

[@designerprintables160]

Yes. I do understand what you’re asking. I work around this by creating another master page. And apply the master to the 365 pages you already created. (Create your text box for weekly dates on the master). You’ll want to copy your other main master to the new master as well. Let me know if I have added confusion on this response. ☺️

[@chrisbabygirl88]

@@designerprintables160 Once again this is amazing thank you! It worked.. thanks alot

[@designerprintables160]

@@chrisbabygirl88 excellent!! 😊😀

[@hyunsuhsong9337]

How do you link the stickers so that it will be inserted in certain desired pages? Thanks in advance.

[@NS2Las]

Hi there! Question, would you ( or do you ) sell your files so that we are able to make customizeable colors and fonts? (( sorry just asking if you did ... cheers ))

[@aurelieb7193]

I tried this, perfect ! The dates on my excel file are in french (good :D) but on illustrator it's in English :'( I make a french planner. Do you have a solution for that ? (Sorry for my bad english >

[@aurelieb7193]

Indesign (Sorry)

[@aurelieb7193]

I found :)

[@designerprintables160]

I’m so happy you found this video helpful. I would think that the language would be selected in the settings of InDesign. Do you typically use InDesign in English? I wish I could help more…thank you for your kind words!

[@socialwalter]

I can get the text from the excel doc to show up but it only shows the first date on all of the pages, it doesn't show up in sequential order. Anyone know what I'm doing wrong?

[@socialwalter]

14:40 "Let's go down to page #2, jump cuts, and then says "Let's go down to page #3".... Is this where I'm messing up? When I go back to my pages, not in the "Master B", to add the text "to the page", the text doesn't stay in the box I created.

[@NS2Las]

** // sent a message with some edits // ** ----- totally would love to get in debt with your strategy, I found this video very useful, but a noobie to digital planner has gotten myself very interested, more along "how to create". Do you have a more in debt video link I got watch, from start to end? I love the PDF, but rather the how to. Great job. by the way.

[@ariela_]

Does the person buying the planner need to have Adobe indesign to access it? My goal is to sell on Etsy

[@designerprintables160]

No. The person you sell the goodnotes planner to…does not need InDesign to access the planner. I only use InDesign to speed up the process of designing and building the planners. Good luck!!

[@ariela_]

@@designerprintables160 oh ok great, what is goodnotes?

[@vickiemaertz1505]

Will this work on a phone app or PC not only an Ipad?

[@designerprintables160]

You can use adobe in design or other apps like good notes and notability to create planners only using an iPad or tablet.

[@chrisbabygirl88]

Hello thank you for this. With indesign are you able to reduce file size for a 500 page planner under 10mb? Also can you bring an already designed planner over from keynote to reduce file size and add bookmarks? Thanks so much!

[@designerprintables160]

Thank you. I apologize that I am unable to answer your question confidently as I’ve never used KeyNote or attempted to import into indesign. I do have keynote and may try exporting and then importing into indesign. I’m thinking at a minimum it will import as flat...meaning not editable.

[@chrisbabygirl88]

@@designerprintables160 thank you

[@remotejourneys]

Hi, I have a problem with this. All my pages are showing January 1. Care to help?

[@designerprintables160]

The data that is showing in excel...is what should import into indesign. Are you seeing all the dates in excel?

[@idiladen7635]

@@designerprintables160 Hello there, thank you for this wonderful video and for explaining everything so well. Similar to Hazelrose, despite the fact all 365 days are showing in excel as you demonstrated, when I import the data to indesign, it only shows Friday Jan 1 on all the pages too. I would love to know how to fix this if you have the time. Thank you so much :)

[@allisontom3157]

@@designerprintables160 Hi, I'm having the same issue. Excel data is showing all the dates but when I place into indesign all the pages shows as Friday, January 1, 2021. How would I fix the dates so that they flow correctly? Would love to know how to fix this as well. Thank you!

[@NicoleMattos-fs6hw]

@@idiladen7635 Did you ever get an answer?

[@briplaysz]

But you didn't cover how you created the template... Do you have a tutorial starting from scratch to finish???

[@fram3471]

thx

[@arhalia]

Si das cursos por favor dime