This is what I found for doing it 'on the cheap'. This is not flawless by any means, so please don't do this with your eyes closed;-) Do pay attention to the warning about uploading duplicate entries in Google. I specifically did this for migrating data up to Google Apps, but having done similar things for my own personal Google account, I don't believe there's much difference. I decided to write this up because it still seemed like a largely unanswered question out there. The Mac version of Outlook certainly doesn't make any of this much easier, what with formats like OLM! So much so that there are vendors of OLM to PST conversion software.
Oh for those of you wondering why I didn't use the, it was because our hosted MS Exchange service only gave us limited access. Migrating Contacts: In Outlook:. Go to File - Export. Select the 'Contacts to a list (tab-delimited text)' radio button.
Step 1: Open Outlook program, go to File > Account settings > Data files. Click Add data file and type in a name for your data file. Then close it. Step 2:: In My Contacts, right-click and choose New Folder, type a name for Contacts folder. Make sure contact item is choosed for the folder contains, then select the new.pst file, click OK. Sep 12, 2018 - Export a vCard file of Contacts from Outlook on a Mac for import into. Note: Exporting your contacts from Outlook 2016 for Mac using the steps.
Note where you've saved that file In Excel:. Open Excel, then open the file you saved in the last step. Excel will prompt you with the Text Import Wizard. Click through ensuring that Tab is the selected Delimiter. Unfortunately, since the export isn't perfect, it's a good idea to eyeball this list of contacts and ensure that the data appears to be in the right columns. First names appear in the First Name column, etc.
Now save the file as a CSV file: click File - Save As. Select Comma Separated Values (.csv) as the Format (near the top of that list), and save. Note where you've saved that file. In Google Apps:. Navigate to the Contacts section (either via Gmail) or the top navigation menu bar. Click the More menu (with the down-arrow next to it) and select Import.
Use the Choose File button to select the CSV file you saved in the last section, then click Import. Note: if you need to edit your CSV file and re-import to Google Contacts, it's best to delete all of the contacts from Google before performing the import again. This is because Google doesn't overwrite the original contacts, but creates new contacts, which will create duplicates in most cases. Migrating Calendar: In Outlook:. Go to Outlook - Preferences. Click Sync Services.
Check the Calendar box and ensure that your main account is checked under 'accounts to sync'. Now close that dialog box (red circle).
You will get a prompt titled 'You have turned on Sync Services'. In Calendar:.
Open Calendar (used to be called iCal). Ensure that your calendar(s) from Outlook are there. Right-click on the calendars you want to copy and select Export. Keep or change the name and click Export In Google Calendar:. After logging into your Google Apps account, select Calendar from the top menu. Click the drop-down menu next to the gear icon (top right-hand corner) and select Settings.
Click the Calendars link (top left-hand corner). Now you either create a new calendar or import into the default one that uses your name as the title. Click Import Calendar. Browse to the.ics file on your computer which you had previously saved in step #4 above.
Select the calendar you want to import into and click Import. You should see that some # of events were processed, and then see those events when you browse back to the main Calendar page.
Hope this helps someone out there!
Don’t able to import Excel contacts into Outlook Address Book, follow the easiest method to move excel contacts to Microsoft Outlook Application. As various errors occur while exporting contacts since excel have a different file format called.xls extension. As Excel file used for different purposes rather than storing an address contacts list of the user, but still helpful for Outlook user to import contacts to Outlook Address Book. Since various editions are available, such as Outlook 2016, 2013 and 2010,2007 and many more, but the method we are discussing in below section applies to all the versions of Outlook. As Various errors faced by Outlook user due to different editions such as 'Missing Contact Information', 'Protocol Error', 'MAPI Error', To know more about error related during importing excel contacts into Outlook 2013 and other editions.
Method to Import Excel Contacts into Outlook The Quickest manual method to move Excel contacts list to Outlook using the CSV File format. Since CSV Format supported by CSV Format and allow a user to import CSV File data. If we convert the contacts stored in Excel format to CSV Format, then we can use the import/Export option of the Outlook Application to move Excel Contact List. For more ease, we try to explain the complete method using Screenshots so that without any problem, a naive, as well as Expert Outlook user. If still, you can, then can directly move contacts using any third party software. Step1: Open the input file in Excel application and similar to below image, save the contacts of the user in Excel file format, user don't get any kind of Mapping error during the Conversion process.
Note: If the option of “Import File.csv into folder Contacts is not selected automatically by the Outlook, then there are some chances of error in input CSV File. Some time while converting data into CSV format, instead of using (,) values and Delimiter (;) is used due to some default settings. So the user needs to be careful while performing the Conversion process. Step 11: In below section, you can view the Mapping Interface, where Outlook user needs to map the attributes of CSV file of “From” option to “Microsoft Office Outlook” Application. A user needs to Select “One field” from CSV File for Example in below section, we map the attributes like “Phone Number ” with the “Business Phone” Field and click “Next” and map all the attributes similarly till all the attributes get mapped.
Step 13: When the process gets completed, you can view the imported contacts into Outlook Address Book. Final Word As you can see manual method are able to move contacts of Excel to Outlook 2016 / 2013 and below editions, as method works on all versions of Outlook Software. But if a user doesn't want to use this method and don't want to convert first into CSV Format and then follow the above procedure, a user can directly import Contacts from Excel into Outlook Application, using Third Party utility tools and the best tool for this conversion process is an Excel to vCard Converter.
Tool directly move the Excel contacts list to Outlook Address Book, without converting into CSV Format. It also offers an option to map the attributes similar to Outlook application, so that user can map the attributes according to their need and also offers an option to remove duplicity issues.