Web Based Planner or Spreadsheet Wedding Template?
There are many different on-line wedding planners. For example, click here to see Marha Stewart’s on-line wedding planning tool.
I’ve created many different Excel based wedding planner templates and this one is the easiest to use.
Download my Wedding Template
Download the template: Wedding-Planner-v3.5_.
Watch my YouTube video
Compatibility
Please note that this file was created using Excel 2010 and also works in Excel 2013 & 2016. This file is not meant to be used with open office or google docs or Excel 2003.
Extend Input Ranges
Click here to see how to extend the input range for tasks & contacts (after watching intro video).
Modifications to the Excel file
Unfortunately I’m not always available to make changes to this template. But I will try 🙂
About Me
My name is Kevin Lehrbass. I’m a Data Analyst. I live in Markham.
Follow my blog to learn more about Excel and my journey with data.
Check out my recommend Excel training.
Very cool! Thanks for your hard work!
IS there a way we can add a number of guest with X person.
For example when we add a name is there a way to specify how many persons will attend with that guest?
John and sara are couples.
instead of listing both of their name i will just add john and put 2 pers.
Hi Johnny.
I considered this when creating the template but it would complicate the formulas so I ended up keeping it simple. Each row is a guest in the ‘Contact Input Sheet’. I have also experimented with adding more fields to allow linking one guest to another but this would also complicate it (and most people tell me they want something simple and easy to learn).
If you’re interested in a more robust and flexible wedding planner then I believe ‘wedding wire’ has one. You would have to invest some time to be able to use it but it has many advanced features. http://www.weddingwire.com/
Cheers,
Kevin
Also can you increase the number of seats per table to 12 ?
this is very useful, thanks and God bless
Hi Kabani,
I’m glad that you found it helpful!
Cheers,
Kevin
Hi, Kevin –
I just found your template, and well, I downloaded and opened it and it stops at wedding dates in 2019. Here’s my problem as I’m getting married, or planning to, in 2021 – to my high school sweetheart and 1st husband, who I married 1st in 1981. We divorced in 1983 (I was very young).and then found each other again through FB in 2012. He moved across the country to live with me in 2016. I’ve chosen the date because it will be 40 years exactly since our first wedding. Can you tell me how to adjust the dates past 2019, or send an updated version? I find most of the templates available online to be too fluffy-foo-foo for my taste, and from what I’ve seen, yours is ultra-functional.
Thank you for your time!
Pingback: 10 of the Best Free Wedding Planning Spreadsheets
God bless for your time and generosity
I’ts very useful, thanks one more time
Hi Eric,
You are welcome! I’m glad you’ve found it helpful 🙂
Thank you for visiting my blog!
Cheers,
Kevin
Hi Kevin!
Thank you so much for your hard work on this! I’m getting started on using it for planning my Spring 2024 wedding, and I’m thrilled at how comprehensive it is. There’s so much flexibility, but enough rigidity that it’s reminded me of lots of important tasks.
Did you share the password to un-protect the sheets? I don’t want to make changes to your robust formatting, but there’s tiny things I want to change, like the size of text headers and the width of columns. I hope that’s okay!
Thanks again, and I hope you’re having a great day!
Hi Ozzy. I think the password is: test
Or…it could be a null password (nothing at all).