App Icon
•  54
MatchMARC is a Google Apps Script published as a Google Sheets Addon. It is a tool that automates MARC record searches. It uses OCLC's WorldCat Search API. You can configure the search to return your 'best' match directly within your Google Sheet.
This add-on allows you to automate searching for the 'best' MARC record using OCLC'S API.  The starting point is a spreadsheet that contains a list of ISBNs or LCCNs.  You can configure the match criteria (e.g. records we hold, 042=pcc, 040=dlc) and the MARC fields you would like written to the spreadsheet when a match is found.  If a match is not found using your criteria it will use the record with the most holdings.

You will need your OCLC API key.  After you have installed the add-on and entered the OCLC API key you can generate a sample configuration tab and a tab that contains a test searches.  Select the tabs in the two drop-down boxes and click the 'Start Search' button to launch the search.

If you would like a MARC file containing the records matched, enter your email address.  When the script finishes running it will email you the file.  (This is optional)

If you want the search to start at a specific row you can enter a row number.  

Sort by:
Profile Picture
Tam Troup
April 23, 2020
Very easy to install and implement. The only feature request that I have is to extend the search parameters to support searching by ISBN or title. Title searches would be more ambiguous, of course, but the amount of time saved would be incredible. Thank you for creating this!
Is this review helpful?
Profile Pciture
A user of MatchMARC
July 1, 2020
Thank you for the suggestion! I'm interested in hearing more about your thoughts on a title search, since, like you said they are more difficult to lasso.
1-1 of 1
Additional information
Terms of Service
Clear search
Close search
Google apps
Main menu