EStore Tools

Shopify Metafields CSV Builder

Turn plain columns into Shopify's metafield CSV header format, with type checking.

Describe the result you need. AI will set up the tool and ask for any missing details.

Configure with AI

Enter to submit · Shift + Enter for a new line

Sent to AI. Leave out passwords and private customer data.

Drop a sheet with a Handle column and one column per metafield here or browse files

CSV up to 25 MB. It's read in your browser and never uploaded.

How it works

Shopify reads metafield values from columns named like Material (product.metafields.custom.material). Most spreadsheets don't have headers in that format, so this tool builds them for you.

  1. 01

    Upload a sheet with a Handle column

    Plus one plain column per metafield, named however you like ("Material", "Warranty years"...).

  2. 02

    Describe each metafield

    One line per metafield: Column name = namespace.key : type, for example Material = custom.material : single_line_text_field.

  3. 03

    Download the result

    Each matched column is renamed to Shopify's format, and every value is checked against its type.

TypeValid values
booleantrue or false, exactly
number_integerA whole number, like 12
number_decimalA number, like 12.5
date2026-09-30 (ISO 8601)
date_time2026-09-30T14:30:00
urlStarts with https://, http://, mailto:, sms: or tel:
jsonValid JSON
list.*Several values, saved as a JSON array

Importing the result

Every metafield must already exist under Settings → Custom data → Products before you import values for it. Shopify won't create a new metafield definition from a CSV column alone.

Import the file at Products → Import with "Overwrite products with matching handles" checked, since the file only carries Handle and your metafield columns.

Questions people ask

What if I don't know the metafield's type?

Check Settings → Custom data → Products in your Shopify admin. Each metafield definition lists its type.

How do list metafields work?

Enter values separated by commas or semicolons in the sheet; the tool converts them into the JSON array Shopify expects, like ["S","M","L"].

Can I build more than one metafield at once?

Yes, add one line per metafield in the box. Each becomes its own output column.

What happens to blank cells?

They're left blank in the output and skipped by the type check, so existing values won't be touched for products missing that data.

Related tools

Shopify CSV ValidatorCheck a Shopify product CSV for import errors before you upload it, and download a cleaned-up copy.Shopify Bulk Tag EditorAdd, remove or rename tags across your whole catalog by rule.Supplier Sheet to Shopify CSV MapperTurn a supplier's product spreadsheet into a file Shopify can import.Shopify Inventory CSV BuilderTurn a supplier's SKU and quantity list into Shopify's per-location inventory CSV.

Want this builtinto your store?

I'm Emmanuel, a Shopify and WooCommerce developer. If this tool pointed at something you'd rather have fixed for you (a faster store, cleaner product data, a migration, a custom feature), send me a note.

Emmanuel Asika

Emmanuel Asika

Shopify & WooCommerce developer, Dublin

I build and fix online stores: new builds, migrations, speed, SEO and the custom bits apps can't do.

hello@emmanuelasika.com
See my work

Last reviewed 30 September 2026.

Sources: Shopify Help Center: Using CSV files to import and export products · Shopify dev docs: metafield data types