File2sql icon

From CSV to MySQL in less than 20 seconds.

How to create a new MySQL table ( populated and with automatic data type detection), from CSV source file in less than 20 seconds.


  • Web browser.
  • MySQL database. Link
  • MySQL database management tool. e.g. PhpMyAdmin
  • CSV file with data.

You can find a small sample file here. ( csv_with_headers.csv )


Steps to follow:

  • Select CSV file type to convert and data file.

  • Select desired options.
  • Click on “Convert File” button.

  • Click on “Copy to clipboard” button.
  • Open your database management tool  url. e.g.PhpMyAdmin ( http://localhost/phpmyadmin )
  • Select ( or create ) database to use e.g. test
  • Select SQL tab and paste clipboard at text-box

  • Click on continue

  • You can check and USE from MySQL your converted data.

You can see the generated data types.

And the populated data.


How much time would you have spent doing the same thing in the old ( and manual ) fashioned way?


Leave a Reply

Your email address will not be published. Required fields are marked *