Adding new pages

The 'Define New' button > Content Types > Email Form Mailer > Exporting Form Data


Question: When I push the 'Export Submitted Forms' button, it exports fine into Excel, but each field isn't tab delineated. So, when I open the Excel sheet, all the info is in one cell. Is there any way to change that?


Answer: This is a common question that we hear. By opening the exported xls (csv) file directly in Excel, all of the data will open into one column, by default. There is a simple command you can use to separate that data into columns. It is appropriately named "Text to Columns," and can be found under the 'Data' menu. Following are step-by-step instructions.

Here is a handy Youtube video on the subject as well.
 

After you open the file in Excel, hightlight the first column. You can do this by double clicking on column A at the top. If you have multiple columns selected, the "Text to Column" command won't work.
 

Then go to the 'Data' tab, and select "Text to Columns." In the popup, choose "Delimited" on the first screen, then click "Next."

 

 

On the next screen, be sure to click the "Comma" check box. That's it! Click "Finish" in the lower right and you will have the data nicely formatted in Columns and Rows.
 


 

 

This tutorial website is designed to assist our bytePages™ customers in working with the byteEditor Content Management System they have on their sites.

Go here if you would like to have a bytePages™ template site, with this Content Management System installed in it: bytePages.

Go here if you would like to convert your existing site, or to build a new custom website as a self-manageable site using our proprietary Content Management System (byteEditor):
Byte Productions.