How to Use Itaobuy Spreadsheet Step-by-Step
Learning how to use itaobuy spreadsheet tools is the fastest way to level up your reselling game. This step-by-step tutorial walks you through every feature, formula, and shortcut you need.
Getting Started
Before you build your spreadsheet, gather these essentials: a Google account (for Sheets), a list of your most-purchased categories, and a rough idea of your target profit margin. Most resellers aim for 20-40% minimum.
Step-by-Step Setup
1. Open Google Sheets
Go to sheets.google.com and create a blank spreadsheet. Rename it to "Itaobuy Tracker 2026".
2. Add Headers Row
Row 1: Date | Category | Product | Buy Price | Sell Price | Shipping | Profit | Status | Notes
3. Enter the Profit Formula
In the Profit column, type =D2-E2-F2 assuming Buy=Col D, Sell=Col E, Shipping=Col F.
4. Format for Readability
Bold headers, freeze row 1, set currency format for price columns, and add alternating row colors.
Pro Tips
- Use data validation for the Category column to prevent typos
- Create a separate sheet for price history to track trends
- Add a dashboard sheet with charts showing monthly profit
- Use Google Sheets mobile app to update on the go
Want the complete guide with templates?
Read Full GuideFAQ
Can I use Excel instead?
Yes, all formulas work in Excel too. Google Sheets is recommended for cloud sync and free access.
How long does setup take?
First setup takes 10-15 minutes. Adding each new product takes 30 seconds once your template is ready.