Open Amazon txt file as spreadsheet

Countries

Read only
Australia
Belgium
Brazil
Canada
Egypt
France
Germany
India
Italy
Japan
Mexico
Netherlands
Poland
Saudi Arabia
Singapore
Spain
Sweden
Turkey
United Arab Emirates
United Kingdom
United States
United Kingdom
imgSign in
user profile
Seller_n7TmthOw3sScT

Open Amazon txt file as spreadsheet

Hello, how simple open Amazon txt inventory report file properly as spreadsheet?
Tried multiple times, lost many time, but always mistakenly.

142 views
11 replies
Tags:Inventory
00
Reply
11 replies
user profile
Seller_zSbTCA94WTB7g

Rename the file - eg. 123456789.txt —> 123456789.XLS
Open with Excel and then save as .CSV or excel format.

00
user profile
Seller_YEFxcfQls1c3L

Open the txt file, copy & paste into a spreadsheet :slight_smile: then save!

01
user profile
Seller_n7TmthOw3sScT

when open from Excel only one option to choose available: ASCII Filter Options, then opens as txt file

00
user profile
Seller_n7TmthOw3sScT

tried to use online converter, it also convert all to one column
don’t understand why FBA inventory report is available in both format, but FBS only in txt, loose a lot of time

00
user profile
Seller_YEFxcfQls1c3L

Make sure you’re not clicking directly into the cell when you paste it, and it’ll paste into separate columns :slight_smile:

00
user profile
Seller_GjDr5hrNZfGVY

Import as you have into one column then in excel click data then text to columns, click next to end then finish

00
user profile
Seller_P9WE9DmQhKbaT

I have sometimes had this problem, one way that works on one PC I used was to open excel first and
then open the file within excel rather than click on the download file and use the open with instruction

10
Follow this discussion to be notified of new activity