Web Applications > Importing CSV data to a MySQL Table
This web application was originally developed for importing selected data in an Excel file into a MySQL database table. The Excel file must first be converted to a CSV file.
The application is most useful where the names and number of CSV fields may be different than the names and number of MySQL table fields, and where there may not be a matching CSV field for every table field. Even for those fields that do match, the data may be formatted differently, or MySQL table fields that have no CSV match may still require that some data be input.
In the application's user interface, for every field in the MySQL table, there is a corresponding CSV select dropdown menu containing all the names of the CSV fields.
For MySQL table fields that have no CSV match, but require data, you can add custom code to dynamically create the imported data.