Below are the steps that one can follow in order to import an Excel into PHPMyAdmin:
- Open the excel file that needs to be imported.
- Note: If there are multiple worksheets in the file, then separate .csv files are required to be created, which will be executed in PHPMyAdmin.
- The user won't be able to import an excel document containing multiple worksheets.
- After opening the worksheet, go to the 'File' menu and select 'Save As'.
- In the Formatting menu, select the option ‘Comma Separated Values (.csv)’.
- A prompt is shown to Save As .csv. Click 'OK' and select the path to save the document.
- You must create separate CSV files for each worksheet in your excel document.
- Now, go to PHPMyAdmin URL in the browser and create a new database.
- Create tables for the database as per the requirement.
- Under the ‘Create new table on database (Name you gave to the database)’ field, provide the name of the new table and the number of fields for the table to be created.
- Note: The number of fields should coincide with the number of columns in the single worksheet(which is the file user created as a CSV file for a worksheet).
- Once a user enters the appropriate values, select 'Go'.
- Now the user has to manually create the field name for the table. The field name should corresponding to the column name of the worksheet.
- Finally, select the table user has created above and click the 'Import' tab.
- Select the .csv file created to be imported into this table.