How do I track multiple sizes or colors of the same product?

Create one row per variant. Use a consistent product name followed by the variant in parentheses, like 'Nike Dunk (US 10 / Black).' This keeps sorting clean while preserving detail.

What happens when I exceed 1,000 rows?

Google Sheets handles tens of thousands of rows, though very large sheets slow down on mobile. Consider splitting by quarter or supplier once you cross 2,000 active rows.

Tutorial

How to Use GTBuy Spreadsheet Step-by-Step

A complete walkthrough from blank template to your first profitable bulk order. Follow this proven system used by thousands of resellers.

Updated May 2026·12 min read

What You Need Before You Start

Before opening your GTBuy spreadsheet, gather three things: a list of suppliers you are considering, approximate retail or resale prices for the products you want, and a rough idea of your monthly order volume. You do not need exact numbers — estimates are enough to get started. The spreadsheet will refine them as you go.

You also need a Google account or Microsoft Excel license. Google Sheets is free and offers real-time collaboration, so we recommend it for most users. Excel works perfectly if you prefer desktop software or need advanced macro automation later.

Step 1: Download and Duplicate the Template

Visit our templates page and choose the version that matches your experience level. Click the share link, then select File > Make a Copy in Google Sheets. This creates your private version that nobody else can edit. Rename it to something descriptive like 'GTBuy Tracker — Summer 2026' so you can find it quickly in your Drive.

If you are using Excel, download the .xlsx file and save it locally. Consider backing it up to OneDrive or Dropbox so you never lose months of data to a hard drive failure.

Step 2: Customize Your Columns

The template ships with twelve standard columns. Read through each header and ask yourself: 'Will I actually fill this in for every product?' If the answer is no, hide the column rather than delete it. You might need it later. If you need a custom column — say, 'TikTok Viral Potential' or 'Local Market Demand' — insert it after the last standard column so you do not break existing formulas.

Next, adjust the currency symbol in the cost and price columns. Click the column header, choose Format > Number > Currency, and pick your preferred symbol. This small step prevents confusion when you are reviewing margins at 2 AM before a drop.

Step 3: Add Your First Five Products

Start small. Choose five products from one supplier. For each, fill every column in the first row. Watch how the margin cell automatically updates as you type. If it shows a negative number, either your cost is too high or your sell price is too low. Adjust one or both until the margin turns green. This exercise teaches you more about pricing strategy than any YouTube video.

Do not worry if your first five rows look messy. Perfection is the enemy of progress. The goal is to build the habit of logging every product before you buy it.

Step	Action	Time Needed	Critical?
1	Download & duplicate template	2 min	Yes
2	Customize columns & currency	5 min	Yes
3	Add 5 sample products	10 min	Yes
4	Set status labels & colors	5 min	Recommended
5	Share with partner/team	3 min	Optional
6	Schedule weekly review	2 min	Critical

Quick Tips

Use the 'Notes' column to paste supplier chat snippets. Context saves hours when reordering.
Sort by margin weekly. Prioritize green-margin products and question red-margin ones before reordering.
Create a duplicate tab called 'Archive' and move sold-out rows there monthly. Keeps your active tab fast.

Visit Main Store

Browse curated collections and fill your GTBuy spreadsheet with profitable products.

Frequently Asked Questions

Yes. Copy-paste from Excel or CSV files directly into the matching columns. Just verify that your columns align, or the formulas will reference the wrong data.

Related Guides

Continue building your GTBuy spreadsheet knowledge with these hand-picked guides.

Guide