iFormBuilder Data

What's covered:

• What is the Excel Data Feed?
• How do I export my data via the Excel Data Feed?

What is the Excel Data Feed?

The Excel Data Feed is an Excel export of your data that includes all the metadata (such as location, user, created date, etc) captured in the background of your device. This metadata will be displayed in columns A through M on your Excel spreadsheet while user-defined columns will begin in column N.

The data returned will show the data column names that you defined for each element in the Form Builder as well as the key values used for options in your Option Lists.

PLEASE NOTE: Microsoft Excel limits the number of columns to 256 in an XLS file. If your data exceeds that, please export with XLSX. This Customer Success Center article will show you how to do so.

How do I export my data via the Excel Data Feed?

To export your data using the Excel feed, please follow these quick instructions below.

STEP 1. From inside the admin portal, navigate to the Data tab (this is the default tab when logging in).

STEP 2. Highlight the form which you'd like to export and click the XLS button.

Your XLS file will be downloaded locally to your hard drive.