Upload XLS data
Bulk Data can be uploaded to the database from either .CSV (Comma separated values) or .XLS (Excel spreadsheets).
When uploaded from an Excel file
- the work sheet must be named "SHEET1"
- the first line (row) of the file must contain the field headings.
- Each individual record or entry must be a new row within the file. The various fields of information for each record must be in separate cells.