Data Source Supported File Formats

*The following article does not apply to Google Docs Spreadsheet Data Source



A CSV file can be created and maintained using a simple text editor (like Windows Notepad), but it is often more convenient to manage tabular data in a spreadsheet application and to generate a CSV file using the application's "Save As..." feature.

When saving to CSV from your favorite spreadsheet, saving to MS-DOS format is recommended.

A sample CSV content is as follows.  Please note that the quotation marks shown are only strictly necessary if the one of the fields of data contains the delimiting character (in this case, the comma between the last and first names).

"Smith, John","34","Male"
"Smith, Joan","23","Female"

This will result in a data table that looks like the following:

Name Age Gender
Smith, John 34 Male
Smith, Joan 23 Female

[ top ]



For the XML format for a data source, the root element is considered a list container. Each element under the root is a data container, and each leaf node in the data container is used as a column in the resulting data source table.

<Name>Smith, John</Name>
<Name>Smith, Joan</Name>

[ top ]



For best results, upload a file containing a JSON Array of Objects, or an Object with a single property whose value is a JSON Array. All properties whose value is a basic type (string, boolean, number) are used as values, whose column is the object path to the value.

 {"Name": {"First": "John", "Last": "Doe"}, "Age": 34, "Gender": "Male"}
 {"Name": {"First": "Jane", "Last": "Doe"}, "Age": 23, "Gender": "Female"}

[ top ]



ProntoForms supports using Microsoft Excel's .xls and .xlsx files as data sources. When selecting an Excel file to upload as a data source, please ensure that there is minimal formatting that uses a single tab, if possible.



Data Source Size Limitations

If these limits are exceeded, data will be truncated and an error banner will be shown on the Data Source Information page.

  Lite (AT&T Mobile Forms) Professional Essentials Advanced Enterprise
Number of Cells 500,000 500,000 100,000 500,000 2,000,000
Number of Rows N/A N/A 10,000 50,000 200,000
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request