Important Notes

1. Supported import file formats are native Excel spreadsheets (xlsx) and CSV (csv) only.
2. The first row of the file should contain the field names to be imported. The field names MUST match the corresponding field names in the table. You can manipulate the field names in the Page_Importing server event (see Server Events for Import) if the file contains pure data only.
3. All data in the file MUST match the data types of the corresponding field in the table. For example, if you are importing into an Integer field, the data is expected to contain an integer value or the import may fail. You can however modify the field values in the Row_Import server event (see Server Events for Import below). Importing lookup fields from display values is NOT supported, but you can also use Row_Import event to support it in your own ways.
4. If you are importing a lot of records, the import may take a long time to complete.
5. For CSV file, the default quote character and delimiter used are " (double quote) and , (comma). You can change in Advanced Settings or by Page_Importing server event.
6. To ensure an ALL OR NOTHING import, you can enable the Import records by transaction in Advanced Settings. The transaction will be rollbacked if there is any error during the import process.
7. The default import operation is "Insert only". If you want also to update records if record with the same record key is found, you can disable the Import records by insert only in Advanced Settings. Please make sure that you understand the implication of this change before modifying the setting.
8. If User Level Security is enabled, by default only the Administrators has the rights to import records. To allow a non-admin user to import records, use the TablePermission_Loaded server event (see Server Events and Client Scripts) to set an user with Import permission, e.g. CanImport = true;.