...
- Microsoft Excel (97 onwards) Excel (97 onwards) file:
- The data can be in any Worksheet within the imported workbook, however the name of the Worksheet containing the data must be specified exactly in the Worksheet Name text box (this is case-sensitive). Alternatively, leave this field blank to automatically use the first worksheet in the workbook.
- The Worksheet must contain data for standard fields in columns A to S as per the Field order specified below. If custom fields are being imported, these are supplied in columns T onward. However, most data is optional, and does not need to be supplied in each column.
- Header row - a row containing the field names. Field names in the header row for standard fields are ignored. If custom fields are being imported the field nameas obtained from the downloaded template must not be changed.
- If data is not available for a particular field for a record, leave the appropriate cell empty.
- Use one row per record - ID numbers must not be repeated. Use as many rows as required and leave all subsequent rows blank.
| Info |
|---|
Note:If removing rows of data from Excel, make sure that the row is deleted rather than just clearing the cell contents. Even though the rows may look empty, Excel sometimes considers there to be data in to cells which can affect the import. If the import is giving problems and the data looks correct, try saving the Excel file as a CSV or TSV file, and trying to import in that format. |
- Comma separated values (CSV) separated values (CSV) file:
- Note: CSV format cannot be used if importing Custom fields.
- This is a file with each row on a new line, and values within each row separated by commas.
- Header row - a row containing the field names. Field names in the header row for standard fields are ignored.
- If data is not available for a particular field for a player, a comma 'placeholder' must be used. For example - the following is a placeholder between A and B: A,,B,C......
- Use one row per record - ID numbers must not be repeated. IDs must not be repeated. Use as many rows as required. Each row must have a total of 16 commas, corresponding to 17 fields.
| Info |
|---|
Note: If there are commas in the data (e.g.) in an address field, this format cannot be used. In this case convert to Excel or TSV format. |
- Tab separated values (TSV) separated values (TSV) file:
- This is a file with each row on a new line, and values within each row separated by tabs.
- Header row - a row containing the field names. Field names in the header row for standard fields are ignored. If custom fields are being imported the field nameas obtained from the downloaded template must not be changed.
- If data is not available for a particular field for a player, a tab 'placeholder' must be used. For example - the following is a placeholder between A and B: A<tab><tab>B<tab>C...... where <tab> refers to a tab character.
- Use one row per record - ID numbers must not be repeated. IDs must not be repeated. Use as many rows as required. Each row must have a total of 16 tabs, corresponding to 17 fields.
| Info |
|---|
Note: Data downloaded by clicking the Download import file template link will be in tab delimited format, with a header row. |
Import Field order and validation rules:
...