Overview
When exporting a CSV file from Lusha and opening it in Excel, you might notice the data is improperly formatted. This issue typically arises from the separator used to divide the data into columns.
To fix this, adjust your settings using the steps below and re-open the file.
If this doesn't resolve the issue, try downloading the file again. (It will not consume any more credits).
Additionally, data containing special characters might not display correctly in Excel/CSV.
How it works
Option 1 - Narrow the rows
Click on the small square located at the intersection of column A and row 1. This will select the entire sheet.
Reduce the height of row 1 to a smaller size.
Finished!
You can watch this video as well:
Option 2 - Change Excel settings
First, open the CSV file via Excel. Then:
Mark all the contacts.
Press “Data”.
Click “Text to Columns”.
Make sure that “Delimited” is marked and press “Next”.
5. Mark “Comma” and press “Next”
6. Mark “General”
7. Press “Finish”
8. Done!
Option 3 - Import the original file into a new Sheet
Open an empty new sheet in Excel
Press on 'Data'
Click 'Get Data'
Click 'From A File' > 'From text/CSV' and choose the exported file
Make sure it sorted as "65001: Unicode(UTF-8)" in the top File Origin dropdown
Click 'Load'
Option 4 - Update CSV Delimiter
Excel may be not recognizing commas as delimiters - this is likely due to regional settings.
In North America, commas are the default list separator for CSV files.
In many European countries, commas are used for decimals, so semicolons become the default list separator.
To fix this, update Excel settings:
File > Options > Advanced > Under Editing options, uncheck Use system separators, and set the decimal and list separators as shown in the screenshot.
Option 5 - Import the file to Google Sheets
Open a new Google Sheets file by going to https://sheets.new/
Click 'File' > 'Open'
Choose 'Upload' and choose the exported file
All set! The file should be sorted correctly. To download this file as a CSV choose 'File' > 'Download' > 'Comma-separated (CSV)'
Still having issues? Try exporting the file again from Prospecting / Lusha Lists.
Still doesn’t work? Please export a new file to our support team at support@lusha.com and contact us via live chat from the Lusha website, your Lusha Dashboard, or via email- support@lusha.com.