Download the CSV template from Seller Center, fill one row per product in Google Sheets, upload the file. Manual listing takes 3-5 min per item; CSV takes 1-2 min per item plus 5 minutes to upload.
Quick Answer
A CSV bulk upload lets you list 20, 50, or 100 products on Shopee or Lazada in one go instead of creating each listing manually. Download a template spreadsheet from Seller Center, fill in one row per product, and upload the file. For 30 items, you save roughly an hour compared to manual listing.
Bulk uploading via CSV cuts your Shopee and Lazada listing time by 50-60% — that is roughly an hour saved per batch of 30 items. Instead of clicking through the Seller Center product form 3-5 minutes per item, you fill one row per product in a spreadsheet template and upload the file. The platform reads 30 rows and creates 30 listings automatically. According to a 2025 Lazada Seller Education survey, sellers who use bulk uploads list products at more than double the rate of manual listers. The process: download the template from Seller Center, fill in your product data (title, description, price, category, photos), save as XLSX, and upload.
Key Takeaways
- CSV stands for Comma-Separated Values — a plain spreadsheet format that Shopee and Lazada use for bulk product uploads. Sellers who use bulk uploads list at more than double the rate of manual listers.
- Always download a fresh template from Seller Center before each upload. Column names change when platforms update.
- Manual listing: 3-5 minutes per item. CSV bulk upload: 1-2 minutes per item in the spreadsheet, plus 5 minutes to upload. For 30 items, you save roughly an hour per batch.
- Images are the trickiest part. Shopee sometimes matches images by SKU. Lazada requires publicly accessible image URLs.
- Keep your filled-in spreadsheet as a product database. Add columns for date listed, platform, and sold status to track inventory across platforms.
What Is a CSV File and Why Do Platforms Use It?
CSV stands for Comma-Separated Values — a plain spreadsheet format where rows and columns are saved as a simple text file. Think of it as a stripped-down version of Excel or Google Sheets. Shopee and Lazada both use CSV or XLSX templates you download, fill in, and re-upload. Google Sheets (free) works perfectly for this. So does Excel or WPS Office on your phone.
Why CSV? Because it lets the platform create many listings from a single file. Instead of you clicking through a product creation form 30 times, the platform reads 30 rows and creates 30 listings automatically. One file, many listings — that is the whole point.
How Do You Download the Bulk Upload Template?
Download a fresh template from Seller Center every time you upload. Old templates cause validation errors because column names change when platforms update their systems — based on seller reports in Facebook groups, outdated templates are the single most common reason for failed uploads.
For Shopee: Log in to Shopee Seller Centre (seller.shopee.ph) on desktop — bulk upload is not available on the mobile app. Go to "My Products," click "Mass Upload" or "Batch Add," select your product category first, then download the template. Heads up: Shopee gives different templates per category — clothing has different columns than electronics, so make sure you pick the right one.
For Lazada: Log in to Lazada Seller Center (sellercenter.lazada.com.ph). Go to "Products," then "Add Products," then "Bulk Upload." Select your category and download the template.
What Columns Are in the Template and What Do They Mean?
A typical Shopee or Lazada clothing template has 8-10 columns: product name, description, category, price, stock, weight, images, brand, and size/color attributes. Here is what each one expects:
| Column | Shopee | Lazada | Notes |
|---|---|---|---|
| Product Name | Max 120 characters | Required | Use keyword-rich titles |
| Description | Required | Short + Long description | Paste from master info block |
| Category | Often pre-filled | Required | Must match template category |
| Price | Number only, no "P" | Price + optional Sale Price | Just the number — P350 becomes 350 |
| Stock | Required (usually 1 for secondhand) | "Quantity" | Always 1 for one-of-a-kind items |
| Weight | Grams (needed for shipping calc) | Package Weight + Dimensions | T-shirt: 150-200g. Jeans: 400-600g. Jacket: 500-800g |
| Images | File names or URLs | Must be publicly accessible URLs | Test every URL in a browser first |
| Brand | Optional but helps search | Required for some categories | Use actual brand name |
| Size/Color | Structured attributes | Color Family, Size | Match platform's dropdown options exactly |
The most confusing columns for first-time uploaders? Images and Category. Images because each platform handles them differently (more on that below). Category because if the code does not match the template you downloaded, the entire row fails — and the error message will not always tell you why.
How Do You Fill In the Spreadsheet Efficiently?
Use copy-paste patterns and fill-down formulas to replicate data across rows — that is how spreadsheets save you 50-60% of the time compared to web forms. Enter a value once, drag it down for every item that shares it.
Product names: Write keyword-rich titles. "Vintage Levi's 501 Jeans Men Straight Fit Blue Denim Preloved Size 32" beats "Levi's Jeans." Shopee caps titles at 120 characters — count before uploading. Pro tip: keep a running list of effective keywords for your niche in a separate sheet.
Price: Just the number. No "P" or "PHP" prefix. No commas for thousands. So P1,500 becomes just 1500 in the cell.
Stock: Always 1 for one-of-a-kind secondhand items. If you have multiple units of the same item, set stock accordingly.
Weight: Estimate in grams. Common reference weights for clothing:
- T-shirt: 150-200g
- Polo shirt: 200-300g
- Jeans: 400-600g
- Jacket: 500-800g
- Shoes (pair): 600-1000g
This affects shipping cost calculations. Underestimating weight means you absorb the difference — and at P20-50 per underestimated item, that adds up fast across a 30-item batch.
Images: This is the trickiest part of the whole process. Shopee sometimes lets you match images by SKU name after upload. Lazada requires image URLs — photos must be hosted somewhere publicly accessible. Some sellers use Imgur or Google Drive with sharing set to "Anyone with the link." Read the template's instructions tab carefully — each platform handles images differently, and broken image links are one of the top 3 upload errors.
How Do You Upload the Completed File?
Save your Google Sheet as XLSX (File > Download > Microsoft Excel), then upload it to Seller Center. Important: do not save as CSV if the template was XLSX — platforms reject mismatched formats, and this trips up a surprising number of sellers.
Once you upload, the platform validates your file and flags errors alongside the listings that parsed correctly. Validation takes 10-30 seconds. Do not skip the preview — check the listing titles and prices before confirming, because fixing mistakes after they go live is more hassle than catching them here.
Step-by-step for Shopee:
- Go to Seller Centre > My Products > Mass Upload
- Click "Upload File" and select your XLSX
- Wait for validation (that only takes 10-30 seconds)
- Review the error report — fix any flagged rows
- Confirm to create all valid listings
Step-by-step for Lazada:
- Go to Seller Center > Products > Bulk Upload
- Upload your filled template
- Review the validation results
- Fix errors and re-upload if needed — you only re-upload the broken rows, not the whole file
- Confirm to publish
What Are the Most Common Bulk Upload Errors and How Do You Fix Them?
Five errors account for the vast majority of failed bulk uploads, based on what sellers consistently report in Facebook groups and Shopee/Lazada seller forums:
| Error | Cause | Fix |
|---|---|---|
| "Invalid category" | Wrong template or mismatched category codes | Re-download the correct category template |
| "Product name too long" | Shopee caps at 120 characters | Cut filler words like "Brand New Quality" |
| "Image not found" / "Invalid image URL" | Image links are private or broken | Test every URL in a browser — if it does not load for you, it will not load for the platform |
| "Required field missing" | Weight and stock commonly forgotten | Check every required column has a value in every row |
| "Duplicate SKU" | Same SKU used for two items | Use a unique system: your initials + date + item number (e.g., "JD-0218-001") |
Pre-upload checklist (run through this before every upload to catch errors early):
- Did you download a fresh template for the correct category?
- Does every row have all required fields filled — no blank cells in required columns?
- Are all prices numbers only (no "P" or commas)?
- Is weight filled in grams for every item?
- Do all image URLs load when you paste them in a browser?
- Are all SKUs unique across the file?
- Is the file saved as XLSX (not CSV, unless the platform specifically asked for CSV)?
How Much Time Does CSV Bulk Upload Actually Save?
CSV bulk upload saves roughly 50-60% of your listing time. Here is the honest math, based on average listing times sellers report:
| Method | Time per item | 30 items | 50 items |
|---|---|---|---|
| Manual listing (Shopee/Lazada) | 3-5 min | 90-150 min | 150-250 min |
| CSV bulk upload (spreadsheet) | 1-2 min + 5 min upload | 35-65 min | 55-105 min |
| CSV via Oonch export | ~30 sec review + 5 min upload | ~20 min | ~30 min |
You save roughly an hour per batch of 30 items with the manual spreadsheet method. Over a month of weekly batches, that is 4+ hours back — enough time to source more inventory or actually rest. Even without any tools, the spreadsheet method beats posting one by one every single time.
How Should You Organize Your Master Spreadsheet?
Do not discard your filled-in template after uploading — save a copy as your product database. This becomes your single source of truth for everything you have listed, and it pays off the moment you need to cross-post or reprice.
Add these columns for tracking:
| Column to add | Purpose |
|---|---|
| Date Listed | Know when each item went live |
| Platform | Track which platforms have the listing |
| Sold Y/N | Inventory management |
| Date Sold | Track sell-through speed |
| Buyer / Order # | Reference for disputes or returns |
When you need to relist unsold items, update prices, or cross-post to another platform, everything is already in one place. Spreadsheets are not glamorous, but for sellers doing volume, they are the backbone of the operation.
Related Reading
Frequently Asked Questions
Can I use Google Sheets instead of Excel for Shopee and Lazada bulk uploads?
Yes. Create your spreadsheet in Google Sheets, then download it as XLSX (File > Download > Microsoft Excel) before uploading to Seller Center. Do not upload a Google Sheets link directly — both platforms require the actual file, not a shared link. Google Sheets is free and works on any device with a browser.
Do I need a laptop for CSV bulk upload, or can I do it on my phone?
A laptop or desktop is strongly recommended — you cannot do Shopee's Mass Upload on mobile at all, since the feature only appears on the desktop version of Seller Centre. Lazada's bulk upload also works best on desktop. You can edit spreadsheets on a phone, but it gets slow and error-prone once you go past 20 rows of data.
What happens if some rows in my CSV have errors and others are valid?
Both Shopee and Lazada show a validation report after upload. Valid rows can usually be published immediately while you fix and re-upload only the rows with errors. You do not need to start over from scratch — just correct the flagged items and upload those separately.
How do I handle images for Lazada's bulk upload when they require URLs?
Upload your product photos to a free hosting service like Imgur or Google Drive (set sharing to "Anyone with the link"), then paste the direct image URL into the template. Test every link in your browser before uploading — if the image does not load for you, Lazada will reject it too.
Can I update existing listings using CSV, or is it only for new products?
Both Shopee and Lazada support bulk editing of existing listings through CSV. Download your current product data as a spreadsheet, make changes (prices, descriptions, stock), and re-upload. This is especially useful for batch price drops on items that have been sitting for 2-3 weeks without a sale.
What is the maximum number of products I can upload in one CSV file?
Shopee allows up to 1,000 products per bulk upload file (as of February 2026). Lazada's limit varies but generally supports several hundred per file. For most secondhand sellers doing 20-100 items per batch, you will not hit either platform's limit.
Why does my bulk upload keep failing even though I filled in all the fields?
The most common hidden cause is using an outdated template. Shopee and Lazada update their required fields and column names without much notice. Always download a fresh template from Seller Center before each upload session — even if your last upload was just a week ago. Other frequent causes include invisible extra spaces in cells, wrong file format (CSV instead of XLSX), and category code mismatches.
How do I avoid retyping the same product details in every batch upload?
Create a master template with defaults pre-filled — stock at 1, your common category codes, and weight ranges by garment type. For each new batch, duplicate the master and only fill what changes: product name, measurements, price, and photos. This cuts per-item prep to about 60-90 seconds because you are editing defaults rather than filling empty cells.
Is Shopee's bulk upload process different from Lazada's?
Yes, in three key ways. Shopee gives different templates per category (clothing and electronics have different columns), while Lazada uses a more standardized format. Shopee sometimes lets you match images by SKU filename after upload, while Lazada requires publicly accessible image URLs pasted directly into the spreadsheet. Both platforms require desktop — Shopee's Mass Upload does not appear on mobile at all.