Set up your product data in Google Sheets

This article includes instructions on how to create and upload your product data in Google Sheets. Merchant Center offers a template to help you build your product data.

Before you get started with creating and uploading your product data, you will need to register your Google Sheet with Merchant Center.

Add your data

Fill out your feed according to the instructions below for the type of spreadsheet you're using. Do not import or open a .xlsx file in Google Sheets, as doing so may cause encoding issues.

Use annotations on your website to add your data

Make sure the landing page URL for each annotated product is included in the link attribute for each item in your feed, and the id is set to match the SKU for each item in your feed. Every landing page URL should match the the webpage URL you claimed in Merchant Center.

Click Update to start the process and update all rows. Select the dropdown arrow on the button and select Update selected rows if you would like to only update any rows you have selected.

Note: The feature can create and validate up to 1000 rows at a time. If your feed is larger than 1000 rows, use the Update selected rows option to create and validate your feed in batches.

Modifying your Google Sheet during the update process may cause changes to be overwritten. If you accidentally overwrite your changes, use the Sheets revision history feature to go back in time and revert your overwrite. The update process may take a few minutes, depending on the number of products to be processed.

Validate your annotations

Incorrect or missing annotations will generate errors that will need to be corrected within the Sheets-powered feed. Verify that the structured data on your site is correct, and that the id and SKU match exactly. If you encounter errors, use the Structured Data Testing Tool to verify that your structured data is set up correctly. Visit the Google Search Console Help Center to learn more about using the tool, debugging any issues, and interpreting your results in the tool.

After you’ve reviewed the data and corrected any errors, you can begin the full data validation and submission process.

Validate your data

If there are any processing errors or warnings in your data, you can click on each issue to see examples in the sheet. Note that you can only validate an entire Sheet if it’s 1,000 rows or less.

You can also validate specific rows in your sheet by highlighting the desired rows and changing the validator button to Validate selected rows.

If you have used structured data markup, test your implementation with the Structured Data Testing Tool. Visit the Google Search Console Help Center to learn more about using the tool, debugging any issues, and interpreting your results in the tool.

Submit your feed

Be sure to check the Diagnostics page after you’ve uploaded for your feed for a full list of all errors and warnings for your data.

Google Sheets format requirements

  • The first page of a Google Sheets file must contain the product data to be submitted. The first line of this page must be the header. The header must contain a single attribute per cell. Any values that are not supported attributes will cause errors during the verification and upload process.
  • Each cell may only contain a single value per item, and comply with the value rules outlined in the product data specification.
  • For group attributes such as tax and shipping use colon-separated sub-attributes. Visit Set up tax settings and Set up shipping settings for more information.
  • If an attribute accepts multiple values, you should provide each value separated by a comma, such as ‘blue, green, red’ wherever applicable. In attributes where multiple values are accepted, if a comma doesn't indicate a separate value, it should be submitted with a preceding backslash, such as ' \, '. Refer to the product data specification to learn more. Note that not all attributes support multiple values; for example, you may only provide one id or description value.

Related links

Was this helpful?
How can we improve it?

Need more help?

Sign in for additional support options to quickly solve your issue