Opening a Downloaded CSV Text File in MS Excel

This topic describes how to work with a downloaded OpenText Active Catalogue text file within Microsoft Excel (MS Excel). The procedures step you through the process of opening the text file in MS Excel so that the format of the GTINs, Selection codes, and Products is preserved.

Note: Catalogue creates a comma separated values (CSV) text file that has a .txt extension rather than a .csv extension. This allows you to open the text file in MS Excel and then set specific options so that the format of your data is preserved.

There are two methods for opening a text file in MS Excel:

Using the MS Excel Text Import Wizard—see “Using the MS Excel Text Import Wizard�

Using the Open With option from Windows Explorer—see “Using the Open With Option from Windows Explorer�

21.2 release. Online Help last updated March 6, 2021 OpenText Active Catalogue Browser Interface User Guide for Vendors PDF

Copyright © 2021 Open Text. All rights reserved. Trademarks owned by Open Text.