# View data

When you double-click a table in the   Database   tool window  ( `View  | Tool Windows |  Database` ), the table, view, or virtual view opens in the data editor tab.

## Data view modes

You can browse and edit data in three modes: Table,  Tree, Text, and Transpose. To switch between these modes, click ![the View as button](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.show.svg) View as on the toolbar and select the mode that you need.

* Transpose: viewing mode in which rows and columns are [interchanged](#transposing_table). You can combine this checkbox with other viewing modes. To make this mode a default for tables and views, open settings by pressing `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) and navigate to `Tools | Database | Data Editor and Viewer`. From the Automatically transpose tables list, select Always. When this option is enabled, query results are not transposed. ![The transposed table viewing mode](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_viewing_modes_transposed_table.png)

* Table: the default viewing mode of table data. Data in a table is stored in a cell that is an intersection of a vertical column and horizontal row. ![The table viewing mode](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_viewing_modes_table.png)

* Tree: viewing mode in which data is displayed in the key-value table with the possibility to expand the key cell if it contains children nodes. Data from the expanded children node is distributed between key and value columns. You might consider using this mode to work with JSON and array data. ![The tree viewing mode](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_viewing_modes_tree.png)

* Text: viewing mode in which data is displayed as a text. This mode uses data extractors to represent the data. For example, if the CSV data extractor is selected in the Data extractors list on the toolbar, the database object data is displayed in the CSV format. For more information about data extractors, refer to the [Data extractors](data-extractors.html) topic. ![The transposed table viewing mode](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_viewing_modes_text.png)

Procedure: Transpose a table, a view, or a virtual view

You can rotate the table data from rows to columns and from columns to rows. In the transposed view, the rows and columns are interchanged. You can combine the transpose action with other viewing modes.

* To transpose a table, a view, or a virtual view,  click ![the View as button](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.show.svg) View as and select Transpose.

![The transposed table viewing mode](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_viewing_modes_transposed_table.png)

Procedure: Reload data for the table view

You need to reload data for the table view if you want to synchronize the data that you see in the editor with the contents of the database. Or, when you want to apply the [page size limit](rows.html#making_all_rows_visible_proc) setting after its change.

* Click ![The Reload Page icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.refresh.svg) Reload Page on the toolbar.

* Right-click the table and select Reload Page from the context menu.

* Press `Ctrl+F5` (Windows), `⌘ R` (macOS), `⌃ F5` (IntelliJ IDEA Classic (macOS)), `⌘ R` (macOS System Shortcuts), `Ctrl+F5` (XWin), `Ctrl+F5` (GNOME), `Ctrl+5` (KDE), `Ctrl+F5` (Emacs), `Ctrl+F5` (Sublime Text), `⌘ R` (Sublime Text (macOS)), `Ctrl+F5` (NetBeans), `Ctrl+Alt+R` (Visual Studio), `⌘ ⌥ R` (Visual Studio (macOS)), `Ctrl+F5` (Eclipse), `Ctrl+F5` (Eclipse (macOS)).

Procedure: View the query that generated the result set

* To see the query that was used to generate the result table, click ![the Show Options Menu icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.settings.svg) Show Options Menu and select View Query. If necessary, you can select the query text and copy it to the clipboard by pressing `Ctrl+C` (Windows), `⌘ C` (macOS), `⌘ C` (IntelliJ IDEA Classic (macOS)), `⌘ C` (macOS System Shortcuts), `Ctrl+C` (XWin), `Ctrl+C` (GNOME), `Ctrl+C` (KDE), `Ctrl+Insert` (Emacs), `Ctrl+C` (Sublime Text), `⌘ C` (Sublime Text (macOS)), `Ctrl+C` (NetBeans), `Ctrl+C` (Visual Studio), `⌘ C` (Visual Studio (macOS)), `Ctrl+C` (Eclipse), `⌘ C` (Eclipse (macOS)).

To close the pane where the query is shown, press `Escape` (Windows), `⎋` (macOS), `⎋` (IntelliJ IDEA Classic (macOS)), `⎋` (macOS System Shortcuts), `Escape` (XWin), `Escape` (GNOME), `Escape` (KDE), `Escape, Escape` (Emacs), `Escape` (Sublime Text), `⎋` (Sublime Text (macOS)), `Escape` (NetBeans), `Escape` (Visual Studio), `⎋` (Visual Studio (macOS)), `Escape` (Eclipse), `⎋` (Eclipse (macOS)).

![View the query that generated the table](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_view_query_that_generated_table.png)

Procedure: Preview DML

* When you insert, delete, or modify data in a table editor, you can preview the query that IntelliJ IDEA uses to perform selected operations. To preview the query, click ![the Preview pending changes button](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.previewChanges.svg) Preview Pending Changes on the toolbar.

Procedure: Apply a heatmap

* On the grid toolbar, click ![](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.grid.core.impl.icons.expui.tableHeatmap.svg) Table Coloring Options and select the color schemes:

1.

Sequential: consists of a single color or a range of closely related colors that vary in intensity.

![Grid heatmap with the sequential color scheme](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_data_heatmap_sequential.png)

2.

Diverging: emphasizes variation relative to a norm. It consists of two contrasting colors that deviate from a central value in two opposite directions.

![Grid heatmap with the sequential color scheme](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_data_heatmap_diverging.png)

You can apply the heatmap color schemes to the whole table or to each column separately, or you can use coloring only for Boolean values.

## Explore values

Use editors and views to view, edit, and analyze values of table cells.

### Value editor

Value editor is a separate editor where you can edit data that is stored in the cell. To open Value editor, in the cell context menu select Open in Value Editor.

![Open in Value Editor context menu option](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_show_value_editor.png)

Procedure:

To edit the value in the value editor, do the following:

* To start a new line, press `Enter` (Windows), `⏎` (macOS), `⏎` (IntelliJ IDEA Classic (macOS)), `⏎` (macOS System Shortcuts), `Enter` (XWin), `Enter` (GNOME), `Enter` (KDE), `Enter` (Emacs), `Enter` (Sublime Text), `⏎` (Sublime Text (macOS)), `Enter` (NetBeans), `Enter` (Visual Studio), `⏎` (Visual Studio (macOS)), `Enter` (Eclipse), `⏎` (Eclipse (macOS)).

* To enter the value, press `Ctrl+Enter` (Windows), `⌘ ⏎` (macOS), `⌘ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ ⏎` (macOS System Shortcuts), `Ctrl+Enter` (XWin), `Ctrl+Enter` (GNOME), `Ctrl+Enter` (KDE), `Ctrl+Enter` (Emacs), `Ctrl+Enter` (Sublime Text), `⌘ ⏎` (Sublime Text (macOS)), `Ctrl+Enter` (NetBeans), `Ctrl+Enter` (Visual Studio), `⌘ ⏎` (Visual Studio (macOS)), `Ctrl+Enter` (Eclipse), `⌘ ⏎` (Eclipse (macOS)).

* To restore an initial value and quit the editing mode, press `Escape` (Windows), `⎋` (macOS), `⎋` (IntelliJ IDEA Classic (macOS)), `⎋` (macOS System Shortcuts), `Escape` (XWin), `Escape` (GNOME), `Escape` (KDE), `Escape, Escape` (Emacs), `Escape` (Sublime Text), `⎋` (Sublime Text (macOS)), `Escape` (NetBeans), `Escape` (Visual Studio), `⎋` (Visual Studio (macOS)), `Escape` (Eclipse), `⎋` (Eclipse (macOS)).

* To enable soft wrap in the editor, click ![the Toggle Soft-Wrap button](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.actions.toggleSoftWrap.svg) Toggle Soft-Wrap.

If you store one-line JSON in a cell, you can enable formatting by clicking Toggle Formatting. This action formats one-line XML and JSON strings.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_value_editor_format_json.mp4)

If your table stores arrays in an `array` column, you can view and edit the arrays in a dedicated grid in Value editor. To open an array in the editor, double-click the cell that contains it. In the editor, you can edit elements, add and delete them, and also revert your changes. Each change is highlighted the same way as it is in the main grid.

![Highlighted changes made to an array in the Value editor](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_value_editor_arrays_editor.png)

To hide the elements that you deleted, click the Value editor settings button in the top right corner and select Hide Deleted Elements.

![Deleted elements are hidden](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_value_editor_arrays_hide_deleted.png)

Value editor stores the changes you make to the array until you do one of the following:

* Revert the array changes by selecting them and clicking ![the Revert Changes icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.reset.svg) Revert Changes.

* Revert all the main grid changes by selecting them and clicking ![the Revert Selected icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.reset.svg) Revert Selected on the main grid toolbar.

* Close the main grid.

To submit the changes to your database, click ![The Submit icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/database-plugin.icons.submitDB.svg) Submit  on the toolbar of the main grid, or press `Ctrl+Enter` (Windows), `⌘ ⏎` (macOS), `⌘ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ ⏎` (macOS System Shortcuts), `Ctrl+Enter` (XWin), `Ctrl+Enter` (GNOME), `Ctrl+Enter` (KDE), `Ctrl+Enter` (Emacs), `Ctrl+Enter` (Sublime Text), `⌘ ⏎` (Sublime Text (macOS)), `Ctrl+Enter` (NetBeans), `Ctrl+Enter` (Visual Studio), `⌘ ⏎` (Visual Studio (macOS)), `Ctrl+Enter` (Eclipse), `⌘ ⏎` (Eclipse (macOS)). The changes will be submitted along with all the changes you made to the main grid.

### Preview images

You can preview images in the value editor. To do that, right-click the cell that contains an image and select View Image in the context menu.

Note that to leverage the performance issues, the default LOB size is limited to 1024 bytes. It means that only 1024 bytes are loaded to the table editor. To increase this size and view larger images, open settings by pressing `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)), navigate to  `Tools | Database | Data Editor and Viewer`, and change the value of the  Maximum number of bytes loaded per value  option.

![Preview images in the value editor](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_preview_images_in_the_value_editor.png)

### Aggregate view

In IntelliJ IDEA, you can use data aggregator and data extractor scripts to get aggregated and extracted values.

In the Aggregate view, you can select values of multiple cells and get a single summary value. To open the Aggregate view, in the cell context menu select Show Aggregate View. The view displays the values calculated by aggregators.

![Open in Value Editor context menu option](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_show_aggregate_view.png)

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_aggregate_view_result.mp4)

Click the gear icon (![the Settings icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.settings.svg)) on the toolbar of the Aggregates tab to view, enable, and disable aggregates. To access the bundled aggregator, select Go to Scripts Directory. The scripts are located in `Scratches and Consoles | Extensions | Database Tools and SQL | data | aggregators`. The directory will open in the  Project tool window .

> **Tip:**
> Aggregate scripts and extractors are interchangeable. If you have previously used an extractor that gets only one value, you can copy it to the `aggregates` directory and use it for aggregates.

Also, you can create your own aggregate scripts. To add your own aggregator, place your script to the `aggregators` directory.

![Aggregate scripts and extractors](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_aggregate_scripts_and_extractors.png)

### Single record view

You can view and edit the values of a certain record using a single record view in a side panel of the data editor.

![Single record view in the data editor](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_single_record_view.png)

Procedure:

To open the single record view, select a cell or a record and do one of the following:

* Press `Ctrl+Shift+Enter` (Windows), `⌘ ⇧ ⏎` (macOS), `⌘ ⇧ ⏎` (IntelliJ IDEA Classic (macOS)), `⌘ ⇧ ⏎` (macOS System Shortcuts), `Ctrl+Shift+Enter` (XWin), `Ctrl+Shift+Enter` (GNOME), `Ctrl+Shift+Enter` (KDE), `Ctrl+Shift+Enter` (Emacs), `Ctrl+Shift+Enter` (Sublime Text), `Ctrl+Shift+Enter` (Sublime Text (macOS)), `Ctrl+Shift+Enter` (NetBeans), `Ctrl+Shift+Enter` (Visual Studio), `⌘ ⇧ ⏎` (Visual Studio (macOS)), `Ctrl+Shift+Enter` (Eclipse), `⌘ ⇧ ⏎` (Eclipse (macOS)).

* Click ![](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.grid.core.impl.icons.expui.singleRecordView.svg) Record View on the toolbar.

* Right-click and select ![](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.grid.core.impl.icons.expui.singleRecordView.svg) Show Record View.

For the single record view, there are two layouts: single-column layout and two-column layout. You can switch the layouts by clicking ![Single record view settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.general.gear.svg) Settings in the upper-right corner of the panel and selecting the other layout.

| Single-column layout | Two-column layout |
|    ![Single-column record view layout in the data editor](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_single_record_view_single_column_layout.png)  |    ![Two-column record view layout in the data editor](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_single_record_view_two_column_layout.png)  |

## Visualize data

You can use charts to visualize the database objects data and plot your query result sets in data editor. The available chart types are as follows: bar, pie, area, line, scatter, bubble, stock, area range, and histogram. You can also group your data.

Depending on what you are working with, the plot is displayed in split mode or instead of the table:

* Database objects data and DSV files: split mode.

* In-editor results and query result set in Services tool window: instead of the table.

Procedure: Plot a chart

* To visualize your data  , click ![the Show Chart icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.chart.chart.svg) Show Chart on the data editor toolbar.

Default chart type is selected automatically depending on the data types. To view the exact value, hover over it on the chart.

![Visualize data as a chart](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_visualize_data_as_a_chart.png)

Procedure: Configure a chart

You can view your data in either one of the supported chart types. Use the axes settings to plot the data you need with the available columns.

1. On the chart toolbar, click ![Show Series Settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.settings.svg) Show Series Settings.

2. In the chart type selector, click the icon of the type that you want to plot.

3. For each axis, configure its settings:

* Click Add Column and select the column that you want to plot.

* Click ![the Modifier icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.expandHover.svg) Modifier to modify the data display.

![Configure a chart](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_configure_a_chart.png)

Procedure: Plot multiple series

1. On the chart toolbar, click ![Show series settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.settings.svg) Show Series Settings.

2. To plot one more series with the data from the same table, click Add new series and configure the new series.

3. To delete a series, click ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.delete.svg) Remove in the upper-right corner of the series settings pane.

![Plot multiple series](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_plot_multiple_series.png)

Procedure: Export charts

1. Click ![Export to PNG](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.download.svg) Export to PNG on the chart toolbar to save the generated chart in the `.png` format.

2. Enter the filename and click Save.

### Reference

| Item | Description |
| --- | --- |
|  ![Export to PNG](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.download.svg) Export to PNG  | Export chart in the `.png` format. |
|  ![Show series settings](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.settings.svg) Show Series Settings  | Opens the series settings pane with chart type selector and axes settings. |

| Item | Description |
| --- | --- |
| Chart types |
| ![the Bar icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.chart.chartBar.svg) | Bar |
| ![the Pie icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.chart.chartPie.svg) | Pie |
| ![the Area icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.chart.chartArea.svg) | Area |
| ![the Line icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.chart.chartLine.svg) | Line |
| ![the Scatter icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.chart.chartScatter.svg) | Scatter |
| ![the Bubble icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.chart.chartBubble.svg) | Bubble |
| ![the Stock icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.chart.chartStock.svg) | Stock |
| ![the AreaRange icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.chart.chartAreaRange.svg) | AreaRange |
| ![the Histogram icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/intellij.charts.icons.chart.chartBar.svg) | Histogram |
| Controls |
|  ![the Remove icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.delete.svg) Remove  | (For multiple series plots.) Removes a series from the plot. |
| X axis |    Determines a column plotted on the X axis.     Axis Modifier defines how the data is displayed:       * none: not applied.    * group: data is grouped by X axis values.    * group and sort: data is grouped and sorted by X axis values.    |
| Groups | Determines how the X axis values are grouped. |
| Y axis |    Determines a column plotted on the Y axis.     Axis Modifier defines which Y axis values are displayed.    |

## View geographical data

Geographical data Viewer, or Geo viewer, is a graphic viewer that you can use to explore geospatial data.

Currently, Geo viewer works with data from your PostgreSQL database tables and tabular data files (CSV, XLSX, and other [supported file formats](data-extractors.html#available_scripts)). IntelliJ IDEA supports coordinates in the following formats: WKT, WKB, and PostGIS geometry 4326.

After opening the Geo viewer, you can click table rows to navigate to the corresponding area on the map or click a pin on the map to navigate to the corresponding row.

> **Warning:**
> The Geo viewer works only if [JCEF](https://github.com/chromiumembedded/java-cef) is enabled. In rare cases, when you enable JCEF, IntelliJ IDEA might crash. It can happen if you have installed plugins that use JavaFX. If the crash happened, refer to [Recover IntelliJ IDEA after enabling JCEF](#recover-datagrip-after-enabling-jcef).

| PostgreSQL database table | Tabular data file |
| --- | --- |
| ![Geographical data from PostgreSQL table in Geo viewer](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_geo_viewer_database.png) | ![Geographical data from a tabular data file in Geo viewer](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_geo_viewer_file.png) |

Procedure: View geo data from PostgreSQL table

> **Note:**
> To work with geographical data in PostgreSQL, you must install the Postgis extension on your PostgreSQL server. For more information about the installation process, refer to [the Postgis documentation](https://postgis.net/).

1. In the   Database   tool window ,   double-click the table  with geographical data.

2. Click ![Show Options Menu icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.settings.svg) Show Options Menu on the toolbar of the data editor tab that opens and select Show Geo Viewer.

3. Read the notification about possible risks of enabling JCEF. If you accept the risk, click Enable JCEF.

4. In the Restart Required window, click Restart Now.

5. After the restart, press `Ctrl+F5` (Windows), `⌘ R` (macOS), `⌃ F5` (IntelliJ IDEA Classic (macOS)), `⌘ R` (macOS System Shortcuts), `Ctrl+F5` (XWin), `Ctrl+F5` (GNOME), `Ctrl+5` (KDE), `Ctrl+F5` (Emacs), `Ctrl+F5` (Sublime Text), `⌘ R` (Sublime Text (macOS)), `Ctrl+F5` (NetBeans), `Ctrl+Alt+R` (Visual Studio), `⌘ ⌥ R` (Visual Studio (macOS)), `Ctrl+F5` (Eclipse), `Ctrl+F5` (Eclipse (macOS)) or reopen the table with geographical data.

6. Click ![Show Options Menu icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.settings.svg) Show Options Menu on the toolbar of the data editor tab and select Show Geo Viewer.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_open_geo_viewer_database.mp4)

To detach the Geo viewer tab from Services tool window, drag it from the tool window. To restore the layout, click ![the Layout Settings icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app-client.expui.general.layout.svg) Layout Settings in the upper-right corner of the viewer window and select Restore Default Layout.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_open_geo_viewer_database_drag.mp4)

Procedure: View geo data from tabular data file

1. In the  Project tool window ,  double-click the  file with geographical data.

2. At the bottom of the editor tab that opens, click Data to view the file contents as table data.

3. Click ![Show Options Menu icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.settings.svg) Show Options Menu on the toolbar of the  editor tab and select Show Geo Viewer.

[Video](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_open_geo_viewer_file.mp4)

Procedure: Recover IntelliJ IDEA after enabling JCEF

1. Navigate to the `config` directory.

Windows:

Syntax
: `%HOMEPATH%\.<product><version>\config\projects`

Example
: `C:\Users\JohnS\.IntelliJIdea2026.2\config\projects`

macOS:

Syntax
: `~/Library/Application Support/<product><version>`

Example
: `~/Library/Application Support/IntelliJIdea2026.2`

Linux:

Syntax
: `~/.<product><version>/config/plugins`

Example
: `~/.IntelliJIdea2026.2/config/plugins`

2. In the `options` directory, open `ide.general.xml` in a text editor.

3. Remove the following line: `<entry key="ide.browser.jcef.enabled" value="true" />`

