Excel's new data types and OpenRefine's future data types

[Thad Guidry]

It's interesting how Microsoft has released several new data types for Excel over the past year...
https://insider.office.com/en-us/blog/revisiting-data-types-in-excel

And more interesting to think about how they offer an experience of auto-reconciliation for known strings within those data types.

And more interesting to think about how with the power of OpenRefine, Wikidata, templates, ShEx, and enhanced recon services (OCLC, Wikidata, others) that OpenRefine might also give users more powerful auto-reconciliation as well with known data types or discovered or queried data types.

Something to ponder, and invest in perhaps for those domains that the community deems important.

Enjoy the weekend everyone! Stay safe!

Thad

https://www.linkedin.com/in/thadguidry/

https://calendly.com/thadguidry/

[Tom Morris]

I was hoping you were going to say they'd added something simple and nice like a date data type rather than their current weird hybrid of data type + format string. Unfortunately, no. :( 

The extensible data types concept sounds interesting until you get to the restrictions. 

Requirements 

• Data types require a Microsoft 365 subscription.  
• Some of the new data types are only available to the Consumer audience in English-speaking markets

--
You received this message because you are subscribed to the Google Groups "OpenRefine Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine-de...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/openrefine-dev/CAChbWaMXMz9ChHfj9-4sY15r60nc%2BLAG79PYy3awrtFO1M92Nw%40mail.gmail.com.