The Complete Guide to HiBid CSV Imports

Why HiBid CSV Imports Matter

In short: HiBid CSV imports work by uploading a structured spreadsheet with specific columns (Lot Number, Lead, Description, estimates) alongside photos named to match each lot number. Getting the column order, character encoding, and photo naming convention exactly right is what determines whether your catalog goes live in minutes or requires hours of troubleshooting.

HiBid is one of the most popular online auction platforms in the United States. According to Technavio (2025), the global online auction market is growing at approximately 14% CAGR, making efficient catalog-to-platform workflows increasingly critical for competitive auction houses. If you're running live auctions with online bidding, chances are you're uploading catalogs to HiBid regularly. And if you've done it more than once, you know the pain of CSV formatting.

A clean CSV import saves hours of manual data entry in HiBid's interface. A broken one means re-doing work, re-uploading photos, and missing your go-live deadline. This guide covers everything you need to get it right.

HiBid CSV Column Structure

HiBid expects specific columns in a specific order. Here are the essential fields:

The Lead Field

The Lead field is arguably the most important. It's what bidders see in search results, thumbnail views, and email notifications. A good Lead is concise but specific:

• Bad: "Vase"
• OK: "Pottery Vase"
• Good: "Rookwood Pottery Vase, 1903"
• Best: "Rookwood Standard Glaze Vase, Shirayamadani, 1903"

Keep Leads under 80 characters. Include the maker/brand, key material, and date when available. Think of it as the item's headline.

The Description Field

HiBid descriptions support basic HTML formatting. Use it to improve readability:

<p>Rookwood Pottery Standard Glaze vase, shape 907C,
artist-signed by Kataro Shirayamadani, dated 1903.</p>
<p>Floral decoration with warm amber and brown tones.
Light crazing to glaze near rim.</p>
<p>Height: 8.5 inches</p>

Avoid complex HTML (tables, divs, inline styles). Stick to <p>, <br>, <b>, and <i> tags.

Photo Naming Conventions

HiBid matches photos to lots by filename. The standard convention is:

{LotNumber}_{PhotoSequence}.jpg

For example:

• 001_1.jpg -- Lot 1, primary photo
• 001_2.jpg -- Lot 1, second photo
• 001_3.jpg -- Lot 1, third photo
• 002_1.jpg -- Lot 2, primary photo

Critical rules:

• The first photo (_1) becomes the thumbnail
• Photos must be JPEG format (.jpg or .jpeg)
• File sizes should be under 5MB per photo (HiBid may reject larger files)
• Lot numbers in filenames must exactly match lot numbers in your CSV

Common Photo Naming Mistakes

1. Leading zeros mismatch: CSV says lot "1" but photos are named "001_1.jpg" -- HiBid can't match them
2. Wrong separator: Using - instead of _ (e.g., 001-1.jpg instead of 001_1.jpg)
3. Mixed case extensions: .JPG vs .jpg -- some systems are case-sensitive
4. Spaces in filenames: "Lot 1_1.jpg" -- avoid spaces entirely

Common CSV Import Errors

"Invalid column count"

Your CSV has more or fewer columns than HiBid expects. Open the file in a text editor (not Excel) and check that every row has the same number of commas.

"Duplicate lot number"

Two rows have the same lot number. Search your CSV for duplicates. This often happens when lots were split or renumbered during cataloging.

"Invalid characters in description"

Special characters (curly quotes, em dashes, accented characters) can break CSV parsing. Replace:

• " " -> " (straight quotes)
• -- -> - (regular dash)
• e, u, etc. -> standard ASCII equivalents

"Photo not found for lot"

The lot number in your CSV doesn't match any photo filenames. Check for leading zero mismatches and make sure your photo folder contains files for every lot in the CSV.

Automating the Process

Manual CSV creation is tedious and error-prone, especially at scale. When you add up the hours spent formatting spreadsheets across every sale, the real cost of manual cataloging is higher than most auctioneers expect. Here's what a good AI-powered cataloging tool handles:

1. Column mapping -- Automatically formats your data into HiBid's expected structure
2. Photo renaming -- Takes your raw photos and renames them to match HiBid's {lot}_{sequence}.jpg convention
3. Character sanitization -- Strips or replaces problematic characters before export
4. Lead generation -- Extracts a concise title from the full description
5. Validation -- Checks for duplicate lot numbers, missing photos, and format issues before you upload

With Gavelist, the entire process is one click. After AI generates your descriptions, the HiBid export produces a correctly formatted CSV and a photo folder with properly named files. Upload both to HiBid and your catalog is live. For a full walkthrough of the cataloging process from photography to export, see our estate sale cataloging guide.

Step-by-Step: Manual HiBid Upload

If you're doing it manually, here's the process:

1. Log into HiBid Auctioneer Console
2. Navigate to your auction event
3. Click Import Lots
4. Select CSV Upload
5. Upload your CSV file
6. Map any columns if prompted (HiBid usually auto-detects standard formats)
7. Review the imported lots for accuracy
8. Navigate to Photos
9. Upload your photo folder (ZIP or individual files)
10. Verify photos are matched to correct lots
11. Preview your catalog
12. Publish

Step-by-Step: Automated HiBid Upload with Gavelist

1. Create a job in Gavelist and upload your photos
2. Sort into lots (auto-detected or manual)
3. Run AI descriptions
4. Click Export -> HiBid
5. Download the CSV + photo package
6. Upload to HiBid
7. Publish

Total time: 15-20 minutes for a 500-lot catalog, versus 3-4 hours manually formatting spreadsheets and renaming photos. According to AIM (2025), manual auction cataloging runs $3–5 per lot in labor — at 500 lots, that is roughly $1,500–$2,500 in labor before CSV-formatting overhead is added.

Tips for Cleaner Imports

• Test with 5 lots first. Before uploading a 500-lot CSV, test the format with a small batch. Fix any issues before scaling up.
• Keep a template. Save a working CSV as a template so you don't have to remember column order every time.
• Backup your photos. Always keep your original, un-renamed photos. If an import goes wrong, you want to be able to start over.
• Check your lot numbering. Decide on a numbering scheme (numeric, alphanumeric, with/without leading zeros) and stick to it across the CSV and photo names.

Gavelist generates HiBid-ready CSV exports with one click -- correctly formatted columns, auto-named photos, and AI-written descriptions. Try it free at gavelist.com.

Frequently Asked Questions

What CSV format does HiBid require? HiBid accepts standard CSV files with specific columns: Lot Number, Lead (title), Description, Category, Condition, Starting Bid, Reserve, and up to 5 image references. All text fields containing commas must be wrapped in double quotes. Files should be saved as UTF-8 encoding.

How do I name photos for HiBid import? Use the format {LotNumber}_{PhotoSequence}.jpg. For example, lot 1's primary photo is 1_1.jpg, its second photo is 1_2.jpg. The first photo becomes the listing thumbnail. Lot numbers must exactly match your CSV.

What's the fastest way to create a HiBid catalog? AI cataloging tools like Gavelist generate HiBid-ready CSVs directly from your photos. Upload your estate photos, let AI generate descriptions, then export to HiBid format with one click. A 500-lot estate takes about 15-20 minutes total versus hours manually.

Why does HiBid say photo not found for my lots? The lot number in your CSV does not match the lot number in your photo filename. The most common cause is a leading zeros mismatch — your CSV says lot 1 but your photo is named 001-1.jpg. HiBid treats these as different lots.

How many photos can I upload per lot on HiBid? HiBid supports multiple photos per lot. Gavelist's HiBid export includes up to 5 image references per lot, sequenced so your best photo appears as the thumbnail.

Can I use HTML in HiBid descriptions? Yes, but keep it simple. HiBid supports basic tags like bold and italic. Avoid tables, divs, and inline styles — complex HTML may not render correctly in HiBid's listing display.

How much does it cost to automate HiBid imports? Gavelist's HiBid export is included with every plan. Pay-as-you-go pricing is $0.15 per lot with no monthly commitment.

Sources

• Technavio, "Online Auction Market Growth Analysis." technavio.com