CSV Editor

DbSchema includes a free CSV editor capable of handling large files — up to 5 GB, depending on available memory. The editor is available in both the Community and Pro editions.

Opening the CSV Editor

Open the editor from Query Tools → CSV Editor in the application menu.

You will be prompted to choose a file and configure the format. Press Cancel at this step to start with a blank CSV instead.

Choosing a File and Format

When opening an existing file, configure the following settings:

  • File encoding — character encoding of the file (UTF-8, ISO-8859-1, etc.)
  • Field delimiter — the character that separates columns (comma, tab, pipe, semicolon, etc.)
  • Record delimiter — the character that separates rows (usually newline)
  • Quote character — the character used to wrap field values that contain the delimiter

DbSchema attempts to auto-detect all of these settings from the file content. Verify the preview looks correct before opening.

Adding Rows and Columns

Right-click any column header to insert or delete a column. Right-click any row header to insert or delete a row. Both operations take effect in the in-memory view and are written to disk when you save.

Filter and Sort

Right-click any column header to access filter and sort options. DbSchema detects the column data type (text, numeric, date) and applies type-appropriate sorting — so numeric columns sort by value rather than alphabetically.

Editing Data

Double-click any cell to edit its value inline. Press Enter or click another cell to confirm the change.

Saving

Use File → Save to overwrite the current file, or File → Save As to write to a new file path and format. The Save As dialog lets you change the delimiter, encoding, and quote character before writing.