Splitting a Multi-Tab Product Catalog for E-commerce
- E-commerce sellers often keep master product catalogs in Excel with a tab per category — apparel, accessories, home goods, etc.
- Platform imports (Shopify, WooCommerce, Etsy, Amazon) typically want one CSV per category or one per SKU type. Splitting by tab is the first step.
- Our free tool splits the workbook in-browser — no uploading your product catalog (and pricing) to random online tools.
Table of Contents
E-commerce sellers with more than a handful of products usually end up maintaining a master product catalog in Excel — one tab per product category, per supplier, or per brand. When it's time to import into Shopify, WooCommerce, Etsy, Amazon Seller Central, or any bulk-upload system, you typically need one CSV per category because the platforms treat each import as "all products in this batch have the same required attributes." A master file needs to be split first.
Our free sheet splitter splits the master workbook into per-category files in 30 seconds — without uploading your product data (including pricing, margins, supplier info) to any third party.
Why Sellers Keep Master Catalog Files
- One source of truth across Shopify, Etsy, Amazon, eBay, and wholesale channels. Update price in the master, re-split, re-upload.
- Supplier negotiation and margin analysis benefit from seeing the full catalog together.
- Seasonal planning — spring, summer, fall, winter as tabs to plan inventory across the year.
- SKU consistency — numbering conventions are easier to maintain in one file.
- Disaster recovery — one Excel master is easier to back up than six platform exports.
Platform-Specific Import Requirements
Each platform has its own "ready to import" format. Splitting the master by category is step one; formatting for the platform is step two.
| Platform | Required format | Per-file rule |
|---|---|---|
| Shopify | CSV | Often one CSV per collection/category |
| WooCommerce | CSV (or WP All Import XML) | One CSV per category for cleanest mapping |
| Etsy | No bulk upload on free tier; Sale Samurai or eRank for bulk | Varies by tool |
| Amazon Seller Central | Flat File templates (.xlsx or .txt) | One per product type / category |
| eBay | CSV or File Exchange | One per listing batch |
| BigCommerce | CSV | Per product type preferred |
Splitting your master by tab gives you one file per category. Then you rename columns and format for the specific platform template.
Sell Custom Apparel — We Handle Printing & Free ShippingA Realistic Seller Workflow
- Master catalog in Excel. Tabs: "Apparel," "Accessories," "Home Decor," "Kitchen," etc.
- Update prices, SKUs, inventory in the master. This is the source of truth.
- Drop the master into the sheet splitter.
- Click "Download All as CSVs." Each category tab becomes a separate CSV.
- In each category CSV: rename headers to match the destination platform (Shopify wants "Handle, Title, Vendor..."), clean any platform-forbidden characters, verify image URLs.
- Import per category via the platform's bulk-upload interface.
For small catalogs (under 500 SKUs total), this workflow takes 15-30 minutes. Large catalogs (10K+ SKUs) benefit from scripting (Python pandas) for the rename/clean step, but the initial split is still fastest with the browser tool.
Why Product-Catalog Privacy Matters
Your catalog file contains competitive intel: exact SKU list, cost vs. retail pricing, supplier names, margin analysis, discontinuation plans. Leaking this to a competitor via a breach is a real business risk.
Uploading to a random "split Excel online" website puts this data on someone else's server. Even if the service is legitimate, they're now a data processor you've engaged without a contract. A breach at that vendor = your catalog in the wild.
A browser tool that processes entirely locally eliminates the concern. The catalog never leaves your laptop.
Seasonal Catalog Updates
E-commerce has rhythm: holiday prep, BFCM catalog swap, spring refresh, summer seasonal, back-to-school. Each transition means bulk price changes, new category additions, discontinuations. A repeatable split-and-import workflow turns what used to be "two-day operation" into "two-hour operation":
- Morning: update the master with seasonal changes.
- 10 min: split the master into per-category CSVs.
- 30-60 min per platform: clean CSV headers, upload.
- Afternoon: verify uploads, spot-check pricing live on-site.
Build this workflow once, run it every season.
Split Your Catalog in 30 Seconds
Supplier pricing, margin, SKUs — all stay on your computer. No third party sees your catalog.
Open Free Sheet SplitterFrequently Asked Questions
Can I split by column value (e.g., one file per brand within a category)?
Not with this tool. It splits by tab, not by column value. For "one file per brand" style splits, you'd need Python pandas or Power Query. Workaround: make each brand its own tab in your master file, then split by tab.
Will image URLs survive the split?
Yes — CSV output preserves all cell values including URLs. Formatting is lost but text content (including long URLs) is intact.
What about variants (sizes, colors)?
If your master tracks variants as separate rows within each category tab, they flow through to the category CSV intact. Re-format for your platform's variant structure afterward.
Is Shopify's bulk import OK with file size?
Shopify accepts CSVs up to ~1 million rows. For larger catalogs, you'll split further by sub-category or process in batches. The splitter handles thousand-SKU tabs easily.
What about multichannel inventory sync tools (Cin7, Linnworks)?
Most inventory-sync tools accept bulk imports too. Same flow: split master by category, then feed each CSV to the sync tool.
