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.

Tom

On Thu, Jul 23, 2015 at 2:44 AM, Sandra Fauconnier <sandra.fauconnier@gmail.com> 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).

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
Wikidata@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata