Daily Archives: February 24, 2014

Making A CSV File

In order to create a file that the Overview Project can read and analyze, there are a few different steps that need to be taken.  First and foremost, file must use UTF-8, ISO-8859-1, or Windows 1252 character set.  Secondly, the formatting of your file must be correct.  Therefore, my visual layout of the Museum and Libraries conversation needs to be saved as a CSV file rather than an XLS file.  That, of course, was easy enough to accomplish.  The final, and next step is where the difficulty lies, or at least it seems to for me.

Now that the file is in the correct format I have to ensure that the first line of each column contains the name of the content within that column.  Once this is done I also have to ensure that the column itself is either labelled “text”, “snippet”, or “content”.  This seems to be where I am running into trouble.  However, after reading the help and example documents over a few times I believe I may have solved my problem.

Stay tuned!