How to Create an Address Database


Creating an address database is useful if you must keep track of a mailing list for business or personal use. Using a spreadsheet program, such as Microsoft Excel, is the simplest way of maintaining an address database.

  • Open Excel. If you are using a Windows-based operating system, left-click the "Start" button. Click "Programs," select Microsoft Word, then "Excel" from the menu.

  • Set up your database. About three rows down, enter the subject header "First Name" in Column "A." Enter "Last Name" in Column B, "Address" in Column C, "City" in Column D, "State" in Column E and "Zip code" in Column F.

  • Enter the addresses. Click the cell underneath the appropriate subject headings. Type the information for each address. Use the "Tab" key on your keyboard to move between each cell to enter information quickly.

  • Save your address database. Under "File," click "Save" to save your work to the folder of your choosing.

Related Searches


  • Photo Credit Kathrin Ziegler/Photodisc/Getty Images
Promoted By Zergnet


You May Also Like

  • How to Make Address Labels

    Address labels can be made on a computer by using either Microsoft Excel or Microsoft Word. Discover how to conduct a mail...

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

Is DIY in your DNA? Become part of our maker community.
Submit Your Work!