How to Use Rizzitgo Spreadsheet Step-by-Step

Learning how to use rizzitgo spreadsheet is the fastest way to transform chaotic shopping notes into a professional tracking system. This tutorial breaks the process into six concrete steps. Follow them in order and you will have a working haul tracker before your coffee gets cold.

Step 1: Create a New Blank Spreadsheet

Open Google Sheets in your browser and click Blank. Name the file immediately so you do not lose it in a sea of untitled documents. Use a descriptive name like "Summer 2026 Haul Tracker" or "Rizzitgo Spreadsheet Main." Naming conventions matter because many buyers run multiple sheets for different seasons or friend groups.

Step 2: Build the Header Row

In row one, type the following headers across columns A through K: Item Name, Category, Seller URL, Price (CNY), Price (USD), Size, Color, QC Photo, Agent, Shipping Status, Notes. Bold the entire row and add a light gray background. Freeze row one so it stays visible as you scroll.

The two price columns let you record the original Chinese yuan price and your converted local currency. This dual-currency approach prevents surprise conversion fees at checkout.

Step 3: Add Your First Item

Find a product on a marketplace, copy the product URL, and paste it into the Seller URL column. Fill in everything you know at this stage. It is okay to leave cells blank if you do not have the data yet. The rizzitgo spreadsheet is a living document, not a final exam.

Step 4: Set Up Currency Conversion

In a blank cell at the top of your sheet, type the current exchange rate. For example, if one Chinese yuan equals 0.14 USD, enter 0.14 in cell M1. Then in the Price (USD) column, enter a formula that multiplies the CNY price by that rate. Now every row automatically shows the real cost in your local currency.

Step 5: Color-Code Your Status

Select the Shipping Status column and apply conditional formatting. Set "Wanted" to gray, "Ordered" to yellow, "Shipped" to green, and "Arrived" to blue. At a glance you will know exactly which items still need action and which are already on their way.

Step 6: Sort and Filter

Turn on filter views for the header row. Now you can sort by price to find your most expensive item, filter by category to see only shoes, or hide shipped items so you focus on what is pending. Filtering is where the rizzitgo spreadsheet becomes faster than any notes app.

Reference: Full Column Guide