Table, Tree and JSON View for Firestore Data
Table, Tree and JSON View for Firestore Data
Some data is best viewed as a Table, other data in a Tree, and sometimes you just want the raw JSON.
View and edit your data in a table grid, just like in Excel or Airtable. Navigate using the arrow keys, Copy and Paste cell values with CTRL/CMD+C and CTRL/CMD+V, double-click or hit the Enter key to edit. When editing long strings or array and map data, a popup with JSON syntax-highlighting opens. Other fields can be edited inline. To edit the whole document as JSON, double-click the document ID.
In the column panel, reachable through the right-most icon button in the toolbar, you can organize the table columns. Unselect a column to hide it. Reorder columns using drag-and-drop. When there are more than 8 columns, Firefoo shows a search filter field above the column list.
When the documents of your collection have a map field with the same properties, you can split that column into multiple columns, one for every nested field. To undo a split, click the Unsplit All button on the top right of the Columns panel.
To rename or delete a field in all documents, right-click the table header of that field and find the corresponding options in the context menu.
The tree view allows for a hierarchical representation of your data, useful if your data is nested or contains a lot of fields. Collections, documents, subcollections, maps and arrays in your database make one branch in the tree. The toolbar has buttons to quickly expand or collapse all tree items.
View your data as raw JSON! Note that this JSON output is read-only. To edit, right-click the document ID in the Table or Tree View and select Edit Document as JSON.
For a reference on how non-primitive data types like Firestore Timestamps and GeoPoints are represented, view the doc article about Export JSON from Firebase Firestore.
Use the toolbar icon to view all Geopoints of the current query.
Click the Export Results toolbar icon to export currently visible documents as JSON or CSV. To export an entire collection, right-click the collection in the sidebar instead and choose the Export Collection option.