How to Make an Address Label Spreadsheet in Google Docs
By Allen Bethea
In addition to performing financial calculations, Google Docs spreadsheets can serve as a simple database for your company's mailing list. Although Google Docs does not provide an application to directly maintain mailing lists or print address labels, you can quickly create an address label spreadsheet and export it as a cross-platform CSV, or Comma Separated Value, data file that more robust applications can import and use.
Log in to your Google Docs account.
Click on "Create" then select the "Spreadsheet" option.
Insert column headers into the first row that describe the data your address labels will contain. For instance, column A1 could be "First Name," B1 "Last Name," C1 "Address," D1 "City," E1 "State" and F1 "Zip Code."
Type the data for each label into a separate row beneath the corresponding column headings.
Click the File menu, select "Rename" then save your spreadsheet with an appropriate file name.
Click the File menu, click the "Download as" option then select "Comma Separated Values (.csv, current spreadsheet)" to save the file as a CSV file.
If you have just a few labels to print, you can use Google Docs to copy and paste data into an address label template. Click the Google Drive "Create" button then click "Document." Click the file menu, click "New" then select “From template.” Type "address label" in the search input box then press the "Search Templates" button. Select a suitable template for your address label brand and type then press the "Use this template" button.
Use Google Docs' Script Gallery mailing list and address label scripts with caution. Google does not guarantee that these scripts are safe to use or even if they actually work as intended. For instance, some scripts pose a security risk by requiring access to your Gmail contact list and permission to send out email. If your IT staff has sufficient programming skills, however, they may be able to edit the script's code to remove any insecure functions.
Allen Bethea has written articles on programming, web design,operating systems and computer hardware since 2002. He holds a Bachelor of Science from UNC-Chapel Hill and AAS degrees in office technology, mechanical engineering/drafting and internet technology. Allen has extensive experience with desktop and system software for both Windows and Linux operating systems.