Mapping Tables: Bulk-Map Values

A mapping table is a table you fill in yourself to convert many source values at once, like mapping your own category names onto the Google product taxonomy. Seed the keys from your feed, fill in the targets, and a lookup reads from it.

Updated November 6, 2026

A mapping table converts many source values into the right ones at once, such as your own category names into Google's product taxonomy. Create one from a catalog's Data sources tab, seed its keys from your feed's real values, fill in the target for each, and point a lookup at it.

Key columns hold the values you're mapping from, usually taken from your feed. Value columns hold what each one becomes.

Create a mapping table#

  1. Open the catalog and go to the Data sources tab.
  2. Click + Add auxiliary feed and choose Mapping table.
  3. The grid opens. Give the table a name in the header, then seed its keys and fill in the values as below.

Seed the keys from your catalog#

Seed the keys from your feed, so the table matches your real values. Open the key column's menu and pick a column under Seed keys from, and the empty table fills with that column's values. A caption under the header says where the keys come from. When your feed changes, click Re-seed from catalog in the header to bring the key list up to your current feed. Rows you've already filled in stay as they are.

The Products column shows how many products carry each value. The grid sorts by it, so you can map the most-used values first.

Fill in the target values#

Each value column has a type, shown as a badge you can change:

  • Text cells take any value: a code, a label, a corrected name.
  • Google taxonomy cells open a picker for Google's product taxonomy. Search for a category by name, or switch to Browse the tree to walk the hierarchy. You can also paste or type a value the picker doesn't show.

Paste from Excel or Google Sheets#

Already have your mappings in a spreadsheet? Copy two columns from Excel or Google Sheets, source then target, and paste them anywhere in the grid. Renable fills matching rows, adds new keys, and tells you how many it filled and added.

Keep the table current#

New values in your feed that the table doesn't cover appear as new rows: a value from the last import that a lookup couldn't match to any key. Give one a value to keep it.

Three filter pills above the grid let you focus on All rows, Unmapped keys that still have no value, or New rows. Chips in the header count how many keys are mapped, unmapped and new.

Point a lookup at the table#

A mapping table only takes effect once a lookup points at it, and the header shows how many do, such as used by 2 lookups. When you add a lookup and pick the table as its source, the dialog reads Look up from a mapping table. It matches a product value against the table's key and returns the value column you pick. From the lookup you can jump back with Edit table… to add or correct rows. See Joining another feed.

Click Done to close the grid, then Publish the catalog so your lookups use the new mappings.

Limits#

A mapping table holds up to 5,000 rows, 50 columns and 2 MB of data. For anything larger, split it across more than one table or narrow the key values you seed.

Or ask Aimée#

Tell Aimée what you're mapping in the chat, such as "map my category names to the Google product taxonomy", and she can create the table, fill in rows and add the lookup, then publish once you approve.

Where to go next#