If you already have student or teacher data in an existing Excel file, you may need to make a few quick adjustments before importing it into Spellings for Me bulk import file. The video below walks you through the key steps to ensure your data is formatted correctly and ready for bulk import.

Top Tips for Preparing Your Excel File

Before importing, here are three important things to check:

Separate First Names and Surnames

• Ensure that first names and surnames are in separate columns.
• If they are combined, you can split them using Excel’s Text to Columns feature.

Remove All Apostrophes in One Go

• Apostrophes can sometimes cause issues when importing.
• Use Excel’s Find and Replace tool to quickly remove them from the entire file.

Handling Double-Barrelled Names

• Make sure double-barrelled names are formatted consistently.
• If needed, you can replace spaces or special characters to keep names uniform.

Watch the video below for a full walkthrough of these steps and more helpful tips!

[Insert Video Here]

By following these guidelines, you’ll ensure a smooth and error-free import process. If you have any issues, feel free to check our other help articles or contact support.