DbSchema Database Designer

DbSchema | CSV Editor for Large Files

Design • 11-Nov-2021
by DbSchema Team

DbSchema includes a free CSV Editor for large files, up to 5G, depending on the free memory on your computer.
The editor is available under both, DbSchema Community and Pro editions.

Open the CSV Editor

Open the editor from the Query Tools menu.

Open the CSV Editor

In the next step, you can choose the file to open, and the CSV format: file encoding, fields and records delimiters,
and quote character. DbSchema will try to guess first this for you.

Press ‘Cancel’ to edit a new CSV.

Choose CSV File Format

Add New Rows or Columns

Right-click one of the column or row headers to add a new row or column.
Add new row or column

Filter & Sort the Data

From the column pop-up menu, you can set filters or sort the data. DbSchema is trying to guess the column data type, so the sorting for numeric and date columns
is working correctly.

Filter and sort the data

Edit the Data

Double-click any cell to edit its content.

Edit the data

Save Format

Use ‘File / Save As’ to save the edited CSV under a given file and format.

Save the CSV File

DbSchema → Your Trusted Partner in Database Design

Simplify complex database workflows and improve productivity with DbSchema's advanced design and management tools

Visual Design & Modeling
Visual Design & Schema Layout

➤ Create and manage your database schema visually through a user-friendly graphical interface.

➤ Easily arrange tables, columns, and foreign keys to simplify complex database structures, ensuring clarity and accessibility.

GIT & Collaboration
Version Control & Collaboration

➤ Manage schema changes through version control with built-in Git integration, ensuring every update is tracked and backed up.

➤ Collaborate efficiently with your team to maintain data integrity and streamline your workflow for accurate, consistent results.

Data Explorer & Query Builder
Relational Data & Query Builder

➤ Seamlessly navigate and visually explore your database, inspecting tables and their relationships.

➤ Build complex SQL queries using an intuitive drag-and-drop interface, providing instant results for quick, actionable insights.

Interactive Documentation & Reporting
HTML5 Documentation & Reporting

➤ Generate HTML5 documentation that provides an interactive view of your database schema.

➤ Include comments for columns, use tags for better organization, and create visually reports.