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.
💡 Note: Data containing special characters may not display correctly in Excel even after following these steps.
Option 1 — Narrow the rows
Click the small square at the intersection of column A and row 1 to select the entire sheet.
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:
Select all the contacts.
Click Data.
Click Text to Columns.
Make sure Delimited is selected and click Next.
Check Comma and click Next.
Select General and click Finish.
Option 3 — Import the file into a new sheet
Open an empty new sheet in Excel.
Click Data.
Click Get Data → From A File → From Text/CSV and select the exported file.
Make sure the File Origin dropdown shows 65001: Unicode (UTF-8).
Click Load.
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 list separator instead of commas. To fix this, go to File → Options → Advanced, and under Editing options, uncheck Use system separators. Set the decimal and list separators as shown in the screenshot below.
Option 5 — Import the file into Google Sheets
Open a new Google Sheets file at https://sheets.new/.
Click File → Open.
Choose Upload and select the exported file.
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 [email protected], or contact the support team via live chat from the Lusha website or your Lusha Dashboard.