For v1 there is a maximum of 6000 sales a month, across 1000 unique SKU’s a month (72,000 sales total), and 5000 unique SKU’s total.
For v2 the max sales are limited by Excel (1 million rows of sales data) and your computer. If you have over 100,000 sales a year, we highly recommend 64 bit Excel and lots of memory.
If you have Excel for PC:
You have to press a button to do so, YES! In v2.1 we introduced a feature that automatically downloads the reports that the spreadsheet needs. Depending on the amount of data you have, this can take some time to complete.
Sales, Returns, Reimbursements, Detail Page data, Advertising, and FBA Shipping Data is downloaded with this feature.
When you need to update data, it only requests the days between when you last updated data and yesterday’s date.
Sorry, this feature does not work with Excel for Mac because it uses automation features only available with MS Internet Explorer.
If you have Excel for Mac:
In order for the spreadsheet to update your data, you must download the sales reports from Amazon, then import them into the spreadsheet. This is done with a few simple clicks.
Optionally, you can load other reports like Returns, Reimbursements, Detail Page data, Advertising, and FBA Shipping Data to view more statistics.
Sorry, no. The spreadsheet uses very complex formulas, macros, and pivot tables that Google Sheets does not support.
Yes! However, the charts on the Dashboard, Daily Sum & Advertising sheets will not function since Excel for Mac does not support Pivot Charts.
Also, note that if you are using an older version of Excel for Mac 2016, the spreadsheet may not function correctly. We recommend the latest release of Excel for Mac 2011 or 2016.