CSV Editor

The CSV Editor opens a CSV file as a grid of rows and columns, and DbSchema built it for large files. You edit cells, filter and sort the rows, and save the file. The CSV Editor works in every edition of DbSchema, Community included, and needs no database connection.

The CSV Editor with a file of customers sorted by last_name

Open a CSV file

  1. Choose Query → CSV Editor.
  2. Press Choose and pick the file.
  3. Check the Charset, the Delimiter, the Record Separator and the Quote Character that the file uses.
  4. Tick First Row is Header if the first line holds the column names.
  5. Press Open.
The dialog CSV Editor for Large Files - Choose File, with the file chosen and First Row is Header ticked

The file opens as a new tab under the diagram. To give it the whole diagram area, double-click its tab. An icon in the column header marks the columns that hold numbers or dates.

Edit cells, rows and columns

  1. Double-click a cell, type the new value and press Enter.
  2. To add or remove rows and columns, click a cell and open Row/Column: Insert Column Left, Insert Column Right, Insert Row Before, Insert Row After, Delete Row or Delete Column.
  3. To rename a column, right-click a cell of it and choose Rename Column.
  4. Choose File → Save, or press Ctrl+S. File → Save As writes a new file.

The file on disk changes only when you save. Edit → Undo, or Ctrl+Z, takes back a change, and Edit → Find Replace replaces text in the whole file.

Filter and sort the rows

A filter hides the rows that do not match, so you can work on a part of a large file.

  1. Click a cell in the column to filter, such as last_name.
  2. Choose Filter & Sort → Filter.
  3. Choose the operator, such as equals, type the value and press Ok.
The dialog Edit Filter on 'last_name', with equals and the value Tanaka

A funnel icon marks the filtered column, and the grid shows only the matching rows.

The CSV Editor showing only the customers whose last_name is Tanaka, with a funnel icon in the last_name header

Filter & Sort → Clear Filters shows all rows again. To sort, click a cell in the column and choose Filter & Sort → Sort Ascending or Sort Descending.

Next steps