Creating easy-to-read spreadsheets is paramount to properly importing data into spreadsheets. In order to help Bindwise work with your spreadsheets, we recommend that you follow these guidelines when building your tables.
Use columns for categories and rows for entries
Any data from your Amazon Seller Central (e.g., inventory, listings, fees), will appear in a spreadsheet in the form of a row.
That's why it’s important to ensure that the structure of your sheet is uniform, and that is built such that each row represents an entry and each column represents a category for type of entries.
To understand what this means, let’s look at 3 examples.
In this 1st example, we can see that the desired structure is inverted. Data headers are arranged vertically, and new entries representing inventory items are added as columns. This arrangement won't allow Bindwise to work.
This 2nd example spreadsheet contains a section that is meant to be used as a calculator. Because this interrupts the structure of the spreadsheet, however, it will prevent new rows from being added.
Tables must remain structurally consistent across their entirety, and they must consist of only column headers and ensuing rows of data. If you have a section such as a calculator which interrupts the overall structure of the table, you’ll need to either integrate it into the original table structure (see the next example) or relegate it to its own independent table.
This is the only accepted clean structure that will allow Bindwise to work with your data.
- The table must start at the 1st row
- 1 table per sheet can have live data (although you aren't limited to creating multiple tables on 1 sheet)
- Max ~30,000 rows in a sheet