Free product catalog template for Excel and CSV
A product data template with the 24 columns most shops and marketplaces ask for: identifiers, texts, prices, stock, category, image, weight and dimensions, origin and SEO fields. Collect your catalog in one file, then import it anywhere.
Download the template
Every column explained
| Column | Required | Imports into WISEPIM as | What goes in it |
|---|---|---|---|
SKU | Yes | SKU | Your own unique code for the product or variant. It is the key every import, update and channel uses to match rows, so never reuse one. |
Product name | Yes | Name | The product title customers see. Put the brand, product type and the key attribute first. |
Brand | Brand | The brand or manufacturer name. Google and most marketplaces require it for new products. | |
EAN | EAN | The 13-digit barcode number (GTIN). Marketplaces and Google use it to identify the product. The examples use the 200 prefix, which is for internal use only. | |
MPN | MPN | The manufacturer part number. Feeds ask for it when a product has no GTIN. | |
Short description | Short description | One or two sentences for listings and product cards. | |
Description | Description | The full product description. Plain text or simple HTML both import. | |
Price | Yes | Price | Selling price including VAT, without a currency sign. Use a dot as the decimal separator in the CSV. |
Sale price | Sale price | A temporary lower price. Leave it empty when the product is not on sale. | |
Cost price | Cost price | What the product costs you, excluding VAT. Used for margin reports, never shown to customers. | |
Stock quantity | Stock | Units available to sell. | |
Category | Categories | Your category path with > between levels, such as Home > Kitchen > Mugs. WISEPIM creates the missing levels. Separate two categories with a comma. | |
Image URL | Main image | A public link to the main product photo (https://...). WISEPIM downloads it on import. | |
Weight | Weight | Product weight as a number, in the unit of the next column. Carriers and feeds use it for shipping costs. | |
Weight unit | Weight unit | kg, g, lb or oz. | |
Length | Length | Length of the product or its package as a number, in the dimension unit. | |
Width | Width | Width as a number, in the dimension unit. | |
Height | Height | Height as a number, in the dimension unit. | |
Dimension unit | Dimension unit | cm, mm, m or in. | |
Color | Color | The color as customers would name it. Feeds need it for clothing and multi-color products. | |
Country of origin | Country of origin | Two-letter ISO country code of where the product was made, such as NL or PT. Customs and some marketplaces ask for it. | |
HS code | HS code | The 6-digit Harmonized System code for customs, such as 610910 for cotton T-shirts. Needed for shipping outside the EU. | |
Meta title | Meta title | The title search engines show, up to about 60 characters. | |
Meta description | Meta description | The snippet under the title in search results, about 140 to 160 characters. |
How to use the template
- 1
Download and open
Take the Excel file to work in a spreadsheet with live formulas, or the CSV to import the file somewhere else.
- 2
Replace the example rows
Keep the header row as it is. Add one row per product or variant and give each a unique SKU.
- 3
Import or share
Save as .xlsx or .csv (UTF-8) and import it into WISEPIM, your shop or a marketplace, or send it to your team.
Import it into WISEPIM
The headers are the ones the WISEPIM CSV import recognizes in English, Dutch, German and French. Upload the file and the columns map themselves; you check the mapping before anything is imported.
More free templates
A template holds your catalog. WISEPIM keeps it right everywhere.
Import any of these files into WISEPIM and the columns map themselves. Then enrich, translate and check your products, and publish them to your shops, marketplaces and feeds from one place.
Related free tools
See all toolsFrequently asked questions
What is a product catalog template?
A spreadsheet with one row per product and one column per product attribute, so every product is described the same way. It is the file you collect supplier data in, share with a marketplace, or import into a shop or a PIM.
Which columns are required?
SKU, product name and price are the minimum for a shop. Marketplaces and Google also want a brand and a GTIN (EAN) for new branded products, and an image. Shipping outside the EU needs the HS code and country of origin.
How do I get this catalog into Shopify or WooCommerce?
Their importers expect their own column names. Use the Shopify or WooCommerce template on the templates page, or import this file into WISEPIM, which maps the columns and publishes to the connected shops for you.
Does the file import into WISEPIM without mapping?
Every header in the template is one the WISEPIM CSV import maps automatically, in English, Dutch, German and French. You see the suggested mapping before anything is imported and can change it, for example to send a column to your own attribute.
Powerful, but easy to use
Do this for every product, automatically
- No credit card
- Free to start
- Setup in minutes