Getting Started Using WexZone Manager Requirements
Import Spreadsheet

Once you download your form data, you can import this data into a spreadsheet program, such as Microsoft Excel.  To do so, first save the downloaded data as a text file on your computer. 

In the window that popups with the data, select FILE >> SAVE AS.  Give the file a name, with an ending of .txt, as in formdata.txt.

Open your speadsheet program, and select FILE >> OPEN. Ont he bottom of this screen select "All files (*.*)" from the "File of type" dropdown menu. Select your data file and click "Open".

On the first screen, it will ask if the data is Delmited or Fixed width.  Select "Delimited" and click "Next".

On the next screen, it will ask for the delimiter.  Select "Other" and type | in the space next to "Other".

On the next screen, it asks to select each column. In the Data Preview window, scroll all the way to the right, hold down the SHIFT key, and click on the last column on the right.

Click "Finish" and the data will appear in your spreadsheet.

The first 3 columns are Data ID Number, Date Submitted, and User IP Address.  The remaining columns are the data from your form.  Don't forget to save this new spreadsheet.

 


http://www.wexzone.com/importspreadsheet.html
Updated: Mar 10, 2007