While working on another affiliate website, I was thinking about a few questions I received recently about how to set up a datafeed file for import. Since it’s something I’m familiar with, it’s quite easy for me to forget that some are just starting out and aren’t yet proficient at cleaning up/preparing datafeed files.
That said, I’ve put together a brief guide on the process from start to finish. (This guide was actually written as I went through the process of cleaning up a datafeed that I will be using on a site.) It’s only 7 pages long and loaded with screen shots to illustrate everything I was doing.
Free download -> Preparing a Datafeed Using Microsoft Excel (PDF - 144kb)
When I have some additional time, I’ll probably put together a datafeed prep guide using OpenOffice Calc as well.