Skip to main content

Questions tagged [importjson]

Do not use this tag. ImportJSON is an add-on and questions about browser extensions/add-ons are off-topic on this site. For on-topic questions about scripts and custom functions include the script in your question and use the tags [google-apps-script] and [google-sheets-custom-function]

Filter by
Sorted by
Tagged with
3 votes
2 answers
2k views

Convert columns of ISO 8601 strings to dates in Google Sheets

I'm pulling data to my sheet from an API using an ImportJSON function. The data array contains mixed data, including several columns of ISO 8601 date strings in UTC. For example: 2020-06-02T00:00:00Z ...
Julius's user avatar
  • 243