If you are tech-savvy, or want to save yourself a bit of work, follow the directions below to save yourself a few headaches when converting your CP Archive to and .xls spreadsheet:
- Grab a copy of the VIM text editor
- Open your CP archive file with it
:set ff=dos tells VIM to read files in DOS format (This is how CP gave them to you).
:%s/""/\"/g will replace all double quotes with the HTML code for a quote.
:%s/\n\n/<\/p><p>/g will replace all line breaks (places where "Enter" was pressed) with the HTML code for a paragraph.
Once all these steps are complete, you will have a nicely formatted CSV file, with each line being a separate article.
If you are familiar with Regular Expressions (those snippets of code mentioned above), you can use them to pick out any other spacing or new line anomalies that might be in your export file.