---
title: "Google Apps Script snippet for Google Sheets to view json strings in a modal dialog"
author: "Martin Hawksey"
date: 2020-01-23T14:43:24+00:00
canonical_url: https://pulse.appsscript.info/p/2020/01/google-apps-script-snippet-for-google-sheets-to-view-json-strings-in-a-modal-dialog/
markdown_url: https://pulse.appsscript.info/p/2020/01/google-apps-script-snippet-for-google-sheets-to-view-json-strings-in-a-modal-dialog.md
categories:
  - "Sheets"
  - "Snippet"
tags:
  - "@rieln"
  - "GitHub"
  - "Zzapps"
featured_image: https://pulse.appsscript.info/files/2020/01/image.png
description: "View json strings in a modal dialog. Activate the cell that contains a JSON string Click menu item A foldable JSON will be shown in the modal dialog Handy little Google Apps Script snippet from..."
---

# Google Apps Script snippet for Google Sheets to view json strings in a modal dialog

![Google Apps Script snippet for Google Sheets to view json strings in a modal dialog](https://pulse.appsscript.info/files/2020/01/image.png)

> View json strings in a modal dialog. Activate the cell that contains a JSON string Click menu item A foldable JSON will be shown in the modal dialog

Handy little Google Apps Script snippet from Riël Notermans (Zzapps) that makes it easier to view any JSON you are storing in a Google Sheets cell.

Source: *[Zzapps/google_sheets_json_viewer*](https://github.com/Zzapps/google_sheets_json_viewer)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/01/google-apps-script-snippet-for-google-sheets-to-view-json-strings-in-a-modal-dialog/](https://pulse.appsscript.info/p/2020/01/google-apps-script-snippet-for-google-sheets-to-view-json-strings-in-a-modal-dialog/)*