Creating a product feed in Excel or Google Sheets is possible (exceptionally), however, it is not preferable, because then the product feed cannot be updated automatically. This means only advertisers that don't regularly change their prices or products should be creating their product feed in Excel or Google Sheets.
Create a product feed in Excel or Google Sheets
- Start with a Microsoft Excel or Google Sheets document.
- On row 1, type out all the fieldnames (see 2. Fieldname standards) in seperate collumns.
| A | B | C | D | |
| 1 | title | bandwidth_upload | bandwidth_download | subscription_duration |
All mandatory fields (see 2. Feeldname standards) should be added to the product feed, other fields are optional. It is also possible to add your own extra fields, to do this, use lower case characters and underscores (_) to seperate words.
- On the following rule, add your product's information.
| 2 | Alles-in-1 Light | 50 | 50 | 12 |
| 3 | Alles-in-1 Light | 50 | 50 | 24 |
- The values in the collumns correspond with the fields that are present in the top row.
| A | B | C | D | |
| 1 | title | bandwidth_upload | bandwidth_download | subscription_duration |
| 2 | Alles-in-1 Light | 50 | 50 | 12 |
| 3 | Alles-in-1 Light | 50 | 50 | 24 |
- When all your products are present in the feed, save your sheet as a ".CSV" file.
Publish CSV as a web page with Google Sheets
With Google Sheets, it is possible to publish files as web pages. To do so, follow the steps in Google's explanation: Publish files as web pages.
Make sure to publish the Google Sheet as CSV and without restrictions.