Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Office Help Home

...

Table of Contents

Table of Contents
minLevel1
maxLevel7
excludeTable of Contents

Accessing the Tool

Launch Microsoft Excel and select Open from the File menu tab. 

...

Image AddedImage Added

Image Removed

Select the Text file you have created with your scanning device. To help search for the text files, you can Text Files in the drop down box at the bottom right. 

...

Image Added

Next, select Open.

...

Image Added

This will open the Text Import Wizard within Excel. Ensure the Delimited file type is selected and click Next.

...

Image Added

On step 2 of the wizard, select Comma under Delimiters and click Next

...

Image Added

On step 3 of wizard, the Column data format will default to General. Click Finish.

...

Image Added

Once finished, an Excel spreadsheet will open with the SKU or UPC codes in the first column. If the scanner allows for the addition of quantities, this will appear in the second column. 

...

Image Added

Saving The Document as a CSV File

Navigate to the File tab and select Save As

Image Removed

...

Image AddedImage Added

After naming the file, change the Save as type to be CSV (Comma delimited) and click Save.

...

Image Added

This can now be used to import into the Inventory Count Wizard.

Image Added