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...