IMPORTANT: Regardless of how you submit the data, your file needs to include all youth, even if they have been submitted in previous years. When the new youth file is received, it will replace all the youth currently on record for your congregation. If the file is only a partial listing, then the rest of the youth in the congregation will be removed.

Step 1: Download the Template

To download, right-click on this link Microsoft Excel Template File and from the menu select "Save Target As")

Notes: Requirements for using the Template:

• When you use the template file please note that all of the columns must be kept intact so that the LCMS database software is able to accurately match your columns to the columns in the LCMS database.  You must not add or delete columns.
  
  
• The information on the first two lines of the file needs to be filled in - the Congregation ID from the form you received, and the Congregation Name and contact data,
  
  
• In order for a record in the spreadsheet to be valid for insertion in the LCMS database, the following columns are required to be filled in:

First Name
Last Name
City
State
Zip
Country
Graduation Year

(State and Zip are required only for USA and Canada.)

• The "Birth Date" column must be one of the following formats:

MM/DD/YY (02/21/86)
MM-DD-YY (02-21-86)
MM/DD/YYYY (02/21/1986)
MM-DD-YYYY (02-21-1986)

• The "Graduation Year" column must be in four-digit format (for example, 2011).

If you have any questions, contact the LCMS Office of Rosters and Statistics at YouthList@lcms.org.

Step 2: Fill in the Information

Now you are ready to type in the information.  Please include all youth in a single document.

Church Information.  Begin by providing the church identification number (included in the mailing) and congregational contact information.  An easy way to move between the columns is to “tab” over or use the arrow keys.

Youth Information.  You are ready to provide information on the youth for your congregation.  Be sure to include information in all of the required columns.

Step 3: Save your work

Under “File” click on “Save As.” (By saving this template on your computer, you will have a starting place for submission of next year's list.)  

NOTE:  This file contains personal information and should be safeguarded for the protection of your youth.

Step 4: Submit the file

Once your file is saved, open an e-mail message to youthlist@lcms.org  and attach the file you completed.