When opening up your Leads export file on Excel, you might see a sheet similar to the one below:
If you're opening up your .CSV export on Excel, what you would need to do is to make sure that you do not open your downloaded file directly from your downloads folder. This is because .CSV files appear as one unseparated column if opened this way.
Instead, follow the steps below:
Step 1: Make sure you close any open windows you have of Excel first, then start up Excel
Step 2: Once you've booted up Excel, open the .CSV file by clicking on "Open" or "Open Other Workbooks".
Step 3: Click "Browse" and locate the file you want to open (make sure that you search through "All Files" and not just "All Excel Files" since the lead export sheet is a .CSV file).
Step 4: Once loaded onto Excel, a popup would appear, showing you options on how to read the .CSV file. Click "Next" first.
Step 5: Under "Delimiters" choose "Comma" then hit "Finish".
The file should now look like this:
Here's a quick demo to show the entire process:
If you're still not able to load the file properly, do send us an email at email@example.com and we'll be able to assist.
How to get your support tickets resolved faster
Statistics have shown us that the more you tell us when you report an issue, the faster we solve that ticket. So...
1 - If you have screengrabs, please include them. A picture is worth a thousand words.
2 - If you have recorded a video showing the issue you're having, please include that as well. A video is worth a million words.
We recommend a free service called Loom for creating these videos. (this is a link to https://www.useloom.com/)
3 - To speed up ticket resolution, follow these useful tips How to Write the Perfect Support Ticket (That Gets Results Fast)