Open form export files with Google Sheets.

13 August 14, 2023

How do I open the csv Export Files from the various features (Precise, Awesome, Tickets, and Forms) using Google Sheets?

The various Form features (Precise Forms, Awesome Forms, Tickets, Forms, etc) that we offer provides an option to Export your data in .csv format. Follow the instructions below to open the csv file using Google Sheets 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:

  • Awesome Forms – Click the Manage Data tab. Next, click Download CSV.
  • Precise Forms – Click the Data tab, then Export CSV.
  • Forms v2 – Click Results, then Export CSV.
  • Tickets – Click Tickets, then Download Tickets (csv).

05) Open Google Sheets (go to https://sheets.google.com)… Click Blank, to start a new Sheet.

6) Click File, then Import. Next, select the Upload option, and locate and select the exported file from your App Manager.

7) When prompted with the Import Options, select Replace spreadsheet, Custom and enter a semicolon (;). Select Yes for Convert text to numbers, dates, and formulas. Lastly, click the Import Data button.

8) All done!