I think tools like OpenRefine already do this once you link the row to the equivalent wikidata time you can add columns based on that linkage:

https://m.wikidata.org/wiki/Wikidata:Tools/OpenRefine