> ## Documentation Index
> Fetch the complete documentation index at: https://help.kajabi.com/llms.txt
> Use this file to discover all available pages before exploring further.
# Use Google Sheets to combine first and last name
> Combine the first and last name into a single column in a CSV file to successfully import multiple contacts onto a site.
## Why combine the first and last names?
To import multiple contacts onto your site you can upload a CSV file or copy/paste from a CSV file.
However, Kajabi requires a single name field to function properly with the import contacts tool.
If your CSV export contains two columns for the first and last name you can use functions to combine the separate columns into a single separate column with spreadsheets like Google Sheets.
[Import contacts onto a site](/articles/contacts/manage-your-contacts/how-to-import-contacts-into-kajabi).
**Note:**
Kajabi's default "Name" field accepts first and last names. If you have been using custom fields to collect first and last names, your contacts may appear in your Contacts tab as if they have not provided their names. [Fix the name column if you have used custom fields for first and last names.](/articles/contacts/manage-your-contacts/why-are-my-contact-names-not-displayed-in-the-contacts-tab)
## Combine the first and last name
With the [concatenate function](https://support.google.com/docs/answer/3094123) you can use a spreadsheet to combine the first and last names into a single column.
This guide walks you through the process of using the concatenate function with [Google Sheets](https://www.google.com/sheets/about/).
### Use the concatenate function
1. In a separate column of your spreadsheet, enter `=CONCATENATE(`.
2. Then, select an individual's first name (e.g., John). This will enter the column and row cell reference for the first name into the formula.
3. If the desired cell has been referenced in the formula, then enter `" ",`.
4. Next, select the same individual's last name (e.g., Doe). This will enter the column and row cell reference for the last name into the formula.
5. Close the formula with the left-facing parenthesis, `)`.
6. Then, click **enter** to apply:
If the cell containing the concatenate function displays the first and last name of your selected individual you have successfully combined the first and last name into a single column.
To autofill the remaining contacts you may be prompted to autofill the remaining rows or you can click and drag the bottom right corner of the cell to autofill:
## Skip columns in the Kajabi Contact Importer
After you have combined the first and last name columns in Google Sheets and once you have started the [contact import](/articles/contacts/manage-your-contacts/how-to-import-contacts-into-kajabi) process in Kajabi by uploading your CSV file, the Kajabi Contact Importer will still read the First and Last name columns as "unrecognized columns". These columns will need to be skipped upon import for a successful contact import.
### Skip the First and Last name columns
1. Click the **edit** icon on the **First** box in the "unrecognizable columns" section.
2. In the "Map your column" popup menu, select **Skip Column**.
3. Select **Confirm** to confirm your selection.
4. Repeat these steps for the **Last** column.
5. Once both columns have been "skipped" select **Continue to Import Actions.**
6. Select any Bulk Actions to perform during Contact Import, then press **Continue to Summary**.
7. Press the **Confirm Import** button to finish the contact import process: