Preparing your data.

Raven's Eye can analyze word data across several formats, including directly pasted text, text saved in a .docx formatted word processing document, or text saved in a .csv, .xls, or .xlsx formatted spreadsheet.
For quick analyses or analyses that treat your entire response set as one meaning unit, you may find the most expedient means of preparing your data to be either copying and pasting, or saving your data in a .docx document. For most other purposes, however, you'll want to organize your data in a spreadsheet program. In this section, we discuss how to prepare your data according to these three formats.

Copy and paste.

Your data can be copied to your computer's clipboard from another source and pasted directly into Raven's Eye. To prepare your data for copying and pasting into Raven's Eye, simply use the highlighting or select feature of the program that you are using to select the text that you would like to copy, and then choose that program's Copy command to copy the selected text to your computer's clipboard. If you haven't already done so, proceed to log in to Raven's Eye, and then paste your copied text into its own table for analysis.
copy and paste text from odt, html, txt or other sources
Raven's Eye automatically removes most html and other formatting characters that may have been inadvertently captured during the copying process. However, you may occasionally capture strings of characters when copying and pasting from various sources without first cleaning your data. In some instances, the inadvertent capture of character strings may affect the apparent distribution of the words in your sample, thereby introducing various amounts of error into your results.
We recommend that users try to reduce the amount of formatting incidentally captured in the copying process by carefully selecting only the text that they are interested in analyzing, while trying to refrain from capturing clearly marked links, images, or other non-textual features that may surround that text. When general impressions are all that are required, such procedure may likely suffice in terms of data preparation. When however, precise or scientific results are required, we recommend cleaning your data such that it contains only textual or numeric data, and then uploading it via one of our supported spreadsheet formats.

Word processing documents.

If your word processing program will save or export your textual information to .docx format, you can upload it to Raven's Eye for analysis.
In order to prepare your natural language data for uploading as a .docx word processing document, you should first clean it of inadvertent formatting, html, images, or other non-textual or non-numeric information.

After you have cleaned your data, save it in .docx format by selecting the Save As or Export feature of your word processing program. Save your document to a location on your computer from which you can upload it to Raven's Eye.
Upload word processing documents for qualitative analysis and text mining
Once you have completed these steps, you are ready to log in and upload your data for analysis.


Raven’s Eye works on any spreadsheet saved in .csv, .xls, or .xlsx formats. Other than cleaning your data to remove formatting, character strings, images, or other non-textual or non-numeric information, there are only a few things that should be done when preparing your spreadsheet data:
  • First, you will need to arrange your data so that your variables and responses are ordered by column, and your cases are ordered by rows. Each case represents a single instance of your meaning units. As such, it might take the form of one participant's responses to survey questions, a paragraph among others in chapter, an essay among others on a given topic, etc.
Your variables and responses should be ordered by columns
your individual, cases, examples, or survey responses should be ordered by rows
  • Next, you will want to make sure that your column labels are accurate, and are free from punctuation. Ensure that you have labeled all columns, and that there are no periods, quotation marks, parentheses, or other punctuation.
Remove punctuation from column labels prior to uploading to our online natural language analysis software
  • Thirdly, you will want to eliminate any empty columns. To do so, click on the empty column, and then select delete in your spreadsheet program’s dropdown menu bar.
eliminate empty colums before uploading to our online CAQDAS
  • Next, you will need to eliminate all formulas and formats from all cells. You can do so by either individually editing each column, row, or cell containing formulas or formats, or you can eliminate them all at once by selecting the sheet, copying it, and then use the past special function to paste only the values in a new sheet, workbook, or file.
Delete equations, formats, and functions from worksheet cells
  • Finally, you will need to ensure that there is only one sheet per workbook or file. If your workbook or spreadsheet file contains more than one sheet, you will need to delete all sheets but the one that contains the data that you would like to analyze. If these sheets contain information that you would like to retain, you should save the single-sheet workbook or file under a new name.
Submit only one worksheet per workbook
Once you have completed these steps, you are ready to log in and upload your data for analysis.

If your spreadsheet program does not normally save or export to .xls, .xlsx, or .csv file formats, check its user manual for directions on saving or exporting to these file formats prior to uploading data. Nearly all spreadsheet programs will export or save files to one or both of these file formats, though you may need to utilize a specific Export, Save As, or Share menu in your spreadsheet program to do so.

Technical considerations

Those wishing to ground their investigations in Quantitative Phenomenological methods may want to consider the information provided on the Acknowledge and refine your attitude page of our Technicals, which is first step in conducting a Quantitative Phenomenology with Raven's Eye. That step addresses several theoretical and methodological considerations that correspond with many of the practical decisions made while gathering and preparing your data.