Setting up a CSV for import with feeds

Steps for sanitizing a spreadheet for import into feeds
a) Move the field mapped to the title to the first column of the spreadsheet.
b) Remove any duplicate entries for if duplicates will cause a problem
c) Save sheet as msdos csv
d) change file extention from .csv to .txt
e) replace the following with items in the brackets [] pay careful attention to spaces in them
[?] -> [']
[ ' ] -> [ ]
[ΓΏ] -> [space]

This method can be problematic if there is a large content field as there may be ' or " or tabs that are un-escaped. A preferred method in that case would be to convert the spreadsheet to xml and use xpath http://drupaldev.saturn.milesmedia.com/importing-excel-xls-file-generate...

section:

modules: