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.

Table View

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

Table Columns

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.

Document Batch Operations

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.

Tree View

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

JSON View

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

View GeoPoints on Map

Use the toolbar icon to view all Geopoints of the current query.

Export Results

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.