DIY Address Form

I love using Google Docs spreadsheet for my wedding related items because I can work on them at home but also work on them during my lunch breaks at work. When I was playing around with the spreadsheets, I noticed a “form” option. I then a found great solution to just send out a form to my entire guest list for them to send me their address and Google Docs automatically places their address into a spreadsheet.

Step 1Google DocsYou must already have a google account for this. Create New: Form

Step 2You need to then create the fields for the user to fill out. I only had two fields for them – name and address. That way whoever fills out the form will be always remember to add their name so you do’t have to guess who lives where. Here’s how my form fields look:

You also can choose the theme of how the form will look to whoever you email to. Just click: Theme

Here’s how my form looks to whoever I emailed it to:

Step 3

Email the form!

Step 4

View responses. Here’s how all the responses will look:

Then you can sort the list however you like. You can also save the file as an Excel file and use it there if you’re more comfortable with Excel. I ended up using my list to make a mail merge to print all my STD envelopes.

I did this as well but I made separate first name/last name fields. This makes it easy to find specific people when I sort by last name. I also made a field for the name of the spouse/significant other to get a rough estimate of plus ones. The resulting sheet is being used for all things guest related. I’m tracking whether or not they’ve been sent a Save the Date or invitation as well as seating assignments and eventually what gift they gave and whether or not they received a thank you card.