What Lusha includes in the export
Every export from Lusha includes all available contact fields. The full name appears as a single column - there is no way to separate it before or during the export, regardless of whether contacts have been revealed or saved to a table.How to split names in Microsoft Excel
1
Open the export in Excel
Export your contacts from Lusha as usual and open the file in Microsoft Excel.
2
Select the full name column
Click the column header containing the full name to select it.
3
Open Text to Columns
Go to Data → Text to Columns.
4
Choose Delimited
Select Delimited and click Next.
5
Set Space as the delimiter
Check the Space box as your delimiter and click Next.
6
Choose the destination and finish
Choose a destination column for the split data and click Finish.
7
Label and review the columns
Label the new columns as needed (e.g. First Name, Last Name) and review the results for any names that didn’t split as expected.
Names with prefixes, suffixes, or multiple words (e.g. “Dr. Jane van Der Berg”) may not split cleanly using a space delimiter. Review those rows manually after splitting.
How to split names in Google Sheets
1
Open the export in Google Sheets
Open your exported file in Google Sheets.
2
Enter the SPLIT formula
In an empty column next to the full name column, enter the formula:
Replace
=SPLIT(A2," ")Replace
A2 with the actual cell reference for your first name entry.3
Run the formula
Press Enter. The formula splits the name at each space and populates the adjacent columns.
4
Fill down to all rows
Drag the formula down to apply it to all rows.
5
Label and review the columns
Label the resulting columns (e.g. First Name, Last Name) and review the results.