Bring Wikidata to your spreadsheets with an easy-to-use add-on!
Wikidata Reconciler is a tool for researchers, data journalists, librarians, and wiki-editors who need to enrich their datasets with structured data. Instead of switching apps to search wikidata.org or learn complex software, you can search and match entities right from a seamless sidebar in Google Sheets.
Core Features
- Instant entity matching: Select any cell containing a text query and search Wikidata directly from the sidebar.
- Smart data insertion: With a single click, automatically insert the correct Wikidata QID, labels, and descriptions into adjacent columns.
- Multi-language support: Configure the tool to fetch labels and descriptions in your preferred languages.
- Preserves your data: Safely inserts new columns for the retrieved data, ensuring your original search terms are never overwritten.
- Fast workflow: Built-in smart jump logic automatically moves you to the next empty row after a successful match, keeping your hands on the keyboard and speeding up manual reconciliation.
How to Use
- Open the add-on from the Extensions menu (Extensions > Wikidata Reconciler > Open sidebar).
- Click on a cell containing the data to match, for example the name of a person, place, or concept.
- Review the live search results in the sidebar.
- Click the correct entity to instantly map it to your spreadsheet.
Further Work
- Interface enhancements to make the process more intuitive.
- Connect to Eka Reconciliation app for rich media interfaces for reconciling.
Code Repository
https://github.com/AvoinGLAM/wikidata-reconciler-gs
Privacy Policy
https://github.com/AvoinGLAM/wikidata-reconciler-gs/blob/main/PRIVACY.md
Terms of Service for Wikidata Reconciler
Last Updated: 5 March 2026
1. Acceptance of Terms By installing and using the “Wikidata Reconciler” Add-on (“the Add-on”), you agree to these Terms of Service.
2. Description of Service The Add-on is a tool designed to search the Wikidata database and insert corresponding data (QIDs, labels, descriptions) into your Google Sheets.
3. Fair Use and Rate Limits The Add-on relies on the public Wikidata API. You agree to use the Add-on in a reasonable manner that does not violate Wikidata’s API usage policies or intentionally overload their servers.
4. Disclaimer of Warranties The Add-on is provided on an “AS IS” and “AS AVAILABLE” basis. We make no guarantees regarding the accuracy, reliability, or completeness of the data retrieved from Wikidata. We do not warrant that the Add-on will be uninterrupted or error-free.
5. Limitation of Liability To the maximum extent permitted by law, the developer of the Add-on shall not be liable for any direct, indirect, incidental, or consequential damages resulting from your use of the Add-on. This includes, but is not limited to, data loss, spreadsheet corruption, or decisions made based on the retrieved data. Always maintain backups of your important spreadsheets.
6. Changes to Terms We reserve the right to modify these Terms at any time. Continued use of the Add-on constitutes acceptance of those changes.