How do I open the csv Export File from the Forms (Precise, Awesome, and v2) feature?

Home Documentation How To How do I open the csv Export File from the Forms (Precise, Awesome, and v2) feature?

The various Form features (Precise Forms, Awesome Forms, Forms v2) that we offer provides an option to Export your data in .csv format.  Follow the instructions below to open the csv file in a spreadsheet so that you can easily edit the records, create reports, etc.

 

01) Log into your App Manager and select your app.

02) Click Features from the left-hand-side of the screen (or the middle of the screen).

03) Click the Page Title of your Forms.

04) Click the Data option:

a) Awesome Forms – Click the Manage Data tab. Next, click Download CSV.

b) Precise Forms – Click the Data tab, then Export CSV.

c) Forms v2 – Click Results, then Export CSV.

 

05) After the file is downloaded, rename the file extension of the file from .csv to .xlsx (or .xls).

06) Open Microsoft Excel… Click File, then Browse to the location of the file and select it to open it.

07) When the Import Wizard opens, select the Delimited option.

 

08) Under the Delimiters section, uncheck all options except Other.  In the box, put a semicolon.

 

09) For Column data format, select General.

 

10) Click Finish and you’re all set!

 

Comments are closed.