Skip to main content

Statewide Interlibrary Loan: CT Union List of Serials (CULS)

Connecticut Union List of Serials (CULS)

The Connecticut Union List of Serials (CULS) is a list of print and microfilm journal and newspaper holdings for close to 400 libraries in CT.  It is hosted and maintained at OCLC. There are approximately 60,000 titles and 150,000 holdings in CULS. 

There are 3 Excel versions of CULS below, each sorted differently:

  • Sorted Alphabetically by Title
  • Sorted by OCLC #
  • Sorted by ISBN/ISSN

Some things to keep in mind and some tips on using the Excel version of CULS:

  • The data is current as of mid January 2017.
  • Each file is about 10 MB - they are on the large side.
  • Each file contains more than 155,000 rows.
  • It is abbreviated because the columns containing 'leader' information and publisher information, among a few others, were removed. This helped reduce the size of the file and there are only 7 columns in the spreadsheet. (There were more than 60 columns in the original files.)
  • Some titles, OCLC#s or ISBN/ISSNs are listed multiple times, i.e. appear on multiple rows. This is because there is one row for each library that owns the title (or OCLC# or ISBN/ISSN).
  • The summary of a library's holdings is in column F "Holdings Summary."
  • For the "Sorted by ISBN/ISSN" version - rows without an ISBN or ISSN are at the bottom of the sheet and they are alphabetical by title.
  • For the "Sorted Alphabetically by Title" version - the alphabetical arrangement is by Excel. Titles that start with symbols appear first on the list, followed by titles beginning with numbers, followed alphabetically A-Z. Also, for example, all of titles beginning with "A" are filed under the letter A and all titles beginning with "The" are filed under the letter T.

For Librarians: How to get a list of your library's titles

The Local Holdings Offline Product is available from OCLC at no charge.  Individual libraries can order a tab deliminated file of all of the local holdings they currently have in the Connecticut Union List of Serials from the OCLC site: https://www3.oclc.org/app/lhop/ .

Once produced the tab delimited file will be available for download from the Product Services Web and can be imported into a spreadsheet such as Excel.  If your library has more than 20,000 local holdings records, multiple files will be provided.  If you do not have an OCLC authorization and password, you can reply to the email that OCLC will send you asking for a temporary authorization and password to use to get the report.

A Quick Reference guide is available that covers the order process, how to download the file, and information on how to import the file into Microsoft Office Excel.

For Librarians: How to update your library's holdings?

Libraries with cataloging subscriptions to OCLC may update their serials holdings directly on OCLC.  Libraries without OCLC subscriptions may send their update information to Gail Hurley at the Connecticut State Library to imput into OCLC.

Here are ways to send updates:

  • Libraries may mark up the excel spreadsheet from the Local Holdings Offline Product indicating deletes, changes, and additions with varying colors.
  • You may email or fax changes
  • Sample forms for reporting Adds, Changes, and Deletes are available below

Email Gail.Hurley@ct.gov

Fax: 860-704-2228

Contact

This page is maintained by staff from the
Connecticut State Library | Division of Library Development | researchIT CT | Phone: 860-704-2224 | Contact Us

Connecticut State Library | 231 Capitol Avenue, Hartford, CT 06106 | 860-757-6500 * Toll-free 866-886-4478
Disclaimers & Permissions | Privacy Policy | State of Connecticut Home Page

The State of Connecticut is an Affirmative Action/Equal Opportunity Employer and strongly encourages the applications of women, minorities, and persons with disabilities.