I'm biased, but I think this is a perfect use case for OpenRefine. What you'd need is an OpenRefine compatible "reconcilation service" provided by Wikidata that OpenRefine could use and then it'd allow you to match an entire column in spreadsheet, set a threshold for automatic matches, review candidates for those below the threshold, etc.
https://github.com/OpenRefine/OpenRefine/wiki/Reconcilable-Data-Sources https://api.opencorporates.com/documentation/Google-Refine-Reconciliation-API http://refine.codefork.com/ https://wiki.duraspace.org/display/VIVO/Extending+Google+Refine+for+VIVO Tom On Thu, Jul 23, 2015 at 2:44 AM, Sandra Fauconnier < [email protected]> wrote: > Hi everyone, > > I’ve been in the situation quite often (edit-a-thons; various to do lists) > where I had a list of terms (most usually names of a few hundreds of > people, or titles of Wikipedia articles), where I wanted to do a quick > search on Wikidata to retrieve each of these concept’s Q number. > Does anyone know of a tool that helps me make this easier? Enter a list > of, say, 100 of these search terms, and receive Q number suggestions for > each of them? I’ve looked around on wmflabs but have not found anything in > that direction (also not with the help of Hay’s awesome tool directory > <http://tools.wmflabs.org/hay/directory/#/>). > > Till now, I’ve done all these searches manually - use an excel sheet, look > for each term individually, enter Q number for each term - quite accurate > but very time-consuming! > > Would appreciate all help/tips ! > Thanks! Sandra (User:Spinster) > > _______________________________________________ > Wikidata mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/wikidata > >
_______________________________________________ Wikidata mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikidata
