Creating csv files to import into Excel or Access is a routine part of my job.
It’s nice to learn Amazon will create a csv file very easily. It imports in Excel or Access. Acesss is your best choice if you take the time to identify keys. Sorting on product code is often very helpful.
Then you can go in add subtotals and create multiple reports as required.
Just passing along information, for those who use these tools too.
I heard about this a couple years ago and did it then. I went back today to make an updated list and noticed it was almost to the day of last time I did it. How does that happen? The original article I saw that recommended this suggested the wrong column to sum up. It didn’t take into account quantities ordered. Just for the record, you want to sum up row “AD” if you use Excel (and I imagine most other spreadsheets). It is frightening to see what I have spent at Amazon in 12 years.