Settings Reference
Auto-Fit Column Width
Default: True (enabled)
Scope: Table
Command: Toggle Auto-Fit Column Width
When enabled, this setting will ensure that each column is only as wide as the widest cell and no wider. However, it is limited by the Maximum Column Width for Auto-Fit setting. If that setting is 800 (which is the default value), then no column can be wider than 800 pixels. Without that limitation, a single rogue cell with 5,000 characters could cause the entire column to take up several screens worth of width and necessitate excessive scrolling.
For performance reasons, this setting is not recommended for files with many columns (i.e. more than a few thousand).
Auto-Fit Row Height
Default: False (disabled)
Scope: Table
Command: Toggle Auto-Fit Row Height
When enabled, this setting will ensure that each row is only as tall as the tallest cell and no taller. However, it is limited by the Maximum Row Height for Auto-Fit setting. If that setting is 240 (which is the default value), then no row can be taller than 240 pixels. Without that limitation, a single rogue cell with dozens of newlines could cause the entire row to take up several screens worth of height and necessitate excessive scrolling.
For performance reasons, this setting is not recommended for files with many rows (i.e. more than a few thousand).
Auto-Save Recovery Snapshot
Default: True (enabled)
Scope: Global
Command: Toggle Auto-Save Recovery Snapshot
When enabled, Modern CSV automatically saves recovery snapshots of unsaved edits in Edit Mode and Stream Edit Mode.
Auto-Suggest When Editing
Default: False (disabled)
Scope: Global
Command: Toggle Auto-Suggest When Editing
When enabled, Modern CSV shows auto-suggestions while editing cells.
Behavior When File Is Changed Externally
Default: refresh
Scope: Global
Command: Set Behavior When File Is Changed Externally
If you have a file open in Modern CSV and another program or process saves it, this setting determines how the program reacts to that save. refresh: It'll simply reload the file to show the changes. ask: It'll ask you whether you want it to reload the file or ignore the changes. ignore: It'll ignore the changes.

BOM Policy for Existing Unicode Files
Default: Preserve BOM state
Scope: Global
Command: Set BOM Policy for Existing Unicode Files
Controls whether existing Unicode files preserve, always write, or never write the BOM when saved.
BOM Policy for New UTF-16 and UTF-32 Files
Default: Write BOM
Scope: Global
Command: Set BOM Policy for New UTF-16 and UTF-32 Files
Controls whether new UTF-16 and UTF-32 files are saved with a BOM.
BOM Policy for New UTF-8 Files
Default: Do not write BOM
Scope: Global
Command: Set BOM Policy for New UTF-8 Files
Controls whether new UTF-8 files are saved with a BOM.
Case Sensitive Sorting
Default: True (enabled)
Scope: Global
Command: Toggle Case Sensitive Sorting
Controls whether sorting treats uppercase and lowercase letters as different.
Console Panel Placement
Default: Docked
Scope: Global
Command: Set Console Panel Placement
Controls whether the Console panel is docked or separate.
Data Analysis Panel Placement
Default: Docked
Scope: Global
Command: Set Data Analysis Panel Placement
Controls whether the Data Analysis panel is docked or separate.
Date Ordering
Default: Month Day Year
Scope: Table
Command: Set Date Ordering
Used when interpreting ambiguous dates like 03/04/2026.
On a new install, Modern CSV sets this from your system locale when possible.
Default Column Width
Default: 80
Scope: Global
Command: Set Default Column Width
This is the width of empty columns in pixels. If Auto-Fit Column Width is enabled, a column's width will change to accommodate the new data. If disabled, the columns will stay at this width regardless of any editing until you manually change the width. You can change the width by manually dragging the column label to a new width or by using the Set Selected Column Width(s) command.
Default Dark Theme
Default: Dark
Scope: Global
Command: Set Default Dark Theme
Sets the theme used when Theme is System and the operating system is in dark mode.
Default Light Theme
Default: Light
Scope: Global
Command: Set Default Light Theme
Sets the theme used when Theme is System and the operating system is in light mode.
Default Row Height
Default: 24
Scope: Global
Command: Set Default Row Height
This is the height of empty rows in pixels. If Auto-Fit Row Height is enabled, a row's height will change to accommodate the new data. If disabled, the rows will stay at this height regardless of any editing until you manually change the height. You can change the height by manually dragging the row label to a new height or by using the Set Selected Row Height(s) command.
Detect Imported File Type Upon Opening File
Default: True (enabled)
Scope: Global
Command: Toggle Detect Imported File Type Upon Opening File
When enabled, Modern CSV tries to detect imported file types when opening files.
Enable Check for Updates
Default: True (enabled)
Scope: Global
Command: Toggle Enable Check for Updates
When enabled, the program will check on startup to see if there's a new version available for download. If not, it won't do anything. If so, it will inform you of the new version, provide a link to the download page, and give you the option to not be informed of the new version again. There's also a Check for Updates command in the Help menu.
When disabled, it will not check for updates on startup and the Check for Updates command will not be shown in the menu. This is useful for some enterprise customers that don't want their employees to worry about product updates or individuals who simply don't want to be bothered.
External Text Editor
Default: Notepad on Windows, TextEdit on macOS, Gedit on Linux
Scope: Global
Command: Set External Text Editor
Sets the program used by commands that open files in an external text editor.
Fade Outside of Data Region
Default: False (disabled)
Scope: Global
Command: Toggle Fade Outside of Data Region
When enabled, cells outside the data region are faded.
File Handling Mode
Default: Edit Mode
Scope: Table
Command: Set File Handling Mode
Controls whether the file opens in Edit Mode, Stream Edit Mode, or Read-Only Mode.
Stream Edit Mode uses less memory for large files while still allowing edits. Read-Only Mode uses the least memory and prevents edits.
First Column Index
Default: 0
Scope: Table
Command: Set First Column Index
This determines where the column labels start counting.

First Row Index
Default: 0
Scope: Table
Command: Set First Row Index
This determines where the row labels start counting. Because most CSV files have a single row for the header, when this setting is 0 (the default), the first record of data starts at row 1. If you're on row 25, you know that's the 25th row of data.
Some CSV files have several rows of meta-data before the records start. You can set this to a negative value so the first record starts at 1.

Freeze Header Columns
Default: True (enabled)
Scope: Table
Command: Toggle Freeze Header Columns
If you have records with a lot of columns and you want the first few to always be visible, you can freeze them with this setting.
The Number of Header Columns
setting must be greater than 0 to freeze any header columns. That setting is 0 by default, so you must change it either by calling the Set Number of Header Columns or Set Header Columns to Selected Column commands or right-clicking on a column and selecting the Set Header Columns to Selected Column option.

Freeze Header Rows
Default: True (enabled)
Scope: Table
Command: Toggle Freeze Header Rows
If you want the header row (or rows) to always be visible when you scroll down a file, this setting allows that to happen.
The Number of Header Rows
setting must be greater than 0 to freeze any header rows (by default it's 1).

Highlight Header Columns
Default: True (enabled)
Scope: Table
Command: Toggle Highlight Header Columns
When enabled, frozen columns have their text bolded and their backgrounds' colors are changed to make it visually obvious they are the header columns.
Highlight Header Rows
Default: True (enabled)
Scope: Table
Command: Toggle Highlight Header Rows
When enabled, frozen rows have their text bolded and their backgrounds' colors are changed to make it visually obvious they are the header rows.
Highlight Main Selected Cell's Column
Default: False (disabled)
Scope: Global
Command: Toggle Highlight Main Selected Cell's Column
Highlights the main selected cell's column. Can be used with Highlight Main Selected Cell's Row.
Highlight Main Selected Cell's Row
Default: False (disabled)
Scope: Global
Command: Toggle Highlight Main Selected Cell's Row
Highlights the main selected cell's row. Enable Highlight Main Selected Cell's Column as well to highlight both.

Ignore Table Transpose When Saving
Default: False (disabled)
Scope: Global
Command: Toggle Ignore Table Transpose When Saving
When enabled, Modern CSV saves the file in its original orientation even when the table is transposed.
Language
Default: English
Scope: Global
Command: Set Language
Sets the application language.
On a new install, Modern CSV starts with the system language when supported.
Let Cell Editor Panel Consume Navigation Keystrokes
Default: True (enabled)
Scope: Global
Command: Toggle Let Cell Editor Panel Consume Navigation Keystrokes
The Cell Editor panel is useful for long fields or fields with newline characters. This setting allows you to edit a cell in the Cell Editor panel without having to worry about exiting the cell when pressing Enter or Tab. There are several ways to stop editing:
- Hit
Esc. - Hit
Ctrl+E(or whatever the shortcut forStop Editingis). - Hit
Alt+[I|K|J|L](or whatever the shortcut forMove Selection [Up|Down|Left|Right]is). - Click on another cell.
- Hit
Esc. - Hit
Cmd+E(or whatever the shortcut forStop Editingis). - Hit
Alt+[I|K|J|L](or whatever the shortcut forMove Selection [Up|Down|Left|Right]is). - Click on another cell.
When disabled, it behaves the same as when the Cell Editor panel is hidden: Tab and Enter both stop editing while Tab moves the selected cell to the next column and Enter moves it to the next row.

Maximum Column Width for Auto-Fit
Default: 800
Scope: Table
Command: Set Maximum Column Width for Auto-Fit
When the Auto-Fit Column Width
setting is enabled, this setting limits how wide it can make a column. If a single cell in a column has thousands of characters, this setting prevents that column from being excessively wide.
The units are pixels.
Maximum Row Height for Auto-Fit
Default: 240
Scope: Table
Command: Set Maximum Row Height for Auto-Fit
When the Auto-Fit Row Height
setting is enabled, this setting limits how tall it can make a row. If a single cell in a row has a lot of newlines, this setting prevents that row from being excessively tall.
The units are pixels.
Minimum Column Width for Auto-Fit
Default: 24
Scope: Table
Command: Set Minimum Column Width for Auto-Fit
Sets the minimum column width in pixels when Auto-Fit Column Width is enabled.
Minimum Number of Table Columns
Default: 50
Scope: Global
Command: Set Minimum Number of Table Columns
This is the minimum number of columns that will display, even if there is no data.

Minimum Number of Table Rows
Default: 50
Scope: Global
Command: Set Minimum Number of Table Rows
This is the minimum number of rows that will display, even if there is no data.

Minimum Row Height for Auto-Fit
Default: 24
Scope: Table
Command: Set Minimum Row Height for Auto-Fit
Sets the minimum row height in pixels when Auto-Fit Row Height is enabled.
Number Format
Default: Dot Decimal
Scope: Table
Command: Set Number Format
Controls decimal and thousands separators for number parsing and analysis.
On a new install, Modern CSV sets this from your system locale.
Number of Buffer Columns
Default: 2
Scope: Global
Command: Set Number of Buffer Columns
This is the number of columns beyond the data that will display. This doesn't apply if the number of data columns + Number of Buffer Columns is less than Minimum Number of Table Columns.

Number of Buffer Rows
Default: 2
Scope: Global
Command: Set Number of Buffer Rows
This is the number of rows beyond the data that will display. This doesn't apply if the number of data rows + Number of Buffer Rows is less than Minimum Number of Table Rows.

Number of Header Columns
Default: 0
Scope: Table
Command: Set Number of Header Columns
This is the number of header columns. Header columns can be bolded to make them visually obvious using the Highlight Header Columns setting. They can be frozen so they always appear wherever you scroll using the Freeze Header Columns setting. They are also excluded from sort and filter operations. That way, if you sort a row, you don't have to worry about the header columns being sorted too. If you filter a row, you don't have to worry about the header columns disappearing.

Number of Header Rows
Default: 1
Scope: Table
Command: Set Number of Header Rows
This is the number of header rows. Header rows can be bolded to make them visually obvious using the Highlight Header Rows setting. They can be frozen so they always appear wherever you scroll using the Freeze Header Rows setting. They are also excluded from sort and filter operations. That way, if you sort a column, you don't have to worry about the header rows being sorted too. If you filter a column, you don't have to worry about the header rows disappearing.

Online Map
Default: duckduckgo.com
Scope: Global
Command: Set Online Map
Sets the map site used by map lookup commands.
Preserve Editor State Between Sessions
Default: False (disabled)
Scope: Global
Command: Toggle Preserve Editor State Between Sessions
When enabled, Modern CSV reopens saved files and restores pane layouts, active tabs, and scroll positions when you restart it.
Remove Extraneous Rows/Columns on File Save
Default: False (disabled)
Scope: Global
Command: Toggle Remove Extraneous Rows/Columns on File Save
When enabled, Modern CSV removes extraneous rows and columns when saving a file.
Represent Columns as Letters
Default: False (disabled)
Scope: Global
Command: Toggle Represent Columns as Letters
When enabled, the column labels at the top of the table will display as letters (A, B, ..., Z, AA, AB, AC, etc.) instead of numbers. The first column will always be A and the First Column Index setting will be ignored.

Retain Sort and Filters Upon File Refresh
Default: True (enabled)
Scope: Global
Command: Toggle Retain Sort and Filters Upon File Refresh
When a file is open in Modern CSV and another program or process saves it, it's possible to "refresh" the file in Modern CSV so the changes show immediately (see Behavior When File Is Changed Externally). If you had a column or row filtered or sorted before the refresh, this setting will cause it to apply the same sort or filter after the refresh. This could be useful if you're viewing a log file that is occasionally being refreshed.
Save After Each Edit
Default: False (disabled)
Scope: Global
Command: Toggle Save After Each Edit
There are some programs that use CSV or other tabular files as configuration files. For such programs, it can be useful to save after each edit and see the change in the program. This setting enables that.
Save With Trailing Delimiters
Default: True (enabled)
Scope: Global
Command: Toggle Save With Trailing Delimiters
When enabled, Modern CSV writes trailing delimiters for empty cells at the end of rows.
Search Engine
Default: duckduckgo.com
Scope: Global
Command: Set Search Engine
Sets the search site used by web search commands.
Shade Every Other Column
Default: False (disabled)
Scope: Global
Command: Toggle Shade Every Other Column
This setting makes it visually easier to distinguish columns. You can use it in conjunction with the Shade Every Other Row setting.

Shade Every Other Row
Default: False (disabled)
Scope: Global
Command: Toggle Shade Every Other Row
This setting makes it visually easier to distinguish rows. You can use it in conjunction with the Shade Every Other Column setting.

Show Cell Editor Panel
Default: False (disabled)
Scope: Global
Command: Toggle Show Cell Editor Panel
Shows or hides the Cell Editor panel for editing cell contents.
Show Column Labels
Default: True (enabled)
Scope: Global
Command: Toggle Show Column Labels
For a more minimalist appearance, this setting will hide the column labels.

Show Console Panel
Default: False (disabled)
Scope: Global
Command: Toggle Show Console Panel
Shows or hides the console panel.
Show Data Analysis Panel
Default: False (disabled)
Scope: Global
Command: Toggle Show Data Analysis Panel
Shows or hides the Data Analysis panel.
Show Row Labels
Default: True (enabled)
Scope: Global
Command: Toggle Show Row Labels
For a more minimalist appearance, this setting will hide the row labels.

Show Side Bar
Default: True (enabled)
Scope: Global
Command: Toggle Show Side Bar
Shows or hides the side bar in the main window. Text editor windows have a separate setting.
Show Side Bar Folders
Default: True (enabled)
Scope: Global
Command: Toggle Show Side Bar Folders
Shows or hides the folders section of the main window's side bar.
Show Side Bar Open Files
Default: True (enabled)
Scope: Global
Command: Toggle Show Side Bar Open Files
Shows or hides the open files section of the main window's side bar.
Show Tab Bar
Default: True (enabled)
Scope: Global
Command: Toggle Show Tab Bar
Shows or hides the file tabs in the main window. Text editor windows have a separate setting.
Show Text Editor Panel
Default: False (disabled)
Scope: Global
Command: Toggle Show Text Editor Panel
Shows or hides the Text Editor panel used for SQL filters, SQL queries, formulas, and scripts.
Show Utilities Panel
Default: False (disabled)
Scope: Global
Command: Toggle Show Utilities Panel
Shows or hides the Utilities panel, which contains File Properties and the Filter Manager.
Show White Space
Default: False (disabled)
Scope: Global
Command: Toggle Show White Space
When enabled, spaces, tabs, and line breaks are shown with visual markers.
Snap to Column After Scrolling
Default: False (disabled)
Scope: Global
Command: Toggle Snap to Column After Scrolling
When enabled, this will scroll to the left when you stop scrolling horizontally so it aligns with the edge of the left-most visible column. If you deal with large columns, this may be undesirable, so it is disabled by default.
Snap to Row After Scrolling
Default: True (enabled)
Scope: Global
Command: Toggle Snap to Row After Scrolling
When enabled, this will scroll up when you stop scrolling vertically so it aligns with the edge of the top visible row. Since rows are usually short and this makes the experience cleaner, it is enabled by default.
Suppress Auto-Fit Warnings
Default: True (enabled)
Scope: Global
Command: Toggle Suppress Auto-Fit Warnings
Controls whether Modern CSV suppresses warnings about auto-fit performance.
Sync Panes
Default: False (disabled)
Scope: Global
Command: Toggle Sync Panes
When enabled, panes scroll together.
Table Font
Default: Verdana on Windows and macOS, Noto Sans on Linux
Scope: Global
Command: Set Table Font
Sets the font used for data in the table.
Table Font Size
Default: 12 on Windows and macOS, 13 on Linux
Scope: Global
Command: Set Table Font Size
Sets the point size of the data text.

Text Editor Font
Default: Cascadia Mono on Windows, Menlo on macOS, Noto Sans Mono on Linux
Scope: Global
Command: Set Text Editor Font
Sets the font used in text editor windows.
Text Editor Font Size
Default: 12
Scope: Global
Command: Set Text Editor Font Size
Sets the point size used in text editor windows.
Text Editor Panel Placement
Default: Docked
Scope: Global
Command: Set Text Editor Panel Placement
Controls whether the Text Editor panel is docked or separate.
Text Editor: Show Side Bar
Default: True (enabled)
Scope: Global
Command: Toggle Show Side Bar
Shows or hides the side bar in text editor windows.
Text Editor: Show Tab Bar
Default: True (enabled)
Scope: Global
Command: Toggle Show Tab Bar
Shows or hides the tab bar in text editor windows.
Theme
Default: System
Scope: Global
Command: Set Theme
Sets the colors of Modern CSV.
| Theme | Image | Description |
|---|---|---|
| Dark | ![]() |
Standard dark theme. Yellow and purple highlights. |
| Light | ![]() |
Standard light theme. Blue headers with orange highlights. |
| Dracula | ![]() |
Popular dark editor theme with purple, pink, orange, cyan, and yellow accents. Dracula |
| Harvest Moon | ![]() |
Deep blue theme with gold headers and teal highlights. |
| Cyberpunk | ![]() |
Neon dark theme with yellow text plus magenta, green, and cyan highlights. |
| Sepia | ![]() |
Warm light sepia theme with brown paper tones. |
| None More Black | ![]() |
Very dark theme with cyan, teal, gold, and orange highlights. |
| Solarized Dark | ![]() |
Low-contrast dark Solarized palette with muted cyan, yellow, violet, and magenta accents. Solarized |
| Solarized Light | ![]() |
Low-contrast light Solarized palette with warm paper tones and muted accent colors. Solarized |
| Retro Green | ![]() |
Green-based theme. |
| Grayscale Dark | ![]() |
Dark gray-based theme. |
| Grayscale Light | ![]() |
Light gray-based theme. |
| Radiant Red | ![]() |
Red-based theme. |
| Nightfall Blue | ![]() |
Blue-based theme. Uses somewhat darker colors. |
| Kind of Blue | ![]() |
Blue-based theme. Uses somewhat lighter colors. |
| Velvet Purple | ![]() |
Purple-based theme. |
| Vintage Dark | ![]() |
Dark theme from versions 1-2 with bold primary-color accents. |
| Vintage Light | ![]() |
Light theme from versions 1-2 with pale blue, green, yellow, and red accents. |
UUID Type
Default: Random (v4)
Scope: Global
Command: Set UUID Type
Controls whether UUID commands generate random UUIDs or time-ordered UUIDs.
Write BOM
Default: False (disabled)
Scope: Table
Command: Toggle Write BOM
Controls whether the current file is saved with a BOM.

















