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.
- Attribute names: As you’re typing in the header row of your sheet, select from the list of accepted attribute names. Learn more about product data specifications
- Accepted values: Select from the list of accepted values for any attributes with standardized values. Learn more about feeds
- Google product category: Select the correct category from the list of suggestions. Learn more about google_product_category
Use schema.org 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.
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 Schema.org 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
shippinguse 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