.csv.sql·Spreadsheets & data

Convert CSV to SQL offlineon Mac, Windows & Linux, with nothing uploaded

Load a CSV into a database without writing the statements yourself. flipfile generates a CREATE TABLE and the INSERT INTO statements for every row.

How to convert CSV to SQL

flipfile lives on your desktop as a small glass circle. Dropping files on it opens a ring of formats around it.

  1. 1

    Drop the files

    Drag one or more .csv files onto the flipfile circle.

  2. 2

    Point to SQL

    OfficeDataSQL

    Move toward Office, then Data, then SQL. The way back always sits where you came from.

  3. 3

    Let go

    The result appears next to the original:

    export_converted.sql

What you get

  • A typed CREATE TABLE statement and INSERT INTO statements for the rows.
  • Works from Excel, TSV, JSON, YAML and XML too.
  • Run the .sql file in your database client or migration tool.

Works on

CSV and SQL in short

CSV (comma-separated values)

.csv

A plain-text table, one row per line. Every spreadsheet, database and programming language reads it.

SQL script

.sql

Statements a database runs: CREATE TABLE to make a table, INSERT INTO to fill it.

Questions about CSV to SQL

Which databases does the SQL work with?

The output is standard CREATE TABLE and INSERT INTO statements; check the column types against your database before running it.

Can I convert Excel to SQL?

Yes, drop the workbook on Office → Data → SQL.

Is flipfile free?

Yes. flipfile is free and open source under the MIT license. There is no account, no sign-up and no subscription.

Are my files uploaded anywhere?

No. flipfile converts on your own computer and keeps working with the Wi-Fi off. Its only network request is the update check, which sends nothing about you or your files.

Free · Open source · 100% offline

Convert CSV to SQL with one drop

flipfile converts 75+ formats on your Mac, Windows or Linux desktop: photos, PDFs, Office, data, video and audio. Nothing leaves your computer.