Importing data from a spreadsheet into a form

  1. Ensure that the columns in the spreadsheet are in the same order as the columns in the form’s grid.
  2. In the spreadsheet, select the rows by shift-clicking in the row numbers on the left.


  3. Right-click and select Copy.
  4. Ensure that the form is in "Add" mode. that is, the New toolbar button is enabled.
  5. In the form’s grid, click in the left column of the first empty row.


  6. Select Edit > Paste Rows Append.
  7. Paste the data from the spreadsheet into the dialog box and click OK.
    The rows are added in the grid.

  8. Click the Save button to save the rows.

The copy works only if all the information in the rows is valid and in the proper format. Otherwise, you get data validation errors and the import stops. See Requirements for loading data from spreadsheets.