How to Use the HooBuy Spreadsheet
The HooBuy spreadsheet is a powerful tool when you know how to use it. This step-by-step guide walks you through the basics of searching, filtering, and reading the spreadsheet so you can find what you need quickly and efficiently. Whether you are looking for a specific batch or browsing a category, these tips will save you time and help you make better buying decisions.
Understanding the Layout
The spreadsheet is organized by category with columns for item name, price, batch code, seller, link, and notes. Each row represents a single item. The batch code column is the most important — it tells you which version of the item you are looking at. The notes column contains practical advice from the community about sizing, quality, and common issues.
Using Filters Effectively
Use the category filter to narrow down the type of item you are looking for. Use the price filter to find items within your budget. Use the batch code filter to find specific quality tiers. Most spreadsheet viewers support these filters through the Data menu. Filtering by category first is the fastest way to reduce the dataset to a manageable size.
Reading the Notes Column
The notes column contains important information about the item, including sizing advice, material details, and common issues. Read this column carefully before deciding on an item. It often contains the most practical information for buyers. Notes like "runs small" or "print cracks easily" are community-sourced warnings that can save you from disappointment.
Searching by Keywords
Use the search function (Ctrl+F) to find specific items by name, brand, or batch code. Search by brand name to find all items from that brand. Search by batch code to find all items from a specific quality tier. This is the fastest way to navigate the catalog. For example, searching "LJR" will show all items with that batch code.
Batch Code Guide: What the Codes Mean
Closest to retail quality. Higher price. Best materials and construction. Recommended for items you wear frequently.
Good balance of quality and price. Minor flaws visible on close inspection. Best for casual wear and experimentation.
Lowest price. Visible flaws. Good for beaters or items you do not plan to keep long-term. Best for testing the process.
Checking the Latest Updates
The spreadsheet is updated regularly. Check the version date to make sure you are using the latest version. New items are usually added at the bottom of each category. Check the community for announcements about major updates. Outdated links can lead to dead product pages, so always verify the link works before ordering.
Bookmarking Your Finds
Use the spreadsheet's built-in features or your browser bookmarks to save items you are interested in. The catalog changes frequently, and items can be removed or updated. Saving your finds helps you keep track of what you want to buy. Some buyers create their own wishlist spreadsheet to organize their planned purchases.
Cross-Referencing with Reviews
Once you find an item, search the community for reviews of that batch or seller. Real buyer feedback is more reliable than the spreadsheet description. Look for recent reviews with photos and detailed comments. The buyer reviews guide explains how to read between the lines of community feedback.
Pro Tips for Power Users
- Sort by price to find hidden gems in the budget range
- Filter by seller to find consistent quality sources
- Check the "Last Updated" column to avoid dead links
- Use multiple tabs to compare similar items side by side