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.
11 replies
Seller_zSbTCA94WTB7g
Rename the file - eg. 123456789.txt —> 123456789.XLS
Open with Excel and then save as .CSV or excel format.
Seller_YEFxcfQls1c3L
Open the txt file, copy & paste into a spreadsheet then save!
Seller_n7TmthOw3sScT
when open from Excel only one option to choose available: ASCII Filter Options, then opens as txt file
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
Seller_YEFxcfQls1c3L
Make sure you’re not clicking directly into the cell when you paste it, and it’ll paste into separate columns
Seller_GjDr5hrNZfGVY
Import as you have into one column then in excel click data then text to columns, click next to end then finish
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