Hi Neville,
It would help to see the original spreadsheet to see exactly what we are
dealing with.
For the Wikipedia part, I'm not entirely sure (I'm not a specialist of the
templates on en.wp ).
For Wikidata, OpenRefine[1] is probably the best tool. Here I know this
tool and I can probably help (or maybe even do it for you, depending on the
work and available time).
Plus, I see there is a NICPMI identifier in Wikidata which will help a lot
(to spot duplicates - because it's not just a bulk transfer as you don't
want to import what is already in Wikidata ;) - and to align/augment data),
I hope this identifier is in your spreadsheet too.
PS: maybe we can continue in private or in a small group if other people
are interested (either to help for Malta or in a similar situation in an
other country).
Cheers,
~nicolas
[1]
https://www.wikidata.org/wiki/Wikidata:Tools/OpenRefine
Le mer. 22 juil. 2020 à 09:49, Neville Borg <neville.borg(a)wikimalta.org> a
écrit :
Hi everyone,
We're looking for some advice/help/guidance - we would like to update our list
of monuments <https://en.wikipedia.org/wiki/List_of_monuments_in_Malta> that
are eligible for this year's edition of WLM to include a list of properties
scheduled by Malta's Planning Authority. We currently have this list as a
spreadsheet - what is the best way to go about transferring this to
Wikidata and Wikipedia? Is there a way to bulk transfer this list?
Thanks,
Neville
--
Administrator
Wikimedia Community Malta <http://www.wikimalta.org>
_______________________________________________
Wiki Loves Monuments mailing list
WikiLovesMonuments(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikilovesmonuments
http://www.wikilovesmonuments.org