Product data feeds come in various formats.

The most popular feed formats are:

  • CSV
  • TXT
  • XML
  • JSON
  • XLS

Each of these can effectively catalog product data in slightly different ways. 

This site puts those different formats into perspective. With it you can convert data into a number of different data formats.

This example table displays a list of customers, each with four attributes: id, name, age, and gender.

basic product data information table

The following examples will show you what this data looks like in each popular feed format.

CSV

CSV (Comma-Separated Values) files, as the name implies, separate values with commas or other delimiters.

csv product data feed file example
CSV data

CSV format is largely self-explanatory, but something you might want to know about CSV files is: What if the value itself has a comma in it?

A system, if it didn’t know otherwise, would parse that data as another value. 

To work around that, you can wrap values in quotation marks, which act as escape characters — characters that invoke an alternative interpretation on the following characters in a character sequence.

Here’s an example where all of the data is wrapped in quotation marks.

csv product data feed file example quotes escape characters
CSV data (values wrapped in quotes)

While functional, wrapping every value is excessive. Values that don’t contain commas don’t need to be wrapped.

CSV files could also use semicolon (;), pipe (|), or other characters as delimiters to separate values — commas are just the most common. Semicolon delimiter use is common in Europe because their prices use a comma as a value rather than a decimal.

csv product feed data semicolon delimiters
CSV data (semicolon delimiters)
csv product feed data pipe delimiters
CSV data (pipe delimiters)

TXT

Then there are tab-delimited plain text files ending in TXT.

This format helps solve the problem of the comma being parsed, as every new row in that data file is represented by a new row character.

tab-delimited plain text txt product feed file data
Tab-Delimited Plain Text TXT data

XML

XML (Extensible Markup Language) files are visually similar to HTML (Hypertext Markup Language).

The formatting to an XML file depends on a schema, or structured data, which is used to more clearly provide information to the recipient system.

For example, Walmart relies on a schema that they use to process data in a certain way. This schema is different from what Amazon, Google, and others use.

This format also introduces the concept of a minified and unminified version.

  • Unminified: human-oriented file that includes formatting that makes it easy to read.
  • Minified: computer-oriented file without easy-to-read formatting. Minified files take up less space.
xml product feed file data unminified
XML data (unminified)
xml product feed file data minified
XML data (minified)

Those carrot/alligator characters on each line are used to define elements and those elements contain definitions of data.

XML files give more context without that information actually being values in the data.

This format was very popular in the 90s and is still commonly used, but it’s becoming less popular than JSON.

JSON

JSON (JavaScript Object Notation) has become more popular over the years because of the prevalence of the use of JavaScript.

This format is similar to XML files in that it can be minified or unminified and it also works off a schema.

Here there’s a list of customers and each one is represented by properties and values — a name and key value pair.

json product feed file data unminified
JSON data (unminified)
json product feed file data minified
JSON data (minified)

JSON and XML allow for more organized, standardized, and more complex data compared to a CSV or TXT file.

XLS

Lastly, we have XLS (Microsoft Excel Spreadsheet) files.

XLS files are different because instead of being plain text files, they are binary files. They contain complex data like images, styling format formulas, etc.

This example contains the same data established in the original table but it also contains color and font styling information, as well as a chart.

xls product feed file content
XLS file content

Because XLS files can contain all of this information, this format is commonly used for business cases but not so much as a product feed format.

File Compression

While we’re on the topic of feed formats, this would be a good time to introduce the concept of file compression.

Channels often may accept or favor compressed files. When you’re dealing with big files, compression can really help with transmission speed. Some compressed files can be one-tenth the size of their uncompressed form.

file compression example zip

You’re going to run into instances where you may need to compress your file(s) or where it may be a helpful option.

Continue to Product Feed Basics: Product Attributes

“Our team optimizes shopping feeds at a granular level – using GoDataFeed – honing every data point that helps determine performance.”
“GoDataFeed's low cost solution provides a single point of integration to optimize, automate and track product feeds.”
“GoDataFeed makes it easy for merchants to market their products on comparison shopping engines and marketplaces.”
“We love GoDataFeed and use it all the time.  It is really simple to integrate GoDataFeed into your website.”
“A multi-pronged marketing endeavor probably seems daunting but it doesn’t have to be. Companies like GoDataFeed exist to help simplify the process.”
“Companies like GoDataFeed provide solutions for managing multiple data feeds. They also automatically upload your feed daily, or even more frequently.”
“Data feed tools automate the process and will undoubtedly save you some energy to tackle larger tasks at hand. Personally, I’ve had good experiences with GoDataFeed.”
“Look at more advanced data feed management tools like GoDataFeed [for] the heavy lifting to get your feed in the right format.”
“GoDataFeed is considered by many to be 'king of the castle' when it comes to data feed tools. It’s integrated with many CSEs in addition to Google Shopping.”