1.   Login into Magento Admin Panel

Login into magento admin panel using the url "[site url]/admin"

2.   Add a new product manually using the magento admin panel

Add a new product manually to the catalog, assign it to a category, and fill out all fields that will be  necessary to your store. The obvious ones are price, description, quantity etc. It's important that you fill out all fields that you know you are going to need for all the products you import.

3.   Export Your Products

Now we want to export your product to a .csv file so that we can view the fields that are required to import. Go to System >> Import/Export >> Profiles. Now click on Export All Products then Run Profile. Click on the “Run Profile in Popup” button. Once the export is completed, go to your var/export directory on your Magento install and you will find the .csv file there for you to download.

4.   Analyze The .CSV File

Now if you look at your .csv export file you will see the field names that you need to match up. Now just start filling yours in and creating your csv file ready for import. This step is extremely important. Otherwise Magento cannot match what you are trying to import and the importing will fail.

5.   Import Your New .CSV File

Now go to System >> Import/Export >> Profiles. Now click on Import All Products. Change “Type” under Data Format to CSV/Tab Seperated. Now click on Upload File, and browse for your .csv file and click “Save and Continue Editing”. Now go to “Run Profile” and select your file from the dropdown menu. Click the button underneath to run the import. And whalllah. All your products should now be imported.