How to Use Rizzitgo Spreadsheet Step-by-Step

Learning how to use a rizzitgo spreadsheet is one of the highest-ROI skills you can develop as an online fashion shopper. In this step-by-step tutorial, we break down every feature, formula, and workflow so you can track orders like a seasoned pro within the hour.

What You Will Need Before Starting

• A free Google account (for Google Sheets)
• A list of your recent purchases from OOCBuy or similar marketplaces
• 10–15 minutes of uninterrupted time
• A basic understanding of how spreadsheets work (copy, paste, type in cells)

Step 1: Create Your Master Sheet

Open Google Sheets and start a new blank spreadsheet. The title should be descriptive — something like Rizzitgo Tracker 2026 — so you can find it quickly in your Drive. This single sheet will become your command center for every fashion purchase you make this year.

Step 2: Build the Column Structure

The power of the rizzitgo spreadsheet lies in its column design. Each column captures a specific data point that, when combined, gives you a complete picture of every transaction. Here is the proven column layout used by thousands of trackers:

1. 1A: Date — the day you placed the order
2. 2B: Item Name — be specific, include brand and model
3. 3C: Category — Shoes, Hoodies, T-Shirts, etc.
4. 4D: Seller — store name or username
5. 5E: Purchase Price — what you actually paid
6. 6F: Shipping Cost — do not skip this; it affects total cost
7. 7G: Total — formula: =E2+F2
8. 8H: Status — Ordered, Shipped, Delivered, Issue
9. 9I: Quality Rating — 1 to 10 scale after delivery
10. 10J: Resale Value — estimated current market price
11. 11K: Profit/Loss — formula: =J2-G2
12. 12L: Notes — links, impressions, issues

Step 3: Apply Conditional Formatting

Conditional formatting turns your raw data into an at-a-glance dashboard. In Google Sheets, select the Status column, then go to Format → Conditional formatting. Set rules like: text contains Delivered → green fill; text contains Shipped → yellow fill; text contains Issue → red fill. This transforms your sheet into a visual tracker that tells a story without reading a single word.

Step 4: Add Dropdown Lists for Consistency

Data consistency is everything. If you type Hoodie in one row and hoodies in another, your filter will break. Select the Category column, go to Data → Data validation, and enter your category list: Shoes, Hoodies/Sweaters, T-Shirts, Jackets, Pants/Shorts, Headwear, Sets, Underwear, Jersey, Accessories. Do the same for Status. Now every entry is clean and filterable.

Step 5: Create Summary Tabs

Advanced users create separate tabs for different views. Add a tab called Monthly Summary and use SUMIF formulas to calculate total spending per month. Add a tab called Category Breakdown to see where your money goes. These summaries turn your tracker into a personal analytics dashboard.

Troubleshooting Common Issues

• Formula errors: Make sure you are referencing the correct cell letters.
• Slow loading: If your sheet has 500+ rows, consider archiving old data to a separate tab.
• Mobile editing: Use the Google Sheets app, not the browser, for smoother phone entry.
• Lost data: Enable offline mode in Google Sheets settings so changes save even without WiFi.

Conclusion

You now have a complete step-by-step understanding of how to use the rizzitgo spreadsheet. The real learning happens when you start logging real data. Open your sheet, log your first three purchases, and watch how quickly the patterns emerge.