Ask2Solve : import/enter data from excel

product

for starter, this is my product table. I don't give a lot field to short the tutorial. Now we want to add data from excel into the table using phpmyadmin. There is a few way:

• create script that's able to read excel then input into the table
• convert the data into csv then import

From 2 option I choose POKEMON.. I mean no 2

dragon pokemon that's not dragon ???

First try build excel like this. You just to put the header in order not to confuse. Well I have confuse and write the field position on paper (not good).
basicly we have 3 field

• A =  proid. I use 100 because 100 is the bigget/near the code in table
• B = name. Name from data
• C = detail

Next we must erase it.. just try remove the header

Save as csv

now we will use that csv.. next try open using notepad

open using notepad++

try use import on phpmyadmin

klik choose and pic file.. you will have

the data is valid

You can see, after input csv, bottom will change like above request

you can use submit bottom below. But if the csv are different format.. 

you can edi the coloumn sperated, encolsed & excape