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]
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.
Latest posts by Amogh Desai (see all)
