Export products to CSV file

Log into your Magento administrator area.

Go to System -> Import/Export -> Dataflow – Profiles -> Export All Products

Under Profile Wizard -> Store choose the desired store where you will be exporting the products.

Under Data Transfer drop down menu choose Local/Remote Server.

Under Data Format make sure CSV / Tab Separated is selected for type and click Save Profile

Open Run Profile tab and click Run Profile in Popup button.

This will save a file named export_all_products.csv under the var/export/ directory of your Magento installation.

Using an FTP client or CPanel File manager download this file to your local computer. You can edit the PRICE field with a spreadsheet program (MS Excel, Open Office Spreadsheet) and add the products prices you would like to import.

Now we will show how to import the products.

Go to the Magento administrator area and choose System -> Import/Export -> Dataflow – Profiles -> Import All Products. Select the required settings in Profile Wizard tab.

Then choose Upload file tab and browse for the .csv file on your computer. Save changes.

3.Once you have uploaded it, click Import All Products, then Run Profile, select the .csv file you have just uploaded from the drop down menu and click Run Profile in Popup.

When import is completed, you will get an export success message. The similar way you can export and import your customers.