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 - 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)'
Are you 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.