best way to do it is first use the export products option and this will give you a good template to work on.
open this in exel and do the reverse to import it.
try with a few products untill you get the hang of it.
I find tab delimited files work best and also choose to add the column headers
|