Import CSV to PHPMyAdmin

Create the CSV file in spreadsheet software like Excel or Calc. Include the columns from your database that you want to import data to.

Then save the spreadsheet to a CSV file.

import-csv-phpmyadmin-1

Open the CSV file and cut the column header row. Save the final CSV. Paste the cut header row names into a blank text document in your code editor.

import-csv-phpmyadmin-2

In PHPMyAdmin, click the “Import” menu.  Browse for you CSV file in the “File to Import” dialogue. Then select CSV from the “Format” dropdown. Then copy your column header names from your text editor and paste them into the “Column names” field. Click “Go” and your data will import.

import-csv-phpmyadmin-3

If you experience and error, check to make sure all your columns and column names match. If you have columns with empty data this will cause an error. Delete the empty columns from your CSV file and your Column names field.

Similar Posts