...
Navigate to Teams > Browse Seasons.
Next to any Season, click “View”.
Click “Import Fixtures”.
Click “Sample file with comments” to download the file.
...
Navigate to Teams > Browse Seasons.
Next to the appropriate Season, click “View”.
Click “Import Fixtures”.
Click “Choose File”.
Selected Worksheets: Choose the worksheets from your file that you want to import from.
Select Data: Choose how much of the data you want to include from the selected worksheets.
Load all data from worksheet(s): This is the most common option. This will load all rows from every worksheet selected from your file.
Load selected data from worksheet(s): If you choose this option, you can select the Header row and any Constant Fields. Constant fields can be used where a field is the same for all fixtures being imported. For example, if all fixtures being imported are for the same Team, you can select a constant field that will be applied to every row.
Load using configuration: Load using the saved mappings saved from a previous import.
Map Import Fields: Click to proceed with the data selected.
Assign Fields: This section allows you to match up the columns of data being imported with the fields in myClubhouse they should be saved to.
Input CSV Field: The header from each column of your import file.
myClubhouse Field: Select which field in myClubhouse the field from your import file should feed in to.
Mapping Option: Where appropriate, select the format that your data is in.
⚠️ Important! Forgetting to set this field is a common cause of import errors!Sample Value: This shows the values from your first row, as an example to help you select the correct options.
All or nothing: If checked, if an error occurs on a single row, none of the rows of data will be imported.
Treat "NULL" as no value: If checked, cells with “NULL” in them will be treated as if they were blank.
Save Import Mappings: You can save the import mappings for importing fixtures in the future.
Complete the wizard:
Name: Name the mapping configuration.
OK: Once happy with the details, click “OK” to save the mappings.
Import: Once happy with all the mappings, click “Import” to start the import.
...