Special Collections Home :: Family History Center :: Submitting Data Search Special Collections | Contact Us

Submitting Data for Western States Historical Marriage Index

Steps to follow:

  • E-Mail or contact the Family History Center so we can confirm that the data is needed and is not duplicating work already being done.
  • Prepare an Excel spreadsheet to help us automatically upload your data. If you do not have access to Excel let us know so that we can approve other spreadsheet formats.
    • In preparing the spreadsheet follow the example below and use the subExample.xls file.
    • Do not use the apostrophe '  to indicate a string in the spreadsheet, just type the data into the cell.
    • Dates should be in the date-month-year format 20 Jan 2004, no hyphens. To achieve this format you may have to create a custom date format. You can do this by selecting the dates and choose format cells, find the closest date match to 20 Jan 2004, and then choose the custom options and take out the hyphens.
  • If you have any question in your spreadsheet, e-mail us a sample of what you have and we can confirm if the formatting is correct.
  • After reviewing the records, send them to us by e-mail. If the file is too large for our e-mail capacity for attachments, you can mail them to us on a CD. Make sure to keep a backup copy on your computer!

Column Heading Example:

last_name first_name residence place date county state volume page comment blast_name bfirst_name bresidence

  Column Name Column Description Maximum Character Size
  last_name Groom's Last Name 40
  first_name Groom's First Name 60
  residence Groom's place of residence - city, county, state 80
  place Marriage place 70
  date Marriage date 11
  county County of record 30
  state State of record 20
  volume This column is based on the county's record system 11
  page Accompanies the volume number 11
  comment Meaningful comments that are brief are included here 500
  blast_name Bride's Last Name 40
  bfirst_name Bride's First Name 60
  bresidence Bride's residence - city, county, state 80