Editing JSON in spreadsheet

Description

You may edit your JSON in spreadsheet view by using Inline Editing, Context Menu or Key Shortcuts.

Steps




Key shortcuts

  1. F2 - edit text in active cell
  2. Delete - reset token to default ("" for String, 0 for Number, false for Boolean)
  3. Shift+Delete - reset token to NULL
  4. Ctrl+Delete - delete property from Object or all Objects (by JSON Path pattern)
  5. Ctrl+C - copy to clipboard
  6. Ctrl+V - paste from clipboard
  7. Ctrl+X - cut and save in to the clipboard
  8. Ctrl+Z - Undo last action
  9. Ctrl+Y - Redoes an undone action
  10. Tab (Shift+Tab) - navigate to next (previous) cell in row
  11. Ctrl+A - select all cells


Context Menu Actions on each JSON token level
Value* - string, boolean, integer, float or null
Array Item Index** - # header or 0..n cell under # header
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... ✓ ✓ ✓ ✓ ✓ ✓ ✓