Make sure to upload the spreadsheet containing the data into EcoDocs.
The Spreadsheet must have a header row as shown
Go to Forms>Templates in the left toolbar then browse through the explorer to the desired form.
Click on the checkbox next to the form name then click on import in the top toolbar.
Browse to the spreadsheet in the cloud and select it.
"Import Spreadsheet into Form" dialog will load.
Enterthe data import settings Sheet: Select the sheet you want to import data from. You can only import data from a single sheet at a time. Get submission name from column: this tells EcoDocs which column to use as the submission name when importing data. Spreadsheet Time Zone: The time zone used in the imported spreadsheet. Set Submission Time: the time to be used as the submission time. "Now": set the submission time to all imported data to the time of the data import. "Pick Date/Time": select a time to be used for all submitted data. "From Column": each row will use the time entered in the selected column, this is specially useful when importing historical data
Last section is "Configure Columns": Each section shows the column header and a sample of the data stored in the column. Click on pick field then select a field from the form to import the column data into it. Skip Data import: This will data import for this column. Add New Options: (only for dropdown fields) If the value in the column doesn't exist in the dropdown then it will be imported and added to the list of options in the dropdown. Checked Value: (only in checkbox) the valuein the spreadsheet that indicates the checkbox is selected, e.g. True, Done ... etc.
Then click on Import and the process will run in the background.
Sheet: Select the sheet you want to import data from. You can only import data from a single sheet at a time.