In this help center, you can find content for both Merchant Center Next and the classic Merchant Center experience. Look for the logo at the top of each article to make sure you're using the article for the Merchant Center version that applies to you. 

Convert your spreadsheet into a tab-delimited text file

A custom icon for Merchant Center Classic and Merchant Center Next.

Most spreadsheet programs allow you to export data into a tab-delimited file. Either of the options below will create a file with a name ending in the ".txt" extension. This is the file you should submit.

If you're using Google Sheets:

  1. From the File menu, select Download as then select Tab-separated values (.tsv, current sheet). This will download the currently selected sheet as a tab-separated .TSV file, inheriting the name of your spreadsheet. Select the Save as... or Save File As... command from your browser's File menu.
  2. Name your file, and be sure to specify the file type as a Text File (*.txt) if it gives you the option. Click Save.

If you're using Microsoft Excel:

  1. Open the File menu and select the Save as... command.
  2. In the Save as type drop-down box, select the Text (tab delimited) (*.txt) option.
  3. Select the Save button. If you see warning messages pop up, select the OK or Yes button.

Was this helpful?

How can we improve it?
Clear search
Close search
Google apps
Main menu
Search Help Center