Import csv, text, excel file to create database table

Featured Function

Import CSV, text, excel files and create table

  • able to import file types (.csv, .txt, .xls, .xlsx)
  • able to preview data before import to the database
  • create a table (sheet name as the name of the table) follows data structure of imported file, then inserting of records.

Initially written in PHP and MySQL as the backend, however, it is possible with asp.net and MS SQL as well.

This can be useful for inventory system’s bulk data import, eliminating manual data entries.

Please feel free to contact us in case you have this kind of requirement.