Using the MS Excel Text Import Wizard

1	Open MS Excel.

2	From the File menu, select Open.

The Open window opens.

3	Navigate to the location of the text file (.txt extension).

Note: Next to the File name text box, be sure to select Text Files from the drop-down list so that all text files display.

4	Select the file, and click Open or Open Other Workbooks.

MS Excel’s Text Import Wizard - Step 1 of 3 window opens.

5	Select Delimited as the file type that best describes your data (how your data will be read).

6	Click Next.

The Text Import Wizard - Step 2 of 3 window opens.

7	Be sure that the following options are set:

a	Under Delimiters, select the Tab check box and the Comma check box. Make sure that all other check boxes are cleared.

b	Clear the Treat consecutive delimiters as one check box.

c	From the Text qualifier drop-down list, select the double quotes (").

8	Click Next.

The Text Import Wizard - Step 3 of 3 window opens

9	Select the first column (which contains the ITEM_NUMBER) by clicking the General column heading.

The column highlights.

10	Under Column data format, select Text.

The column heading now reads Text.

11	Repeat Steps 9 and 10 for the third and fourth General columns (which contain the Selection Code and Product data) to set them to a Text data format.

Note: Depending on the filter you selected, Private Account IDs associated with Unit Cost and MSRP also need to be set to a Text data format.

12	Click Finish.

The downloaded data displays in Excel, and the format of the GTINs, Selection codes, and Products is preserved.

Note: To expand all columns to the width of the data within each column, highlight the entire spreadsheet by clicking on the upper left-hand corner of the spreadsheet, and then double-click on the line between any of the column headings.

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.