Convert your spreadsheet into a tab-delimited text file

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 to Google Merchant Center.

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?

Need more help?

Sign in for additional support options to quickly solve your issue