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.
Listing updated:April 22, 2024
Works with:
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.  

Additional information
PricingNot available
SupportNot available
Privacy policy
Terms of service
MatchMARC will ask for the permissions shown below. Learn more
MatchMARC will need access to your Google account
This will allow MatchMARC to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
Connect to an external service
Send email as you
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
A User of MatchMARC
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?
1-1 of 1
Clear search
Close search
Google apps
Main menu