Hidden data in your club import's blank rows and columns will prevent your club import from being accepted by the Club Importer.

How to delete blank columns

To delete blank columns in Excel, use the following instructions:

1. Click on cell X1
2. Hold down SHIFT button and use the END button, then the RIGHT ARROW button to select all blank columns to the right of W
3. Right hand click the highlighted section.
4. A drop down list will appear.  Select Delete.
5. A pop up window will appear.  Select Entire Column and then OK.

How to delete blank rows

To delete blank rows in Excel, use the following instructions:

1. Click on the cell in column A which is immediately below the last row you have got text in.
2. Hold down SHIFT button and use the END button, then the DOWN ARROW button to select all blank rows under your text
3. Right hand click on the highlighted section.
4. A drop down list will appear.  Select Delete.
5. A pop up window will appear.  Select Entire Row and then OK.

How to delete visible blank rows

Sometimes, club import data can have information where athlete records are separated by a blank row:

To delete these blank rows without losing data or having to sort through a number of records, use the following instructions:

1. Click on cell 1A. Hold down SHIFT then press the END button. This will highlight the entire workbook with all athlete information
2. Scroll back to the top of the document, ensuring the workbook is still highlighted. Go to the Data tab and click 'Filter' to turn on the filters.
3. An arrow will appear next to the LastName column, click the arrow and select 'Sort A to Z' from the dropdown list.
4. This will sort the records alphabetically and remove the blank rows between records.

Need more help? Contact support.