CSV Studio - How It Works

CSV Format Errors

CSV files generated by SQL Databases often contain errors and variance in syntax. This is due to the lack of a single, official specification for CSV as well as the SQL implementation of the file export feature itself. The sheer size of files generated by databases makes manual correction of these files completely impractical.

CSV Studio identifies a list of issues and lets you directly examine each one in turn. For each error, CSV Studio suggests changes that will make the file comply with the RFC 4180 specification or other popular variants of CSV format, such as Postgres and DB2 default formats.

Step by step

CSV Studio is powered by a fast and robust parser written in Java. This parser will flag errors and warnings while it processes the CSV file selected by the user.

Different types of issues will be highlighted in the tabular visualization. In some cases it will be necessary to look at the detail panel and the raw content tab to understand what syntax error in the original file is causing the issue.

Once the file is processed, CSV Studio can display the data as a table inside a browser like Chrome or Firefox. Using the error summary panel, and the user can jump to any location in the file to take a closer look.

For each error the user can choose a suggested change to fix the CSV syntax and visualize the result. CSV Studio proposes fixes for the most common errors encountered in files produced by SQL databases. The smart parser will seek to perform the best possible correction available to fix the error. If the fix is not satisfactory the user can undo the change and/or try another suggestion. Sometimes multiple corrections have to be applied to clear all the errors.

Once the errors have been corrected, CSV Studio can export a new CSV file which can be ingested easily by a regular spreadsheet or database.

How CSV Studio works

CSV Format Errors

Step by step

Feedback