Exporting a CSV Catalog File to Excel

You can export a catalog from the Commerce Server database and then import it into a Microsoft Excel spreadsheet.

Ee824495.note(en-US,CS.20).gif Notes

When you export a virtual catalog, it becomes a base catalog. For example, you can export a virtual catalog, and then import it as a base catalog.
If you export a catalog in CSV file format, you can export the catalog in only one language.
When you export a virtual catalog, the price rules are not exported.

To export a catalog in CSV file format

In Catalogs, click Catalog Editor.
In the Catalogs screen, select the catalog you want to export, and then click on the toolbar.
Select Export CSV from the drop-down list.
In the ExportCatalog dialog box, in the Start date box, type the date for which you want to start the incremental export.
In the Language box, specify the language in which to export multilingual properties. For example, if the property Description contains values in both English and Chinese, you can export the catalog only in English, only in Chinese, or in both languages.
In the Specify the location to save the file on the server box, type the complete path and file name of a catalog that can be written to by the server, and then click OK.

When specifying a file on the server side, if you specify only the file name, the file will be exported to the ProductCatalogs folder under the BizDesk folder on the server. For example, exporting a file as output.xml will export it on the server as d:\inetpub\wwwroot\retailbizdesk\productcatalogs\output.xml. You can set up this folder as a share.

The catalog is exported to the specified location.

To import a CSV catalog file into Excel

In Microsoft Excel, click .
In the Look in list, locate the drive, folder, or Internet location that contains the file you want to open.
In the Files of type list, select Text Files (*.prn; *.txt; *.csv) from the drop-down list, and then click Open.

The Text Import Wizard is started.
In the Text Import Wizard – Step 1 of 3 screen, accept the default entries, and click Next.
In the Text Import Wizard – Step 2 of 3 screen, select Comma as the delimiter, accept the remaining default entries, and then click Next.
In the Text Import Wizard – Step 3 of 3 screen, select the Column format you want, and then click Finish.

The catalog file is imported into Excel.

Additional resources