I’ve developed a simple online tool that allows you to convert a CSV file into SQL statements that can be inserted into a database table.  It’s a simple process:

  1. Create a CSV file containing your data
  2. The first row of the CSV file should contain column titles which exactly match the fields in your database table
  3. Go to http://www.csv2sql.com/
  4. Upload your CSV file and enter the name of your database table
  5. Click GO
  6. INSERT statements are generated for you by the online tool.
  7. Copy the SQL to your clipboard and paste into a file to load into your database – and you are done!

It’s that easy.  This tool used to be at csv2sql.evandavey.com, however I thought www.csv2sql.com was easier to remember, so I purchased the domain.