JSON Editor Tutorial

1.  Open JSON Editor page . Enter JSON for editing and click "Upload & Edit in Workbook" button:

Enter JSON for editing

2.  Let's insert String into Array token. Open context menu in cell under [Empty Array] header and select Insert Array Item. Double click on cell under [Value] header and enter any text. Click Save:

Insert String into empty Array

3. If you want to insert item into Array after existing one, open context menu on cell with item index and select Insert Array Item - After:

Insert Array Item - After

4.   In order to remove item from Array open context menu on cell with item index and select Delete Array Item. Cell text will become strikethrough. Click Save:

Delete Array item

5. If you have number as String and want to store number as Number token, open context menu on cell and select Number. Click Save:

Cast String as Number

6. In order to change value token (String, Boolean, Number, Null)  to Object token, open context menu on cell and select Empty Object. Click Save:

Set Empty Object

7.  When you want to enter large Object or Array token, open context menu on cell and select Raw..., enter valid JSON in dialog, Click OK and Save:

Set Raw token

8.  Object with no value is represented as NULL token. Open context menu on cell and select NULL. Click Save:

Set NULL

9. If you need to insert or rename Property in all Object tokens from some Array token, open context menu on Property header and select Insert Property (Insert Additional Property) or Edit Property Name and confirm action in dialog:

Insert / Rename Property from Column header's context menu

10. If you need to remove Property from all Object tokens in some Array token, open context menu on Property header and select Delete Property and confirm action in dialog:

Delete Property from Column header context menu

11.  Image can be stored in encoded Base64 String token. Open context menu on cell and select Image..., click on "upload" area, select image file, click on any other cell in order to close Image Editor. Click Save:

Set Image as encoded Base64 string