Free tool

Free ecommerce templates for Excel and CSV

Spreadsheet templates for the product data work every online shop does: an inventory list, a product catalog, a wholesale price list, and import files for Shopify, WooCommerce and Google Merchant Center. Each column is explained below. Free, no account.

Inventory template

One row per product and location, with stock, reorder point, reorder quantity and unit cost. The Excel file calculates the stock value and flags what to reorder.

Excel (.xlsx)10 KB CSV561 B

Same template with headers in Dutch, German, French

The file has 4 example rows to show the format. Overwrite them with your own products.

Open the Inventory Template page

Product catalog template

24 product data columns, from SKU and EAN to HS code and SEO fields. Every header maps itself in the WISEPIM import, in four languages.

Excel (.xlsx)11 KB CSV2 KB

Same template with headers in Dutch, German, French

The file has 4 example rows to show the format. Overwrite them with your own products.

Open the Product Catalog Template page

Price list template

A wholesale price list for B2B buyers, with order unit, minimum order quantity, net price, VAT, price including VAT and recommended retail price.

Excel (.xlsx)10 KB CSV522 B

Same template with headers in Dutch, German, French

The file has 4 example rows to show the format. Overwrite them with your own products.

Open the Price List Template page

Shopify product CSV template

The full header row of Shopify's current product CSV, with a product that has variants and one without. Import it under Products > Import in your Shopify admin.

CSV2 KB

The file has 3 example rows to show the format. Overwrite them with your own products.

Every column explained

Column	Required	What goes in it
`Title`	Yes	The product name. Fill it on the first row of a product only; variant rows below leave it empty.
`URL handle`	Yes	The product's URL slug and its import key. Every row of the same product, variants included, repeats the same handle.
`Description`		The product description. HTML is allowed.
`Vendor`		The brand or supplier. Shopify uses it for filtering and as the brand in its sales channels.
`Product category`		A full path from Shopify's Standard Product Taxonomy, such as Home & Garden > Kitchen & Dining > Tableware > Drinkware > Mugs. Find the path in the Shopify taxonomy download.
`Type` Also covers: `Tags`		Type is your own free label for grouping products. Tags is a comma-separated list for search, filters and automated collections.
`Published on online store` Also covers: `Status`		TRUE or FALSE for visibility in the online store. Status is active, draft or archived; a draft is hidden everywhere.
`SKU` Also covers: `Variant Barcodes`		SKU and barcode (EAN, UPC or ISBN) per variant. Shopify accepts several barcodes in one cell, separated by semicolons.
`Option1 name` Also covers: `Option1 value`, `Option1 Linked To`, `Option2 name`, `Option2 value`, `Option2 Linked To`, `Option3 name`, `Option3 value`, `Option3 Linked To`		Up to three variant options. The name (Size) goes on the first row, the value (S, M) on every variant row. Linked To ties an option to a category metafield such as shopify.color-pattern.
`Price` Also covers: `Compare-at price`, `Cost per item`		Selling price per variant. Compare-at price is the old price shown struck through. Cost per item is your purchase cost, used for profit reports.
`Charge tax` Also covers: `Tax code`		TRUE to charge tax on the variant. Leave Tax code empty unless your tax setup uses product tax codes.
`Unit price total measure` Also covers: `Unit price total measure unit`, `Unit price base measure`, `Unit price base measure unit`		Unit pricing, required for many products in the EU: the content (350, ml) and the base it is priced per (100, ml).
`Inventory tracker` Also covers: `Inventory quantity`, `Continue selling when out of stock`		Set the tracker to shopify to track stock. Inventory quantity works for single-location stores only. DENY stops sales at zero stock, CONTINUE allows them.
`Weight value (grams)` Also covers: `Weight unit for display`		Weight always in grams, numbers only. The display unit (g, kg, lb, oz) only changes how it is shown.
`Requires shipping` Also covers: `Fulfillment service`, `Gift card`		TRUE for physical products. Fulfillment service is manual unless an app fulfills the item. Gift card is TRUE only for gift cards.
`Product image URL` Also covers: `Image position`, `Image alt text`, `Variant image URL`		Public image links. Add more images on extra rows with the same handle and the next position number. Alt text describes the image for screen readers and search.
`SEO title` Also covers: `SEO description`		The title and description search engines show. Without them Shopify uses the product title and description.
`Color (product.metafields.shopify.color-pattern)`		A category metafield. Shopify adds columns like this for the attributes of the chosen product category; the name in brackets is the metafield key.
`Google Shopping / Google product category` Also covers: `Google Shopping / Gender`, `Google Shopping / Age group`, `Google Shopping / Manufacturer part number (MPN)`, `Google Shopping / Ad group name`, `Google Shopping / Ads labels`, `Google Shopping / Condition`, `Google Shopping / Custom product`, `Google Shopping / Custom label 0`, `Google Shopping / Custom label 1`, `Google Shopping / Custom label 2`, `Google Shopping / Custom label 3`, `Google Shopping / Custom label 4`		Fields for the Google and YouTube sales channel: Google category (path or ID), gender, age group, MPN, condition and custom labels 0 to 4 for campaign grouping.
`Packed product length` Also covers: `Packed product width`, `Packed product height`, `Packed product dimension unit`		Package dimensions for shipping rates. Fill all four columns or none; the unit is cm or in.

Columns from Shopify Help Center: product CSV template, checked on 2026-10-11.

WooCommerce product CSV template

The columns of WooCommerce's built-in product importer, with a simple product, a variable product and its variations. Import it under Products > Import in WordPress.

CSV1 KB

The file has 4 example rows to show the format. Overwrite them with your own products.

Every column explained

Column	Required	What goes in it
`ID`		Leave empty for new products. Fill in an existing product ID only to update that product.
`Type`	Yes	simple, variable, variation, grouped or external. A variable product gets one row, and each variation its own row with type variation.
`SKU`		Unique per product and per variation. The importer can update existing products by SKU.
`Name`	Yes	The product name. For variations, the parent name plus the option reads best.
`Published` Also covers: `Is featured?`, `Visibility in catalog`		1 is published, 0 is private, -1 is draft. Visibility is visible, catalog, search or hidden.
`Short description` Also covers: `Description`		The short text next to the product image and the full description below it. HTML is allowed.
`Regular price` Also covers: `Sale price`, `Date sale price starts`, `Date sale price ends`		Regular price and an optional sale price, with a dot as decimal separator. The sale dates (YYYY-MM-DD) schedule the sale. A variable product's prices go on its variation rows.
`Tax status` Also covers: `Tax class`		taxable, shipping or none. Tax class is empty for the standard rate, or the name of a class such as reduced-rate.
`In stock?` Also covers: `Stock`, `Backorders allowed?`, `Sold individually?`		In stock? is 1 or 0. Fill Stock with a number to manage stock per product. Backorders allowed? is 1, 0 or notify.
`Weight (kg)` Also covers: `Length (cm)`, `Width (cm)`, `Height (cm)`, `Shipping class`		Weight and dimensions in the units in the header. They must match your store settings: change the headers to lbs and in for an imperial store.
`Categories` Also covers: `Tags`		Categories with > between levels, such as Home > Kitchen; separate several with a comma. Tags are comma-separated too.
`Images`		Public image URLs separated by commas. The first one becomes the main image.
`Parent` Also covers: `Position`		On a variation row: the SKU of the variable product it belongs to. Position sets the menu order.
`Upsells` Also covers: `Cross-sells`, `Grouped products`		Linked products, as SKUs separated by commas.
`External URL` Also covers: `Button text`, `Purchase note`, `Allow customer reviews?`		External URL and button text are for external (affiliate) products only. The purchase note is sent to the customer after an order.
`Attribute 1 name` Also covers: `Attribute 1 value(s)`, `Attribute 1 visible`, `Attribute 1 global`, `Attribute 2 name`, `Attribute 2 value(s)`, `Attribute 2 visible`, `Attribute 2 global`		Attributes such as Size. On a variable product, list all values separated by commas (S, M); on a variation, its one value. Global 1 uses a shared attribute from Products > Attributes.

Columns from WooCommerce sample_products.csv (GitHub), checked on 2026-10-11.

Connect WooCommerce to WISEPIM

Google Merchant Center feed template

A product feed as a tab-separated file, the delimited format Merchant Center accepts, with the attributes most shops need and a product with variants.

Tab-separated (.tsv)1 KB

The file has 3 example rows to show the format. Overwrite them with your own products.

Every column explained

Column	Required	What goes in it
`id`	Yes	Your unique product ID, usually the SKU. Never change it, or the product loses its history in Google.
`title` Also covers: `description`	Yes	Title up to 150 characters, with brand, product type and key attributes. Description up to 5,000 characters, plain text.
`link` Also covers: `image_link`, `additional_image_link`	Yes	The product page URL and the main image URL, both on your verified domain. Up to 10 extra images, comma-separated.
`availability`	Yes	in_stock, out_of_stock, preorder or backorder.
`price` Also covers: `sale_price`	Yes	Amount, a dot as decimal separator and the ISO currency code: 29.95 EUR. It must match the price on the product page.
`brand` Also covers: `gtin`, `mpn`, `identifier_exists`		Brand and GTIN for every new branded product; MPN when there is no GTIN. Set identifier_exists to no only when the product really has neither. Replace the example GTINs: Google rejects the 200 prefix.
`condition`		new, refurbished or used. Required for refurbished and used products.
`google_product_category` Also covers: `product_type`		Google's category ID (212 is Shirts & Tops) or full path; download the full list with IDs below. product_type is your own category path, for campaign structure.
`item_group_id` Also covers: `color`, `size`, `gender`, `age_group`		Variants share one item_group_id and differ in color or size. Clothing needs color, size, gender and age_group.
`shipping_weight`		Package weight with its unit (0.2 kg), used when your shipping rates depend on weight.

Columns from Google Merchant Center Help: product data specification, checked on 2026-10-11.

Size chart generator

Build the size table for a product page: pick a starting point, type your own measurements, and copy the HTML or download it as CSV. The starting values are examples, so measure your own products.

Start from

Unit

Table caption

	cm	cm	cm	Remove row

Preview

Size chart
Size	Chest (cm)	Waist (cm)	Length (cm)
XS	82-86	66-70	66
S	86-92	70-76	68
M	92-98	76-82	70
L	98-104	82-88	72
XL	104-110	88-94	74

HTML for your product page

<table class="size-chart">
  <caption>Size chart</caption>
  <thead>
    <tr>
      <th scope="col">Size</th>
      <th scope="col">Chest (cm)</th>
      <th scope="col">Waist (cm)</th>
      <th scope="col">Length (cm)</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th scope="row">XS</th>
      <td>82-86</td>
      <td>66-70</td>
      <td>66</td>
    </tr>
    <tr>
      <th scope="row">S</th>
      <td>86-92</td>
      <td>70-76</td>
      <td>68</td>
    </tr>
    <tr>
      <th scope="row">M</th>
      <td>92-98</td>
      <td>76-82</td>
      <td>70</td>
    </tr>
    <tr>
      <th scope="row">L</th>
      <td>98-104</td>
      <td>82-88</td>
      <td>72</td>
    </tr>
    <tr>
      <th scope="row">XL</th>
      <td>104-110</td>
      <td>88-94</td>
      <td>74</td>
    </tr>
  </tbody>
</table>

The HTML is a plain table with a size-chart class and no inline styles, so it takes your shop theme's table style. In Shopify, paste it in the description's code view or a size chart page.

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.

See the full feature Book a demo

Related free tools

See all tools

Inventory Template

Excel and CSV inventory list with reorder and stock value formulas.

Product Catalog Template

24 product data columns that import straight into WISEPIM.

Google Product Taxonomy Download

Every Google category with its ID, as CSV or JSON in 7 languages.

Frequently asked questions

Are these templates free to use?

Yes. Download them without an account and use them in your own business, for your customers or in your own tools. The Shopify, WooCommerce and Merchant Center files follow the platforms' published column names; the example rows are ours.

Should I download the Excel or the CSV file?

Take Excel (.xlsx) if you work in a spreadsheet: the formulas for stock value and prices including VAT stay live. Take CSV if you import the file into a shop, a marketplace or WISEPIM. Both files have the same columns.

Why does the CSV look wrong when I open it in Excel?

Excel in many European languages expects a semicolon, not a comma, between columns. Use Data > From Text/CSV and pick comma as the delimiter, or open the .xlsx file instead. The CSVs use a dot as decimal separator, which is what importers expect.

Can I import these templates into WISEPIM?

Yes. The headers of the inventory, product catalog and price list templates are the ones the WISEPIM CSV import recognizes, in English, Dutch, German and French, so their columns map themselves. You can still change any mapping before the import runs.

Are the Shopify columns up to date?

The Shopify template copies the header row of Shopify's own sample file, checked on 2026-10-11. Shopify renamed several columns in its newer CSV format, such as URL handle instead of Handle, so an older template can fail on import.

Powerful, but easy to use

Do this for every product, automatically

No credit card
Free to start
Setup in minutes

Book a demo

View pricing