Skip to content

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.

Behavior When File Is Changed Externally


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 Column Index


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.

First Row Index


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 Columns


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

Freeze Header Rows


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.

Row and column highlighting


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 for Stop Editing is).
  • Hit Alt+[I|K|J|L] (or whatever the shortcut for Move Selection [Up|Down|Left|Right] is).
  • Click on another cell.
  • Hit Esc.
  • Hit Cmd+E (or whatever the shortcut for Stop Editing is).
  • Hit Alt+[I|K|J|L] (or whatever the shortcut for Move 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.

Let Cell Editor Panel Consume Navigation Keystrokes


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 Columns


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 Number of Table Rows


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 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 Buffer 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 Columns


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.

Number of Header Rows


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.

Represent Columns as Letters


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 Column


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.

Shade Every Other Row


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

Table Font Size


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 Dark Standard dark theme. Yellow and purple highlights.
Light Light Standard light theme. Blue headers with orange highlights.
Dracula Dracula Popular dark editor theme with purple, pink, orange, cyan, and yellow accents. Dracula
Harvest Moon Harvest Moon Deep blue theme with gold headers and teal highlights.
Cyberpunk Cyberpunk Neon dark theme with yellow text plus magenta, green, and cyan highlights.
Sepia Sepia Warm light sepia theme with brown paper tones.
None More Black None More Black Very dark theme with cyan, teal, gold, and orange highlights.
Solarized Dark Solarized Dark Low-contrast dark Solarized palette with muted cyan, yellow, violet, and magenta accents. Solarized
Solarized Light Solarized Light Low-contrast light Solarized palette with warm paper tones and muted accent colors. Solarized
Retro Green Retro Green Green-based theme.
Grayscale Dark Grayscale Dark Dark gray-based theme.
Grayscale Light Grayscale Light Light gray-based theme.
Radiant Red Radiant Red Red-based theme.
Nightfall Blue Nightfall Blue Blue-based theme. Uses somewhat darker colors.
Kind of Blue Kind of Blue Blue-based theme. Uses somewhat lighter colors.
Velvet Purple Velvet Purple Purple-based theme.
Vintage Dark Vintage Dark Dark theme from versions 1-2 with bold primary-color accents.
Vintage Light 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.