Make sure your spreadsheet has a header row with at least the following columns: Name (or First and Last), Category, and Position. (In addition to any other columns you selected to import.) Go back to column setup instructions Make sure your header row is at the top of your spreadsheet. If your spreadsheet has multiple sheets within in, then make sure you selected the correct sheet to import from. We read from the sheet named "". Go back and change sheet For an example of what the header row should look like, please view the example spreadsheet.

We found your header row, but we didn't find a Category column. This column is required because it determines how the staff directory is organized. Please add a "Category" column to your spreadsheet, and enter one of the following values for each person: Tip: Use data validation in Google Sheets or Excel to create a dropdown that lets you select from your list of categories. Video tutorial Already have a Category column? Make sure we identified the right row as the header row (we think it's row 1). Also, if your spreadsheet has multiple sheets within in, then make sure you selected the correct sheet to import from. We read from the sheet named "". Go back and change sheet For an example of what the header row should look like, please view the example spreadsheet.

Make sure your spreadsheet's header row has either one column for names ("Name"), or two columns for names ("First" and "Last"). Your spreadsheet must have either a single "Name" column, or both "First" and "Last" columns. For an example of what the header row should look like, please view the example spreadsheet.

We found a column for last names, but not a column for first names (or a column for full names). Make sure your spreadsheet's header row has either one column for names ("Name"), or two columns for names ("First" and "Last"). Your spreadsheet must have either a single "Name" column, or both "First" and "Last" columns. For an example of what the header row should look like, please view the example spreadsheet.

We found a column for first names, but not a column for last names (or a column for full names). Make sure your spreadsheet's header row has either one column for names ("Name"), or two columns for names ("First" and "Last"). Your spreadsheet must have either a single "Name" column, or both "First" and "Last" columns. For an example of what the header row should look like, please view the example spreadsheet.

The spreadsheet is missing several columns that you selected to import: Make sure there aren't any typos in your header row. Your column headers must match the field names displayed above. To change which columns to import, go back to column setup. Alternatively, skip the missing column(s). If your spreadsheet has multiple sheets within in, then make sure you selected the correct sheet to import from. We read from the sheet named "". Go back and change sheet

The spreadsheet has several duplicate columns: Make sure all of your columns are labeled correctly in the header row. Rename any columns that are being misidentified. To change which columns to import, go back to column setup. If your spreadsheet has multiple sheets within in, then make sure you selected the correct sheet to import from. We read from the sheet named "". Go back and change sheet

The spreadsheet has several columns with it was more than one field name, so we couldn't figure out which field it was supposed to be. Make sure all of your columns are labeled correctly in the header row. Rename any columns with names that contain more than one field name so that we can tell which fields they're supposed to be. To change which columns to import, go back to column setup. If your spreadsheet has multiple sheets within in, then make sure you selected the correct sheet to import from. We read from the sheet named "". Go back and change sheet

We found the header row with all of the columns you selected to import, but we didn't find anything below that. If your spreadsheet has multiple sheets within in, then make sure you selected the correct sheet to import from. We read from the sheet named "". Go back and change sheet For an example of what the spreadsheet should look like, please view the example spreadsheet.

We skipped all instances of 3 names in the spreadsheet because they appeared on more than one row: Two contacts can't have the same name. If two people have the same name, add a middle initial to their names to differentiate between them.

We skipped 3 rows in the spreadsheet due to missing or invalid values: Make sure each row of the spreadsheet has at least a name, category, and position. Go back to column setup instructions

The spreadsheet has several names with more than one comma: We didn't find both a "First" and "Last" column in your spreadsheet, so we're using one column for names. Names can either be "First Last" or "Last, First". Names shouldn't have more than one comma, because that doesn't make sense.

We skipped 3 emails in the spreadsheet because they were invalid: Make sure all the emails are valid. Enter the full email address, such as "[email protected]".

We skipped 3 phone numbers in the spreadsheet because they were invalid: Make sure all the phone numbers are valid. Supports extensions. Example: "555-432-4010 ext. 153". Enter the full phone number; providing just an extension won't work. Don't include the country code prefix (+1).

We skipped 3 websites in the spreadsheet because they were invalid: Make sure all the websites are valid. Enter a website URL, such as "byermath.blogspot.com".