Formatting the Excel File

Owned by Mei Soong (Unlicensed)
Sept 27, 2019
1 min read

This should be fairly simple, but there are a few things to be aware of:

  1. Template of the Excel file MUST NOT be changed:

    1. Do not change the column header names

    2. Do not add new columns

    3. Do not change the name of the spreadsheet tab

  2. Name of the spreadsheet tab must always say “AddressBook” (one word, no space).

  3. If there is no data available, just leave the column blank.

  4. Need to determine group names in the Group column.

 

Example Address Book:

Depending on the number of people in the Address Book, you might want to consider creating multiple Address Books instead. The Address Book doesn’t have a hard limit on how many people it can hold, it’s more a question of the user experience you’re trying to create in the app.