Skip to main content
When you export a CSV file from Lusha and open it in Excel, the data may appear jumbled in a single column instead of spreading across separate fields. This usually happens because Excel isn’t recognizing the comma delimiter, or because of regional settings on your computer. Try the options below to fix it - re-exporting won’t consume additional credits.
Data containing special characters may not display correctly in Excel even after following these steps.

​
Option 1 - Narrow the rows

1

Select the entire sheet

Click the small square at the intersection of column A and row 1 to select the entire sheet.
2

Shrink row 1

Reduce the height of row 1 to a smaller size.
You can watch this video as well:

​
Option 2 - Change Excel settings

Open the CSV file in Excel, then:
1

Select the contacts

Select all the contacts.
2

Open the Data tab

Click Data.
3

Open Text to Columns

Click Text to Columns.
4

Choose Delimited

Make sure Delimited is selected and click Next.
Text to Columns wizard with Delimited selected
5

Select the Comma delimiter

Check Comma and click Next.
Text to Columns wizard with Comma delimiter selected
6

Finish the import

Select General and click Finish.
Text to Columns wizard with General column format selected

​
Option 3 - Import the file into a new sheet

1

Open a new sheet

Open an empty new sheet in Excel.
2

Open the Data tab

Click Data.
3

Import the exported file

Click Get Data → From A File → From Text/CSV and select the exported file.
4

Check the file origin encoding

Make sure the File Origin dropdown shows 65001: Unicode (UTF-8).
5

Load the file

Click Load.
Importing a CSV file into a new Excel sheet with UTF-8 encoding

​
Option 4 - Update the CSV delimiter in Excel

In many European countries, commas are used as decimal separators, so Excel uses semicolons as the default table separator instead of commas. To fix this, go to File → Options → Advanced, and under Editing options, uncheck Use system separators. Set the decimal and table separators as shown in the screenshot below.
Save Excel file as CSV semicolon delimited

​
Option 5 Import the file into Google Sheets

1

Open a new Google Sheets file

Open a new Google Sheets file at https://sheets.new/.
2

Open the file menu

Click File → Open.
3

Upload the exported file

Choose Upload and select the exported file.
4

Download as a proper CSV

The file should display correctly. To download it as a properly formatted CSV, click File → Download → Comma-separated values (CSV).
Still having trouble? Export a new file and send it to support@lusha.com, or contact the support team via live chat from the Lusha website or your Lusha Dashboard.