Follow this exact step-by-step tutorial to build your sugargoo spreadsheet from scratch. Perfect for visual learners who want hands-on guidance.
Sugargoo Spreadsheet Team
Published on Sugargoo Spreadsheet Courses
This tutorial is designed for hands-on learners who want to build their sugargoo spreadsheet alongside reading. We will go through every single step, from opening your first spreadsheet to adding your tenth item. No prior experience is required.
By following these steps exactly, you will create a fully functional spreadsheet that can handle any purchase workflow. We will use Google Sheets because it is free, cloud-based, and works on every device. If you prefer Excel, the steps are nearly identical.
Grab a cup of coffee and set aside about twenty minutes. By the end, you will have a professional-grade tracking system that many buyers pay for. Let us dive in.
Open Google Sheets and create a blank spreadsheet. Click on "Untitled spreadsheet" at the top and rename it to "My Sugargoo Orders 2026". This simple step makes your work feel official and helps you find it later in your Google Drive.
Click on cell A1 and type "Item Name". Then move across the first row and add these headers: Product Link, Seller, Price, Size, Color, Shipping, Total, Status, Notes. You now have the foundation of your tracking system.
Select the entire first row by clicking the row number. Then click the Bold button (B) in the toolbar. This makes your headers stand out visually. Next, click Format > Freeze > 1 row. Now your headers will stay visible when you scroll down.
Let us add a real product to your spreadsheet. In row 2, column A, type the name of an item you want to buy. For example: "Nike Dunk Low Panda". In column B, paste the product link from the seller.
In column C, type the seller name. In column D, enter the price in your local currency. If the price is in yuan, convert it first or add a separate column for original currency. In column E and F, enter size and color.
For column G (Shipping), enter an estimate. You can find typical shipping costs on agent websites. In column H (Total), enter the formula =D2+G2. This adds your price and shipping automatically. Now you have your first complete row.
Select columns D, G, and H by clicking their column letters while holding Ctrl. Right-click and select "Format as currency" to display dollar signs and two decimal places. This makes your spreadsheet look professional and prevents rounding errors.
Add conditional formatting to the Status column. Select column I, then click Format > Conditional formatting. Set rules: "Pending" = yellow background, "Ordered" = blue, "Shipped" = green, "Arrived" = mint green. Now you can scan status instantly.
Resize columns by double-clicking the border between column letters. This auto-fits column widths to their content. Make the Product Link column wider so you can see the full URL, and the Notes column wider for longer text.
Below your data rows, add a totals row. In cell D100 (or wherever your data ends), type =SUM(D2:D99). This adds all your item prices. Do the same for columns G and H. Now you have a running total of your entire shopping list.
Add an average formula to see your typical item cost. In an empty cell, type =AVERAGE(D2:D99). This helps you understand your spending patterns. You can also add =COUNTA(A2:A99) to count how many items you are tracking.
For advanced tracking, use =IF(D2>100, "High", "Normal") to automatically flag expensive items. This creates a visual alert system that draws your attention to big purchases before you commit.
When you have more than twenty items, a single sheet becomes crowded. Right-click the sheet tab at the bottom and select "Duplicate". Rename the new sheet to "Shoes". Now you have a dedicated sheet for shoe orders.
Create additional sheets for Clothing, Accessories, and Bulk Orders. Each sheet can have slightly different columns. For example, the Shoes sheet might have a "Shoe Size" column, while the Clothing sheet might have "Fabric Type".
Add a summary sheet that pulls totals from all other sheets. In a new sheet called "Summary", type =SUM(Shoes!H2:H99) + SUM(Clothing!H2:H99). This gives you a grand total across all categories.
| Step | Action | Time | Result |
|---|---|---|---|
| 1 | Create blank spreadsheet | 2 min | Empty sheet ready |
| 2 | Add headers and freeze row | 3 min | Structured foundation |
| 3 | Enter first product row | 3 min | Working data row |
| 4 | Add formatting and colors | 3 min | Professional look |
| 5 | Add formulas | 5 min | Automatic calculations |
| 6 | Create multiple sheets | 4 min | Organized categories |
| 7 | Set up backup system | 2 min | Protected data |
Yes, Google Sheets has unlimited undo (Ctrl+Z). It also has version history that you can access via File > Version history.
Right-click the row number and select "Delete row". Your formulas will automatically adjust to exclude the deleted row.
Select the row, press Ctrl+C, click the destination sheet tab, then press Ctrl+V. All data and formulas will copy correctly.
You can, but be careful. Use "Viewer" permission if you want them to see but not edit. Sharing links publicly is not recommended for privacy.
#REF means your formula references a cell that no longer exists. This usually happens after deleting rows. Simply rewrite the formula with the correct range.