Importing membership list from Toastmasters International

Written by RogerM on . Posted in Documentation

1. Navigate to www.toastmasters.org

2. In the upper right corner, click on the Login link

TI menu bar

3. Enter your Toastmasters International Username and Password (These may not be the same as you use for FTH.)

TI login panel

 

4. Click on the Leadership Central tab.

TI menu bar after login

 

5. A drop down list will be displayed. Click on Club Central.

Leadership Central panel

 

6. The club(s) you have access to will be displayed. Click on the club link.

Club Central

 

7. The Club Business page will be displayed. Click on View/Update/Print my club membership roster.

Club Business area

 

8. Click on the Export to CSV button

Club Membership export

 

9. Depending on your browser and default download settings, a link to the newly exported file may be shown in lower left corner of your screen. Double-click that link.

Link to downloaded file

 

The csv file will open similar to this file.

CSV file layout

 

 

10. Highlight columns A, C, D, E, F, G, H, I, L, M, N, O, P, Q Right-Click and click on Hide.

Hide unneeded columns

 

11. You may have to resize the columns to see the data. You will need to cleanup the phone numbers by removing all spaces. You can use Find and Replace (Ctrl + H) or do it manually.

Desired columns visible

 

12. This is what you want. Highlight just the information you want to copy, and either press Ctrl + C or right-click and choose Copy

Highlight and copy

 

Note: If you’re using a program other than MS Office (e.g. LibreOffice), you may find that the hidden columns get copied as well.

In that case, delete the unwanted columns and save the document with another name before copying.

 

13. In FTH, log in as the administrator, click on Launch Admin Console, then membership Management, and click on the Quick Add tab. Click in the white space, press Ctrl + V, then choose the list to Add the following people as: Members and then click the Save button.

Pasting into membership management

 

14. Click on the tab of the group you added the members to.

Membership management: the result

Notice that the member with no email was assigned a placeholder email by FTH.