Convert your spreadsheet into a tab-delimited text file

Most spreadsheet programmes 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 that 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 make sure you 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 any 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

Clear search
Close search
Google apps
Main menu
Search Help Centre