Free CSV Editor for Large Files

DbSchema includes a free CSV Editor capable of handling large files up to 5 GB, depending on the free memory on your computer. Available in both DbSchema Community and Pro editions, it provides a fast way to view and modify massive datasets without importing them into a database first.

Why Large CSV Files Break Ordinary Editors

Spreadsheet applications like Excel and Google Sheets are built for calculation, not raw data storage. When you try to open a multi-gigabyte CSV, these tools often crash, freeze, or truncate your rows because they attempt to load the entire dataset into memory at once while simultaneously rendering UI elements and formula evaluation engines. A dedicated CSV editor bypasses these overheads, allowing you to interact with the raw text efficiently.

Open a CSV File in the DbSchema CSV Editor

To get started, open the editor from the main Query Tools menu. Unlike importing data, this action points the editor directly at your local file, bypassing any database connection. For example, if you have a 3 GB log file or a massive product catalog, you can point DbSchema straight to it.

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.

Handling Large Files: Loading, Memory and Limits

DbSchema opens the file into an in-memory grid view, so the practical ceiling is your available memory. The documented limit for the free CSV Editor is 5 GB, depending on how much memory the machine has free. Row and column changes take effect in that view and are written to disk only when you save. Use File > Save to overwrite the current file, or File > Save As to write a new path and format.

Add New Rows or Columns

Right-click one of the column or row headers to add a new row or column. For example, if you receive a vendor pricing list and need to insert a 'Discounted Price' column or append fifty new products to the bottom of the list, you can do this directly from the context menu without migrating the data to a new table.

Filter and Sort the Data

From the column pop-up menu, you can set filters or sort the data. DbSchema tries to guess the column data type, so sorting for numeric and date columns works correctly. For instance, if you are looking at a 2 GB log of user sign-ups, you can filter the 'Date' column to show only last month's records, and sort the 'Revenue' column numerically from highest to lowest-something a text editor would do alphabetically and incorrectly.

Edit the Data

Double-click any cell to edit its content inline. If you spot a missing zip code in a massive customer export, you can fix that specific value directly in the grid view. The change is kept lightweight in memory until you are ready to write the entire file back to disk.

Encoding, Delimiters and Save Format

Use File > Save As to write your changes. Here, you can redefine the file's structure. If you need to convert a comma-separated file to pipe-delimited format for a legacy system, or change the file encoding from UTF-8 to ISO-8859-1, simply specify the new delimiter, quote character, and encoding, and DbSchema will reconstruct the file upon save.

Import a CSV into a Database Table

Sometimes you need to move beyond simple editing and query the data with SQL. If your goal is to move the file's contents into a relational database, DbSchema provides a dedicated Data Importer, which is a Pro feature rather than part of the free Community Edition. It maps each file column to a database column, lets you exclude the columns you do not want, and lets you define names and data types when the target table does not exist yet. The separator, quote character, escape character, date format and locale are all set in the same dialog, and any rows that fail are listed with their line numbers in the Error pane. The steps for one engine are written up in import a CSV into MySQL; PostgreSQL and the other supported databases follow the same dialog.

Download DbSchema and open Query Tools > CSV Editor to work through a file that is too large for a spreadsheet. The CSV Editor is part of the free Community Edition, so nothing here needs a licence; loading the same file into a database table uses the Data Importer, which is Pro.