Analyzing Library Collection Use with Excel®

ALA Member
Item Number
ALA Editions
AP Categories

Primary tabs

You don't need to be an ALA Member to purchase from the ALA Store, but you'll be asked to create an online account/profile during the checkout to proceed. This Web Account is for both Members and non-Members. 

If you are Tax-Exempt, please verify that your account is currently set up as exempt before placing your order, as our new fulfillment center will need current documentation. Learn how to verify here.

  • Description
  • About the authors

In this unique guide, two collection development experts show how to use Excel® to translate circulation and collection data into meaningful reports for making collection management decisions. Step-by-step instructions accompanied by screen shots allow anyone to use Excel® to quickly "crunch the numbers" that often bog down library use studies. Analyzing Library Collection Use with Excel® gives library collection analysts the ready tools to

  • Process raw data into usable information
  • Understand the varieties of possible analyses
  • Identify the most relevant types of analysis for their collections
  • Identify weaknesses and build on the strengths identified in their collections
  • Illustrate circulation data using charts and graphs

This hands-on guide shows how to set up customized spreadsheets and processes all data into usable summaries. Librarians responsible for collection development in public, school, academic, and special libraries will learn why analyzing collection use is important and how they can analyze that use to better serve their patrons.

Visit the companion website for this book at Analyzing Library Collection Use with Excel.

Tony Greiner

Tony Greiner, a librarian at Portland (OR) Community College, works in collection development, reference, and bibliographic instruction. He has contributed to Library Journal and Public Libraries . Prior to becoming a librarian, he taught school, played the trombone, and drove the hippo truck for Carson and Barnes Circus. He earned his MLS from Emporia State University SLIS.

Bob Cooper

Bob Cooper has fourteen years of collection development experience in public and special libraries, including ten years' work with Microsoft's Office Suite (including Excel). A successful entrepreneur, he looks back fondly on his days as a bouncer in a Chicago bar. He earned his MLS from the University of Denver.