google-chromedatetimegoogle-sheetsdata-conversionbookmarks

Is there a Google Sheets formula to convert the 10-digit "ADD_DATE" in a Chrome bookmarks.html file to a human-readable date/time?

I checked other questions here about this, but either the date/time numeric formatting has changed since the answers were given, or something else is wrong because the numbers they're using are 17 digits, and the ones I see in the bookmarks.html file are all 10 digits. e.g.:

<DT><A HREF="https://www.amazon.com/gp/aw/contact-us/ref=hp_gt_comp_cu#csp" ADD_DATE="1672512521"

Does anyone know if there's a Google Sheets formula I can use to convert these 10-digit dates in the exported bookmarks.html file to something like yy-mm-dd hh:mm:ss format?

Solution

  • You can use the EPOCHTODATE function.

    =EPOCHTODATE(1672512521)