21 May 2013

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



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.



  1. Pamela says:

    Very cool! Thanks for your hard work!

  2. johnny says:

    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.

    1. Kevin Lehrbass says:

      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/

  3. johnny says:

    Also can you increase the number of seats per table to 12 ?

  4. kabani luyanga steve says:

    this is very useful, thanks and God bless

    1. Kevin Lehrbass says:

      Hi Kabani,
      I’m glad that you found it helpful!

  5. Alyssa Mehl says:

    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!

  6. Eric says:

    God bless for your time and generosity
    I’ts very useful, thanks one more time

    1. Kevin Lehrbass says:

      Hi Eric,

      You are welcome! I’m glad you’ve found it helpful 🙂
      Thank you for visiting my blog!


Post a comment