If you don't know how to create a csv file. Download and open a sample template file below and fill out your data on it.
Fill this out
This csv to mysql converter is a free online tool where you can upload your csv files and convert it into mysql queries easily. It is very useful when you have lots of data in Microsoft Excel and need to migrate it to your mysql database.
Follow this steps to do so
- Step 1: Open your MS Excel file (.xls, .xlsx) and save it as
.csv. Make sure that the column names are in the first row of the sheet and these names should be as same as your mysql table columns. You can download a sample csv template also from this page.
- Step 2: There is a form above in this page, fill in your mysql table name. Then select a mode (INSERT or UPDATE). If you are going to generate INSERT queries you can continue from step 4 or if you are going to generate UPDATE query see Step 3.
- Step 3: When you select UPDATE mode another text field will open. You have to a key field in this box which will be used in WHERE Clause of each queries.
- Step 4: Then hit submit button. Your MySQL queries will be generated and shown in a textbox below the form.
If you find and problems with the app, write us on connect [at] voidtricks [dot] com