Making a productfeed in Excel

The easiest way (as an advertiser) to create a productfeed, is by using Excel. Some advertisers choose to do this. Generally, it is not prefered, because this means the productfeed will not be automatically updated. This means only advertisers that don't regularly change their prices or products should be creating their productfeed in Excel. 

 

Making a productfeed in Excel

  1. Start with a Microsoft Excel document.
  2. 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.

  1. 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

 

  1. 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

 

  1. When all your products are present in the feed, save your sheet as a ".CSV" file.