Hey Coda!
Just built a system that lets you flatten ANY JSON into a hierarchical EAV table and then convert it back to JSON after editing - all within Coda! Check out the demo video
Why I built this
Working with complex JSON in Coda has always been challenging. If youāre working with:
- API responses
- LLM outputs/inputs (my primary use case)
- Configuration files
- Complex data structures
You know the pain of navigating nested JSON structures. You either have to flatten everything into CSV-like tables (losing the hierarchy) or work with JSON as raw text.
How it works
- Import: Paste any JSON into the input area and click āFlatten to EAVā
- Explore: The JSON gets transformed into a EAV table where:
- Each key becomes a node/row
- Parent-child relationships are preserved
- Values are stored and editable
- All relationships (ancestors, descendants, siblings) are tracked
- Navigate: Use the Miller Columns view (like Mac Finderās column view) to click through the hierarchy
- Edit: Update any values directly in the table
- Export: Click āReconstruct JSONā to convert your EAV back to properly formatted JSON
Hereās what makes this special:
- Full hierarchy preservation - even deeply nested structures
- Edit any value and see changes reflected in the final JSON
- Visualize complex structures with Miller columns
- No depth limits to the hierarchy
Technical Notes
- The system converts arrays to objects with
[n]
notation as parents. This keeps the original order while making everything consistently navigable. - Since itās built on Coda tables, there are no practical size limitations beyond Codaās standard constraints.
Get the doc
You can duplicate this document and start using it right away:
Use cases
Iām currently using this to:
- Debug complex API responses
- Create structured prompts for LLMs
- Store and edit hierarchical data that needs to be accessed by both humans and AI
Would love to hear how YOU might use this!
Happy coding!
Jon