Spreadsheets for Librarians

Getting Results with Excel and Google Sheets

by Bruce White


Learn how to use spreadsheets for dozens of purposes in public, school, university, and special libraries.

Print Flyer
Cover image for Spreadsheets for Librarians

July 2020

Libraries Unlimited

Pages 210
Volumes 1
Size 6 1/8x9 1/4
Topics Information Systems and Technology/Database and Other Retrieval Systems
  Research Methods, Statistics, and Data/Data Analytics
  • Forthcoming!




    Add to Cart
  • eBook


    eBook Available from ABC-CLIO
    Email ABC-CLIO
    Call Your Preferred eBook Vendor for Pricing

  • International Pricing

    Paperback: £39.00/44,00€/A$72.00

Work smarter and save time with the librarian's guide to the hidden-in-plain-sight secrets of Excel, Sheets, and other types of spreadsheets.

While some librarians have become very skilled at using the full power of Excel and Sheets to turn data into useful and valuable information, for many librarians the relevance of spreadsheets—and how to use them—is not necessarily obvious.

This book demystifies Excel and other spreadsheets. Starting from basic concepts, the book progresses to advanced implementations important to librarians in areas such as collection management, including evaluation and benchmarking; research assessment, through the creation of sophisticated bibliometric measures; and library design, based on an analysis of patron behavior or the creation of a keyword map of physical collections. Real-life examples highlight a variety of techniques and shortcuts that can be immediately applied to libraries of all kinds.

Excel and Sheets for Librarians is a book for the desk, not only the library shelves. No prior knowledge of spreadsheets is needed, and readers can expect to learn skills that will enhance their reputation as information and data professionals.


    • Illustrates spreadsheet techniques that are immediately applicable in a wide variety of library contexts
    • Explains the potential of readily available data as a means to enhance individual and institutional performance in the library and information sector
    • Helps librarians think like data and information specialists
    • Showcases skills that are portable and independent of more narrowly-focused software packages
    • Shows how to communicate more effectively with IT specialists
Author Info

Bruce White is copyright and open access advisor at Massey University, New Zealand. He has worked in both public and university libraries, and his career has spanned the transition from an almost exclusively print-based library environment to a largely electronic one. He has written extensively on the role of libraries in education and scholarly research. His publications cover such areas as information literacy, academic search engines, open access and institutional repositories, distance library service, library metrics and bibliometrics and data-supported collection management. He has published in Library Review, College and Research Libraries, and New Zealand Library and Information Management Journal.

Other Titles of Interest

Librarian's Guide to Online Searching cover imageHarnessing the Power of Google cover imageApps for Librarians cover image
iPads® in the Library cover imageRaising the Tech Bar at Your Library cover imageInternet Technologies and Information Services, 2nd Edition cover image

Product Search

Product Search

Publication Year



Need Help? Try our Search Tips