%3C%21-- begin olark code --%3E %3C%21-- end olark code --%3E

Converting Your CSV Export to an Excel File

Is this what you see when you open your Excel output file?

The file is a "CSV" (Comma Separated Value) file, which means that Excel should be interpreting each comma as the location where a string of text should be broken into a new cell. If you open the file and see this, then you'll just need to coax it into reading the file correctly. Here is how.

Step 1: Select Column A

All of the information is stored in column A, so we want to make sure it's selected.

Step 2: Text to Columns

Click on the "Data" tab, then in the "Data Tools" group, select "Text to Columns."

Step 3: Define the Separation

The first step in this window tells the system how your text should be separated into columns: delimited by a character (in this case, a comma) or based on the width of the text.

Select the "Delimited" option, and then click "Next."

Step 4: Define the Delimiter

Here, we are telling it which character represents where the text should be separated. Since this is a Comma Separated Values file, we will check off the box next to "Comma," then select "Finish."

Step 5: Enjoy Your New File

Now, your text has easily been dropped into the different columns you will need to read the file properly. You may need to resize some columns to make the text readable without entering a cell.

Still need help? Email Tech Support Email Tech Support