Download Library Addresses

The Massachusetts Library Directory provides contact information for 1700 libraries of all types in Massachusetts. All libraries listed are members of the Massachusetts Library System (MLS).

This downloadable version of the directory provides basic mail contact information for member libraries in a format that is easy to import into spreadsheet, word processor and database applications. Data is updated nightly.

Download the "mass_libraries.csv" file. Your browser should prompt you to save the file.

Download
Save As Dialog Box

Click on the Save button, and put in the folder of your choice.

File Save Dialog Box

The file is in a format called "CSV" or "Comma-Separated-Values" Your spreadsheet (e.g., MS Excel, Quattro Pro) or your database (e.g., MS Access) should be able to open the file easily.

Opening in Microsoft Excel (Windows)

On most computes, MS Excel recognizes csv files automatically. To open, use your Windows Explorer to find the file. Then doubleclick the file. MS Excel should open up with the data showing. The top row will have the field labels. You will probably need to resize the column widths to see all the data clearly.

If the csv file extension is not yet associated with Excel, you can simply open Excel, then follow these steps:

  1. Click on File | Open

  2. Change the Files of type: dropdown to Text Files (*.prn;*.txt;*.csv)

    Open Text File from MS Excel

Importing into Microsoft Access (Windows)

  1. Start MS Access.

  2. Create a new database, or select an existing database where you want to import the library data.

  3. Right-click in Tables and select "Import"

    Importing in MS Access
  4. In MS Access' "Save As" dialog box, change the Files of Type dropdown from the default value of "mdb" to Text Files (*.txt;*.csv;*.tab;*.asc)

    Selecting CSV as a file type.
  5. A text file import should open up. Accept the default value of "Delimited" and click Next

    Delimited Text File Wizard, 1st screen
  6. On the 2nd screen, select "First Row Contains Field Names" and leave the remaining default values alone (Comma as field delimiter and doublequote mark as text qualifier)

    Delimited Text File Wizard, 2nd screen
  7. Store your data in a new table. (Or you may choose to overwrite older data that you had imported previously.)

    Delimited Text File Wizard, 3nd screen
  8. Leave all the Field Options alone, and click Finish

    Delimited Text File Wizard, 4nd screen
  9. You should now have an MS Access database table from which you can run queries and mailing labels.

This Web site, and other programs of the Massachusetts Board of Library Commissioners, is funded in part with funds from the
Institute of Museum and Library Services, a federal agency that fosters innovation, leadership and a lifetime of learning.
Page last updated on 02/13/2013