Can't import contacts into Outlook from Excel

Posted by Michael on Super User See other posts from Super User or by Michael
Published on 2011-11-30T04:44:49Z Indexed on 2011/11/30 10:05 UTC
Read the original article Hit count: 372

Filed under:

outlook-2010

|

excel-2010

I run MS Office 2010. I have all contacts from a previous Outlook 2010 saved in an Excel sheet. I have tried dozens of time to import, but when Outlooks is supposed to do the mapping of the columns I only have one column in my CSV-file: firstname;middlename;surname, etc. It means I cannot map the data correctly.

I have tried saving in MS-DOS and Tab and it does not get better. I have tried saving on another computer and it does help either. ALso tried importing to Gmail with same result.

Can anyone help?

© Super User or respective owner

Related posts about outlook-2010

iPhone - Outlook 2010 sync'd items

as seen on Super User - Search for 'Super User'
I'm not sure if this is a problem with Outlook 2010, or the fact that I don't have an Exchange box, or the fact that I have two MAPI mailboxes (both using Outlook Live Connector), or something else... so let me just describe the situation. iTunes says that I'm sync'ing happily, all the Calendar,… >>> More
Unable to install ExchangeCdo with Outlook 2010

as seen on Server Fault - Search for 'Server Fault'
We recently got the Blackberry Express Server for our small home business and linked it in with our Exchange 2010 server. All is well except for calendar syncing. From what I can tell I require the ExchangeCdo patch. Except when I go to install it, it errors saying I require Outlook 2007. I have Outlook… >>> More
Ask How-To Geek: Fixing the Windows Boot Record, Sharing Mac Folders with Windows, and Reviving the Outlook Reminder Bell

as seen on How to geek - Search for 'How to geek'
You’ve got questions and we’ve got answers. Today we look at how to boot into Windows after uninstalling Linux, sharing folders between a Mac and a Windows computer, and how to reinstate the missing Outlook reminder bell. Once a week we dip into our mailbag and help readers solve their problems,… >>> More
Outlook 2010 Reminders - Can't dismiss or snooze.

as seen on Super User - Search for 'Super User'
I seem to have encountered a zombie reminder that doesn't want to die. A few weeks ago I had an issue where I had a reminder from weeks gone by pop up in my Reminder window in Outlook 2010. Due in: 2 weeks overdue. Weird, I thought. So I did the usual 'Dismiss'. 2 seconds later: "1 Reminder, Due… >>> More
Outlook 2010: People pane not working well

as seen on Super User - Search for 'Super User'
I really like the new People pane in Outlook 2010. Not for the "Social" features, but for finding related emails and attachments. But.. I does not work. It is totally broken. On some people does not show any mail, and only some mails in others. I've tried re-indexing and recreating the profile,… >>> More

Related posts about excel-2010

Sum and chart in excel

as seen on Super User - Search for 'Super User'
I have data like the following: Both Hour and Count are columns in an excel file. Hour Count 17 79 18 122 19 123 20 142 21 150 22 78 23 15 13 33 14 33 15 40 16 33 17 56 18 46 19 35 20 67 21 65 22 45 23 36 What I want is to create a chart that shows over… >>> More
Offset the tickmarks of a secondary axis

as seen on Super User - Search for 'Super User'
I would like to offset the tickmarks of a secondary axis in excel WITHOUT changing the minimum. Here is a very complicated VBA class that apparently solves the issue but I would like a solution that doesn't require me to construct my entire chart in VBA. Here is an example of what I mean (I removed… >>> More
Find a non-case-sensitive text string within a range of cells

as seen on Super User - Search for 'Super User'
I've got a bit of a problem to solve in Excel, and I'm not quite sure how to go about doing it. I've done a few searches online, and haven't really found any formulas that seem to be useful. Here's the situation (simplified just a bit, for the purpose of this question): I have data in columns A-E… >>> More
How can I split Excel data from one row into multiple rows

as seen on Super User - Search for 'Super User'
Good afternoon, Is there a way to split data from one row and store to separate rows? I have a large file that contains scheduling information and I'm trying to develop a list that comprises each combination of course, day, term and period per line. For example I have a file similiar to this: Crs:Sn… >>> More
Keyboard shortcut in excel for expanding the pivot table row?

as seen on Super User - Search for 'Super User'
I'm able to expand/collapse the row in the pivot table with mouse by: right clicking on cell in the first column of the row + selecting "Expand/Collapse"/"Expand" from context menu. or double clicking on the cell in the first column of the row Is there a keybord shortcut for same action? I'm using… >>> More