Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Error importing Outlook 2016 Contacts CSV file into webmail

4 Weeks Ago   #1
Norm777

Windows 7 Professional x64 SP1
 
 
Error importing Outlook 2016 Contacts CSV file into webmail

I am importing an Outlook 2016 generated .CSV contact list into a webmail email account but keep receiving the following error.

Unknown error for item "(Unknown)": Could not parse csv file - Reason : missing column name for column[92]

There are 92 columns and each one has a column name. 92 columns is what Outlook 2016 generates, most columns are empty, just the name. I had previously tried deleting columns with no data but still got the same error, and always for the last column.

Is there a trick to get this contact list imported successfully? I am trying to create a whitelist filter to reject all email where the FROM name isn't in my contact file. My .CSV file contains 162 rows.


My System SpecsSystem Spec
.
4 Weeks Ago   #2
Callender

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

Export your date from your webmail account in csv format and compare it side by side with your exported Outlook data. Make sure that you make the order of columns and column headings in your outlook data match those in your webmail data. Then import.
My System SpecsSystem Spec
4 Weeks Ago   #3
Norm777

Windows 7 Professional x64 SP1
 
 

Sorry, I may have misled you a bit. I am exporting Outlook 2016 contacts to a CSV file, then trying to import the CVS file into my webmail account on my ISP. My webmail account is POP3, the CSV. In the CSV file created from Outlook 2016 it shows the Mail type as SMTP. In any case the error given seems to indicate a column heading name is missing, and it points to the last column heading is missing, but it is definitely there is the CSV file.
I have carefully looked at the CSV file to make sure the column names match in the correct order. If columns contain no data should they be deleted? I suspect importing additional contacts would put there data in wrong columns if any columns are missing.

Strangely I can import the contacts into an email contacts file without error, although that probably only uses the email addresses.

I am trying to set up a whitelist that uses my contacts as a go/no go filter, tossing any emails that aren't from a contact in my contact list. The filter allows me to chose only contacts and not email contacts so I doubt if that would work as intended.

Thanks for your quick response, I appreciate it!
My System SpecsSystem Spec
.

4 Weeks Ago   #4
Callender

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

All I can say id that you should export contacts from both webmail and outlook in csv format then make the outlook csv file match exactly with the headings/ columns shown in your exported webmail data. Empty columns should not cause a problem. If in doubt use Excel or other spreadsheet application and use the "format painter" to transfer formatting. You might also additionally freeze panes for the top row that contains headings.
My System SpecsSystem Spec
4 Weeks Ago   #5
Norm777

Windows 7 Professional x64 SP1
 
 

Thanks for your help. There are no contacts in my webmail. I did export the contacts anyway and got a file with no entries (doh) but it had fewer and different column headers (81) compared to the outlook 2016 contacts (92 columns). I made my outlook 2016 contacts match the columns that the webmail output. I still get the same error but now it refers to column 81 instead of 92.
My System SpecsSystem Spec
4 Weeks Ago   #6
Callender

Microsoft Windows 7 Home Premium 64-bit 7601 Multiprocessor Free Service Pack 1
 
 

Quote   Quote: Originally Posted by Norm777 View Post
Thanks for your help. There are no contacts in my webmail. I did export the contacts anyway and got a file with no entries (doh) but it had fewer and different column headers (81) compared to the outlook 2016 contacts (92 columns).
Suggest create one of more contacts in webmail then export.

Quote   Quote: Originally Posted by Norm777 View Post
I made my outlook 2016 contacts match the columns that the webmail output. I still get the same error but now it refers to column 81 instead of 92.
Manually copy contacts cell by cell if necessary from your exported outlook file into your exported webmail file then re-import it.
My System SpecsSystem Spec
4 Weeks Ago   #7
Norm777

Windows 7 Professional x64 SP1
 
 

I exported the contacts from Webmail after getting them in matching columns in Outlook to Webmail columns, turns out Outlook has a lot more columns than Webmail. When I exported from Webmail the contacts matched my modified Outlook contacts. Something to think about if I don't create my new contacts withing Webmail, otherwise I might have to match column by column to get them installed in Webmail.

Thanks for all your help. Appreciate it.

Norm
My System SpecsSystem Spec
Reply

 Error importing Outlook 2016 Contacts CSV file into webmail




Thread Tools Search this Thread
Search this Thread:

Advanced Search




Similar help and support threads
Thread Forum
Importing Windows 7 Contacts to Outlook 2016
I found the tutorial in this forum called, "How to Import Windows Contacts into Outlook 2010." It all looked very much like Outlook 2016, so I followed the same steps to import my Contacts list from Windows 7 Contacts to Outlook 2016. Everything seemed to go okay, but I cannot find them in...
Microsoft Office
Trouble importing exported Outlook contacts
I have Office 365 on a desktop and am having trouble importing a Contacts list I exported a few days ago. Am using Outlook 2016 on Windows 7. If I import the csv file, the contacts/address book are all blank. I looked at the csv file under Excel and it is blank until way down the sheet...
Microsoft Office
Outlook 2010 problem importing contacts
Hi I have Office 2010 which came bundled with Outlook. What I am trying to achieve is to trasnfer my iPhone contacts to my Outlook on my PC. I go through the iTunes contact sync and in iTunes I select Outlook as the option to sync with. After iTunes tells me the sync is complete, no contacts appear...
Microsoft Office
Importing contacts from outlook into ms fax win7
The import wizard only imports outlook express contact in wab file format. All my contact are in outlook in pst file. Can one convert or something?
Microsoft Office
Importing Contacts to Outlook
Hi, I am having difficulty importing excel data into a contact list. Perhaps you can help me with my immediate problem or my overall goal. The immediate problem: It makes a new contact for every piece of data. So, for instance, I would like to import one contact for every contact in the...
Microsoft Office


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 01:17.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App