Importing .csv file into sql via phpmyadmin

Facebooktwittergoogle_plusredditpinterestmail

You can import records into your sql database in the form of an excel sheet using phpmyadmin.

Step 1: Excel sheet with records to be inserted

  • Create an excel sheet with all the records to be inserted into your database.
  • The columns of the excel sheet will be same as the table columns
  • Format your excel sheet as per the table columns and then delete the first row with column heading

Step 2: Converting Excel into CSV

    • Go to File – > Save As

  • Now enter the name of the file and select the File Type as CSV, and click Save

Step 3: Importing .csv file into sql via phpmyadmin

  • Select the required table and click Import
  • Select the .csv file
  • Format of imported file – Select ‘ CSV using LOAD DATA ‘
  • Fields terminated by: Change ” ; ” to ” , ” and leave the rest as it is and click GO.

And you are done 🙂

 

[important]Important: Don’t try to import more than 50 records at a time ![/important]

Amogh Desai

Amogh Desai

A System Admin by profession, is a tech buff and a licensed Amateur Radio operator with callsign VU3DES. He is interested in Technology, Amateur radio, Electronics home-brewing, FOSS, Photography and everything tech. He uses this blog to share his views and ideas with people sharing similar interests.
Amogh Desai
Facebooktwittergoogle_plusrssyoutube

1 Comment


  1. wow that was pretty awesome!

    Reply

Leave a Reply

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