How to generate UUID in Libreoffice Calculator/Excel?

10/07/2025 @ Saigon etc

LibreOffice Calc & UUID formula

In this post, I would like to make a note about generating UUID in Libreoffice Calc/Excel.

=LOWER(CONCATENATE(DEC2HEX(RANDBETWEEN(0,4294967295),8),"-",DEC2HEX(RANDBETWEEN(0,65535),4),"-",DEC2HEX(RANDBETWEEN(0,65535),4),"-",DEC2HEX(RANDBETWEEN(0,65535),4),"-",DEC2HEX(RANDBETWEEN(0,4294967295),8),DEC2HEX(RANDBETWEEN(0,65535),4)))

References

How to generate a column of unique IDs (UUIDs) in LibreOffice Calc?, 2022, Jan 11, mYnDstrEAm, https://superuser.com/q/1698721
How to create a GUID in Excel? 2013, Feb 20, Konrad Viltersten, StackOverflow, https://stackoverflow.com/a/41026697