Your files never leave your device. All processing happens locally in your browser.
How do I get the correct CSV import template (right column headers and a sample row) for Shopify, Mailchimp, Google Contacts, QuickBooks or WooCommerce?
Pick your target platform — Shopify products, Mailchimp contacts, Google Contacts, QuickBooks customers, WooCommerce products, or a generic contacts/products template — and the tool shows the COMMON import columns with the exact header text, which ones are required, the type, an example and a per-column note. Preview a filled sample row, then download an EMPTY template CSV (just the headers to fill in) or a SAMPLE CSV (header + one or two example rows), or copy the headers. Need something not listed? Switch to the custom builder and add your own columns. Everything is generated in your browser with valid RFC-4180 quoting — nothing is uploaded, and it does NOT import your data. These are common starter columns, not the platform’s official file: required columns vary by version, plan, country and category and change, so always check the platform’s current import spec / sample before bulk-importing.
Each column shows required? + type + example + a note; required columns are flagged so you know the minimum
Download an EMPTY header-only template to fill in, or a SAMPLE CSV with 1–2 example rows; copy headers in one click
Custom builder: seed from any platform, then add / rename / retype / flag columns — same outputs
100% client-side (PapaParse, valid CSV quoting, BOM for Excel); HONEST — common columns, NOT the official file, verify the current spec, it does NOT import your data
What is
CSV Import Template
A CSV import template is a spreadsheet file whose first row contains the exact column headers a platform’s bulk-import expects (for example Shopify’s Handle / Title / Variant Price, Mailchimp’s Email Address, Google Contacts’ hyphenated “E-mail 1 - Value’, or WooCommerce’s SKU / Type / Regular price), so you can fill in one row per record and upload it without column-mapping errors. A good template flags which columns are required, gives an example and a note per column, and optionally includes a sample row showing the expected format — but because exact required columns differ by platform version, plan, country and category and change over time, a generated template is a starter to verify against the platform’s current official sample.
How to Generate a CSV Import Template for Shopify, Mailchimp, QuickBooks & More
Pick a target platform (or the custom builder), review the column reference and sample row, then download an empty template or a sample CSV — entirely in your browser.
2 minWeb browser
1
Pick your target
Choose Shopify products, Mailchimp contacts, Google Contacts, QuickBooks customers, WooCommerce products or a generic contacts/products template — or the custom builder. The column reference shows each header, whether it is required, its type, an example and a note.
2
Review the columns & sample row
Check which columns are required and read the per-column notes. Preview a filled sample row (one or two) to see the expected format. In the custom builder, add / rename / retype / flag columns as needed.
3
Download or copy
Download the EMPTY template (headers only) to fill in, or the SAMPLE CSV (header + example rows) to edit, or copy the headers. Then verify the columns against the platform’s current import spec and upload through its own import screen.
Result:A platform-shaped CSV import template (empty or with a sample row) to fill in and upload
Frequently Asked Questions
No. It generates a starter template with the COMMON columns for each platform, not the platform’s official downloadable sample. Always check the platform’s current import spec before bulk-importing.
The tool builds a starter import template with the columns most platforms commonly expect — with the exact header text — but it is NOT the platform’s official downloadable file. The exact required columns vary by platform version, plan, country and category and change often, so always verify against the platform’s current import spec or sample before a bulk import: download a product export from Shopify admin, follow Mailchimp’s import-format guidelines (where extra columns map to your audience’s own merge fields), export a Google CSV from Google Contacts (its headers are exact and hyphen/space-sensitive, like “E-mail 1 - Value”), use the in-product QuickBooks import sample (fields differ between Online and Desktop), or follow the WooCommerce Product CSV Import Schema. Treat this as a fast head-start, then copy headers from their official sample if anything is unclear.
The empty template is just the header row to fill in. The sample CSV adds one or two example rows that show the expected format, which you then replace with your data.
Two downloads are offered. The EMPTY template CSV contains only the header row — the exact column names — so you can open it in a spreadsheet and start entering one row per record. The SAMPLE CSV contains the same header plus one or two example rows (an Ada Lovelace contact, a Classic Tee product, etc.) so you can see the expected format for each column — prices without currency symbols, comma-separated tags inside a quoted cell, the right boolean values — before replacing the examples with your real data. You can also copy just the headers in one click to paste into an existing sheet. Both files are written with valid RFC-4180 quoting and saved as UTF-8 with a BOM so Excel reads accented column names correctly.
No. It only creates the empty template for you to fill in. The template and CSV are built entirely in your browser; nothing is uploaded and it never touches your real data.
This is a template GENERATOR, not an importer. It produces the empty header template (and an optional sample row) that you then fill in yourself and upload to the platform through that platform’s own import screen. The tool does not read, hold, transmit or import any of your real records — the templates, notes and CSV are generated on your device with PapaParse, with no upload, no server, no CDN and no tracking, and the page works offline once cached. Because the column names must match the platform exactly, copy the headers from the platform’s official sample if you are unsure, and always confirm the required columns against its current import spec before bulk-importing.
Yes — switch to the custom builder, optionally seed it from a similar platform, then add, rename, retype and flag your own columns. It produces the same template and sample CSV.
The custom builder lets you define any template column by column: type the exact header name, choose a type (text, number, yes/no, date, email, phone, URL or list), give an example value and tick whether it is required. You can seed it from any built-in platform to start fast and then adjust. Blank or duplicate column names are dropped, and the headers are written exactly as you type them. The custom template produces the same outputs as the built-in ones — an empty header-only CSV, a sample CSV with example rows, and one-click header copy — all generated client-side with proper CSV quoting so commas, quotes or newlines in your values do not break the file.
Detailed Explanation
📖How It Works
Import Template Generator — The Right CSV Import Template, Built in Your Browser
The Import Template Generator is a 100% client-side tool that produces a CSV IMPORT TEMPLATE — the exact column headers a platform’s bulk-import expects — for common targets and lets you build a custom one. You pick a target: Shopify products (Handle, Title, Body (HTML), Vendor, Type, Tags, Published, Option1 Name/Value, Variant SKU, Variant Inventory Qty, Variant Price, Image Src, Status), Mailchimp contacts (Email Address required, First Name, Last Name, Phone, Birthday, Tags), Google Contacts in Google CSV format (Name, Given Name, Family Name, the hyphen/space-exact "E-mail 1 - Value" and "Phone 1 - Value", Organization, Group Membership), QuickBooks customers (Customer, Company, Email, Phone, Billing Address fields), WooCommerce products (Type, SKU, Name, Published, Regular price, Stock status, Categories, Images), or a generic contacts/products template. For each, the tool shows a COLUMN REFERENCE — name, a required/optional flag, a type, an example and a per-column note — plus a preview of the template with one or two filled SAMPLE rows. You can download an EMPTY header-only template CSV to fill in, a SAMPLE CSV with example rows, or copy the headers. CSV is written with PapaParse (correct RFC-4180 quoting) and saved as UTF-8 with a BOM so Excel reads the column names correctly.
How the Per-Platform Templates and Custom Builder Work
Each built-in template is a typed registry entry: an ordered list of columns, where every column carries an exact header name, a required flag, a type (text, number, yes/no, date, email, phone, URL or list), one or two example values and a note. From that list the engine builds the empty template (a single header line via Papa.unparse) and the sample CSV (the header plus N example rows, each column contributing its i-th example). The CUSTOM builder exposes the same model: you add columns, type the exact header, pick the type, give an example and tick required — and you can SEED the builder from any built-in platform to start fast and then adjust. Blank and duplicate column names are dropped, headers are written exactly as typed, and the custom template produces the identical empty + sample outputs and header copy. Every file is generated on the device and offered as a BOM-prefixed UTF-8 CSV download; object URLs are revoked on the next download and on unmount.
Built-in templates are a typed registry: columns with name, required flag, type, example(s) and note
Empty template = header row only (Papa.unparse); sample CSV = header + 1–2 example rows from the examples
Custom builder = same model: add / rename / retype / flag columns; seed from any platform to start
Blank and duplicate headers are dropped; header text is written exactly as typed
Honest Limits: Common Columns, Not the Official File — and It Does Not Import Your Data
The tool is explicit about scope. These are the COMMON columns of each platform’s import template, NOT the platform’s official downloadable sample. The exact required columns vary by platform version, plan, country and category and CHANGE often, so the required flags are a best-effort guess and the user must verify against the platform’s CURRENT import spec / sample before bulk-importing — a Shopify product export, Mailchimp’s import-format guidelines (where extra columns map to the audience’s own merge fields), a Google Contacts export (whose headers are exact and hyphen/space-sensitive), the in-product QuickBooks import sample (fields differ between Online and Desktop), or the WooCommerce Product CSV Import Schema. Crucially, the tool only CREATES the template to fill in — it does NOT import the user’s data, never reads or uploads real records, and the resulting file is uploaded by the user through the platform’s own import screen. Column names must match the platform exactly, so when in doubt the user should copy headers from the platform’s official sample.
COMMON columns, NOT the platform’s official downloadable sample — a starter to verify
Required columns vary by version, plan, country and category and change — verify the current spec/sample
It creates the template to fill in; it does NOT import your data and never reads/uploads real records
Column names must match the platform exactly — copy headers from the official sample if unsure
Per-platform verification: Shopify export, Mailchimp format guide, Google CSV export, QuickBooks sample, WooCommerce schema
Getting a CSV import template: in-browser generator (AnyTool) vs hunting for / paying for templates
Capability
AnyTool
Typical alternatives
Where it runs
100% in your browser, nothing uploaded
Search blogs, sign up for a template site, or use a SaaS importer
AnyTool generates a starter import template with the common columns for each platform entirely in your browser. It is not the platform’s official file — required columns vary by version, plan, country and category and change — so always verify against the platform’s current import spec/sample, and note the tool creates the template to fill in, it does not import your data.
