|
Main /
WhatIsACSVFileWhat is a CSV fileCSV stands for Comma Separated Values file. It is essentially a database or spreadsheet in text format where the fields are separated by commas. What does a CSV file look like? A simple CSV file will look something like this if you open it up in a text editor such as notepad. ID, ProductName, ProductID, URL, ImageURL, ImageThumb,Details 1,Red Widget, wid01,http://www.domainname.com/widget1.htm, http://www.domainname.com/images/widget1.jpg, http://www.domainname.com/images/widget1thumb.jpg,A widget in Red, 2,Blue Widget, wid02,http://www.domainname.com/widget2.htm, http://www.domainname.com/images/widget2.jpg, http://www.domainname.com/images/widget2thumb.jpg,A widget in Blue, 3,Green Widget, wid03,http://www.domainname.com/widget3.htm, http://www.domainname.com/images/widget3.jpg, http://www.domainname.com/images/widget3thumb.jpg,A widget in Green, What is a CSV file is not A CSV file is not a Pipe or tab separated file. These are similar to CSV file but instead of using a comma to separate the fields they use a pipe | or a tab. If you have one of these files you can easily convert it using Microsoft Excel or Open Office. Instructions on how to do this are on our wiki page. |