Office - Items - Converting TXT File to CSV for Inventory Count Upload
Table of Contents
Overview
Learn how to convert a .txt document to a .csv for importing Inventory counts.
Required Permissions
Accessing the Tool
Launch Microsoft Excel and select Open from the File menu tab.
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.
Next, select Open.
This will open the Text Import Wizard within Excel. Ensure the Delimited file type is selected and click Next.
On step 2 of the wizard, select Comma under Delimiters and click Next.
On step 3 of wizard, the Column data format will default to General. Click Finish.
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.
Saving The Document as a CSV File
Navigate to the File tab and select Save As.
After naming the file, change the Save as type to be CSV (Comma delimited) and click Save.
This can now be used to import into the Inventory Count Wizard.
Best Practices
FAQs