Editing JSON in spreadsheet
Description
You may edit your JSON in spreadsheet view by using Inline Editing, Context Menu or Key Shortcuts.
Steps
- Inline Editing - Double-click a cell or press the Enter or F2 key on an active cell
- ContextMenu - Right mouse button click on an active cell
- Key shortcuts - Press one key or two-key combination on your keyboard
Key shortcuts
- F2 - edit text in active cell
- Delete - reset token to default ("" for String, 0 for Number, false for Boolean)
- Shift+Delete - reset token to NULL
- Ctrl+Delete - delete property from Object or all Objects (by JSON Path pattern)
- Ctrl+C - copy to clipboard
- Ctrl+V - paste from clipboard
- Ctrl+X - cut and save in to the clipboard
- Ctrl+Z - Undo last action
- Ctrl+Y - Redoes an undone action
- Tab (Shift+Tab) - navigate to next (previous) cell in row
- Ctrl+A - select all cells
Context Menu Actions on each JSON token level
| Context Menu Action | [header] | [array element] | [property value] | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Array & ArrayItem Index** | Empty Array | Empty Object | Value* | Property | ArrayItem Index** | Value* | Empty Array | Empty Object | Property | Empty Array | Empty Object | |
| Preview Path Pattern... | ✓ | ✓ | ✓ | ✓ | ✓ | |||||||
| Insert Array Item (for each child Array) | ✓ | |||||||||||
| Insert Array Item | ✓ | |||||||||||
| Insert Array Item - After | ✓ | ✓ | ||||||||||
| Insert Array Item (in Empty Array) | ✓ | ✓ | ✓ | |||||||||
| Delete Array Item(s) | ✓ | ✓ | ✓ | |||||||||
| Insert Additional Property ... | ✓ | ✓ | ✓ | ✓ | ✓ | |||||||
| Edit Property Name... | ✓ | ✓ | ||||||||||
| Delete Property | ✓ | ✓ | ||||||||||
| Null | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
| String | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||||
| Number (Integer) | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||||
| Number (Float) | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||||
| Boolean | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||||
| Empty Object | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||||
| Empty Array | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ||||||
| Raw... | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
| Image... | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||
| File... | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |||||