Are you struggling to open Amazon inventory reports with Microsoft Excel?, If so then I will guide you on how to open the reports in Excel easily.
Have you downloaded Amazon inventory reports from Amazon recently and found out that the report has been downloaded in .txt format? whenever you try to open it with Microsoft Excel then it messes up the data.
Amazon Inventory Report downloads in .txt format. To open it in excel you have to use the inbuilt feature “Text Import Wizard of Microsoft Excel”
How to Export Amazon Inventory Report to Excel?
All reports that you download from Amazon Seller Central come in CSV format which is compatible with Microsoft Excel. Only inventory reports that you download from Amazon Seller central come in .txt format which is also compatible with Microsoft excel.
However, when you try to open .txt format in excel, it opens but all the columns of the report merge. There is a feature of Excel called “Text Import Wizard” when opening .txt file with Microsoft excel.
Use this feature to open the .txt file easily.
Use Text Import Wizard of Microsoft Excel
The “Text Import Wizard” is a feature of Microsoft Excel that lets you correct the file and allows you to separate the text fields into relevant columns.
- Open Microsoft Excel
- Click on File Tab or Alt+F
- Click on Open
- Click on the drop-down of file formats
- Choose “Text Files”
- Click on the specific file that you wish to open
- Click on “Delimited” if it is not already selected
- Click “Next”
- Click on “Tab” if it is not already selected
- Click “Next”
- Click “Finish”
You can easily open the inventory report with Excel by following the instructions above.
Remember all files that you download from Amazon come in CSV format and it is compatible with Excel. Use the above method for .txt file. If you would have any other queries, let us know in the comment below.