Convert SQL to CSV

Use this tool to run SQL statements to create CSV and JSON.

Instructions:

  • Your SQL statements MUST include a CREATE TABLE statement and INSERT statements to load the data.
  • The very last line MUST include at least one SELECT statement.
  • Each SELECT statement will produce data.
  • Please use a plain version of CREATE TABLE with no additional keywords.
  • Use semi-colon as the SQL statement terminator.
  • This page requires a modern browser - IE10+, latest Firefox, Chrome, ....

Enter SQL statements including CREATE TABLE statement, INSERT(s), and at least one SELECT.

Only SQLITE syntax is supported! In the example below, the SELECT statement is:

SELECT * FROM employees WHERE id<10 ORDER BY name;

Step 2: Generate Output

Field Separator:

CSV Options:

Choose Conversion Format:

.csv