Import your stock from Excel

5 min readIntermediateUpdated November 2026
In short: Upload an .xlsx file, match its columns to StoreBook, review the preview and import.
  1. 1

    Open Import from Excel

    On the Home screen, choose Add inventory, then Import from Excel.

  2. 2

    Choose what you are importing

    Products only creates or updates your product list and does not move stock. It is best for first setup. Physical stock records what you have on the shelf today as opening stock, and the IMEI check still applies to phones.

  3. 3

    Upload your file

    Drop your .xlsx file, or browse for it. A file can have up to 5,000 rows.

  4. 4

    Match your columns

    StoreBook guesses which column is which. Check the matches, and fix any that say Not mapped.

  5. 5

    Review and import

    Look at the first rows, then validate. If StoreBook finds problems, such as a repeated IMEI, it tells you before anything is saved.

Tip

Start with a small file of about 10 rows to see how it works, then import the rest.

Next steps

Ready to run your shop with confidence?

30 days free. No card. We help you set up on WhatsApp.

Start free for 30 days