Hi @Spinster,

I believe what you envision is already possible with the latest version of the add-on. Please see the WIKIDATA* functions, namely WIKIDATAQID, WIKIDATAFACTS, WIKIDATALABELS in the documentation.

Cheers,
Tom

Hi Tom, thanks for the quick reply! I know and use these functions, I actually mean something different: give me the specific value(s) for one specific property/statement, rather than all statements as happens in WIKIDATAFACTS.

For instance, if I have a cell containing Q1282569, I'd like to ask specifically for the English-value label of its P109 property (profession), and then in a next cell to the right for instance its P569 (date of birth) and in another next cell its P570 (date of death).
Next row I might have another Q-number for which I'd also ask its P109, and then P569, P570, etc. Each cell requests one property specifically. I hope I'm making myself clear.

As this is very Wikidata-centric I thought about a separate add-on rather than integrated in the current Wikipedia-centered one, but maybe they can be integrated too.

@Spinster I think this is possible by working with native functions, check this example.

Thanks for the example! It is handy in case of single queries, but what about checking many values for many Wikidata items at once? I have created an actual example / use case of a dataset that I'm currently working with and that is a typical workflow for me. See the example here.

(I don't intend to burden you specifically with this request - I put this here on Phabricator in the hopes that other developers may see it too, and might be interested in looking into this!)

Thanks for the realworld example (I have created a copy
https://docs.google.com/spreadsheets/d/1pSXDJ0h_SxkupmvIVUruUrCpmlcHJp0hXK3oqIl17Sw/edit?usp=sharing
that I could edit). So, there is a solution for your column D
(=QUERY(WIKIDATALABEL(B2, "en"), "SELECT Col2")) and with a couple of
hops for your other columns, but I can see how this can be tedious. I
have created https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets/issues/10
and will work on this in the near to mid future :-)

I am now actively working on this and have just updated the GitHub issue accordingly: https://github.com/tomayac/wikipedia-tools-for-google-spreadsheets/issues/12#issuecomment-257088707.

Alright, this is now fully working. You can as of now say…

WIKIDATAFACTS("Q42", "all", "P106")

…to get all of Douglas Adams' occupations (i.e., P106). If you replace "all" with "first", you will just get the first occupation.

If you want several properties, pass them as an array like…

WIKIDATAFACTS("Q42", "all", {"P31"; "P106"})

To reflect the changes, I have renamed the add-on to "Wikipedia and Wikidata Tools for Google Spreadsheets" :-)

Great! Thank you so much :-)