I am getting lots of emails from people who are having problems with exporting their contacts to a csv file. I think I’ve figured something out (a solution) although I’m not sure why the problem exists.
The problem is that when you export the file to a csv, and then you attempt to open it, it isn’t really a csv… Excel is not recognizing the commas as separators… so you get a bunch of gobbledygook.
Here’s something that will solve this for many of you:
STEP 1: Go to Windows Explorer – the way I get there is to right-click on the start button and select Explorer (note: this is NOT “Internet Explorer, which is a web browser):
STEP 2: This next thing is an OPTIONAL step, but I do it so I can test that what I’m trying is actually working. Browse to the folder where the csv file is – that might be your downloads folder, or your desktop… I can’t tell you where it is so pay attention when you download it
STEP 3: click on TOOLS at the top of Windows Explorer and then click on Folder Options.
Step 4: Click on the View Tab, then find the checkbox that says “Hide extensions for known file types.” CLICK ON THAT!!
By default, Windows hides the extensions, which makes the view a little nicer… however, in a situation where you think you have a csv file but it’s really being saved as a txt file (which is what people are telling me), it really, really messes you up.
Now that you can view the file types you’ll probably see the file named something like:
Before it didn’t show the txt, but now that you are unhiding the “known file type” you can see that it isn’t really a csv, it is a txt! Bleh!
(If you want you can click “Apply to All Folders” – this is something I do)
Step 5: go back into the folder and find your exported LinkedIn file… simply right-click and choose RENAME from the dropdown… remove the .txt so that it ends in .csv, and now you have the csv file that you were expecting
I have NO idea why this started happening – seems like it started in the last few months and has been very frustrating to find and fix! Hopefully LinkedIn can figure out what the problem is (one of my readers said LI Customer Support said it was their email client messing it up… Oh My Gosh. It has nothing to do with the email client!).
Having OTHER problems related to this file? Leave a comment and hopefully we can get this all ironed out.