Import feature to transfer PST data files into Outlook MAC 2011 or synchronize Outlook emails with it using IMAP connection. Jan 31, 2019 - Hey, folks are you eagerly searching for ways to import OLM files from Mac environment to Windows Outlook environment? If such is the case,.
A .csv file is a plain text file with its values separated by commas. Open this file first in Excel and use its find/replace feature to locate all quotes and replace them with nothing. Save your file and then you can import it into Outlook.
Hope this helps!
This is not a good universal answer.
When there are commas in a value, the values need to be enclosed with quotes, so just removing quotes won't resolve the issue.
Plus, Mac conversions of csv seem to use a space as a value break point as well. So quotes appear to be necessary when the value is more than one word.
I am having an additional issue decoding CSV issue. (which may actually be what is happening to Josh). The 'Enter' (line end) at the end of a row of values is actually being picked up as the first character of the next value. That is probably why there is no data in Outlook. To the extent you have control over the import routine (via VBA) try removing the first character if it is an Enter. The vba code is like this:
If left(data,1) = chr(13) then data=mid(data,2)
Converting Windows created csv files on a Mac is a real challenge. (My guess from your question, Josh, is that you are going from Windows to Mac.)
Reader Dan Hawes is considering a move to Mail. He writes:
In the August 2014 issue of Macworld you describe a process for moving a Windows Outlook database into a Mac and then into Apple Mail. I’ve been a Microsoft Office for Mac user for a long time but I keep reading about the terrific things that Apple Mail can do, and I’d therefore really like to export my Outlook data and import it into Mail. The process you described for Windows doesn’t work for Mac Outlook email files. Do you know of an alternative process I can use to move my Mac Outlook database into Apple Mail?
I do. You can do this the kind-of-tedious-but-free way, or pay for a solution.
The kind of tedious way is to launch Outlook, select a mailbox that you’d like to move to Mail, and drag it to the desktop. Doing this creates an mbox file (a file format that Mail can import). Repeat this process for all the mailboxes that you wish to import and then place the mbox files into a single folder.
When you’re finished, launch Mail and choose File > Import Mailboxes. A window appears that asks you to choose a source to import data from. Select Files in mbox format and click Continue. A sheet will appear. Use it to navigate to the folder you created for your mbox files and click Choose.
In the resulting window you’ll see all the mbox files it contains, each with a checkmark next to it. If you don’t wish to import messages from a particular mbox, just uncheck it. Click Continue and the messages within the checked mbox files will be imported into Mail. As Mail will tell you, you’ll find the messages inside an Import folder within its list of mailboxes.
Not only is this a bit tiresome, but it also does nothing for any contacts and events you’ve stored in Outlook. If you’re looking for an all-in-one answer you might instead pursue a paid solution. I’ve found a couple of utilities on the Mac App Store that will transfer this data for you but since I haven’t tested them, I won’t recommend any one by name. Search for “OLM” and you’ll find a few options.
To comment on this article and other Macworld content, visit our Facebook page or our Twitter feed.