How Ecommerce Teams Turn Excel Product Sheets Into Filterable HTML Catalogs
Publish catalog spreadsheets as searchable web tables.
Ecommerce merchandising teams usually maintain product feeds in Excel with SKU-level detail. The problem starts when that same file needs to be readable on category pages or campaign landing pages.
Before: product updates are sent as exports, copied into CMS blocks, and reformatted every week.
After: one spreadsheet is converted to a web table where customers can sort by price, filter by category, and compare availability without leaving the page.
Main friction point: Catalog updates break when multiple teams edit copies and publish partial versions.
Create Your First TableA concrete example
A store with 2,000 SKUs keeps one sheet per season. The team filters to Spring items, updates pricing in bulk, reimports the file, and the website table reflects those changes without manual row edits.
Example spreadsheet for this post: Download Example Sheet
| SKU | Product name | Category |
|---|
| EC-1001 | Aster Running Shoe | Footwear |
| EC-1002 | Aster Running Shoe | Footwear |
| EC-1100 | Cove Hoodie | Apparel |
| EC-1188 | Summit Bottle 1L | Accessories |
| EC-1301 | Trail Cap | Apparel |
| Price | Stock status | Brand | Variant |
Powered by TableMaker |
|---|
| 79.99 | In stock | Aster | Blue / 9 | |
| 79.99 | Low stock | Aster | Black / 10 | |
| 49.00 | In stock | Cove | Grey / M | |
| 24.50 | In stock | Summit | Steel | |
| 22.00 | Out of stock | Aster | Navy |
Why a web table works better for this use case
A web table is easier to use when people need to:
•
Buyers can filter and compare products faster.
•
Merch teams can publish from the same source file each week.
•
Product discovery improves on long catalog pages.
What this usually looks like in the spreadsheet
A typical spreadsheet for this workflow might include:
•
SKU
•
Product name
•
Category
•
Price
•
Stock status
•
Brand
•
Variant
A practical way to publish it
1
Upload the product source sheet
- Use the file your team already uses for SKU updates.
- Keep consistent headers so imports stay predictable.
2
Configure shopper-facing behavior
- Enable sorting on price and rating columns.
- Add filters for category, brand, and stock status.
3
Embed on your catalog page
- Place the embed snippet in your CMS block.
- Reimport when merchandising updates arrive.
Final thoughts
If you already have the spreadsheet, start with that file and publish one table for your next stakeholder review.
Create Your First Table