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. Note where you've saved that file In Excel:.
I need to export SOME of my contact folders from Outlook to a CSV file (to import into another mail program). I check the boxes of the folders I want to export, but that doesn't matter, it exports ALL the contacts in ALL the folders. The PC instructions are not helpful for a MAC. Import and export Outlook email, contacts, and calendar Outlook for Office 365 Outlook for Office 365 for Mac Outlook 2019 Outlook 2016 Outlook 2013 Outlook 2010 Outlook 2016 for Mac Outlook.com Outlook 2019 for Mac More.
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!
Most calendar applications, like Outlook Calendar or Apple Calendar, let you export your events. Open the calendar application where your events are currently stored.
It's often easier to do this from a computer than a phone or tablet. Look for an option to Export. If you're given the option to choose from different file formats, choose CSV.
If you're using an Apple device, choose vCard. For more help, look in your calendar application's help center or try using the words export calendar in your search. Your file will be saved on your computer where your downloads are usually saved, or the place you chose while saving. Now you can move on to the next section to import your calendar.
If you have more than one Google Account, you can export your calendars from one account and import them into another. On a computer, sign in to the Google Account that you want to export from. You can only export from a computer, not a phone or tablet. Follow the.
You'll need to download an ICS file to your computer. Sign in to the Google Account where you want to import. To learn how to import, see the next step. Note on sync: Imported events won't stay in sync between your two accounts.
If you want your calendars to sync, you should with the other account instead of exporting your events. Step 2: Import events into Google Calendar After you've exported your events, you can import them into Google Calendar.
You can import ICS and CSV files on a computer. You can also import ICS files on an Android phone or tablet. In the top right, click Settings Settings. Click Import & Export. Click Select file from your computer and select the file you exported. The file should end in 'ics' or 'csv'. Choose which calendar to add the imported events to. By default, events will be imported into your primary calendar.
Click Import. If you're using a ZIP file, find it on your computer and open it. You'll see ICS files for each of your calendars. Take the individual files out of the ZIP file, and import each ICS file individually. Note: Repeating events might not show up that way if you import them from a CSV file, but they'll be on your calendar as a series of one-time events.
Advanced: Create or edit CSV or iCal files before importing. You can import CSV (Comma Separated Values) files into Google Calendar.
If you get an error while importing a CSV file, you might be able to fix the formatting. Open an existing CSV file or create a new one using a spreadsheet editor like. The first row of your spreadsheet will include headers like Subject and Start Date. The headers must be in English. See the list below for the correct headers.
Each row below the header row represents an event. See example: Subject Start date Start time Final exam 10:00 AM. When you're done, save the file as a.csv file. You can then import the file into Google Calendar using the directions above. Headers and event formatting in CSV files Only the first two headers in this list are required, the rest are optional. Important: The headers must be in English as shown below. If any event details have commas (like the location example below), you can include them by using quotation marks around the text.
Subject The name of the event, required. Example: Final exam. Start Date The first day of the event, required.
Example:. Start Time The time the event begins. Example: 10:00 AM. End Date The last day of the event.
Example:. End Time The time the event ends. Example: 1:00 PM. All Day Event Whether the event is an all-day event. Enter True if it is an all-day event, and False if it isn't.
Example: False. Description Description or notes about the event. Example: 50 multiple choice questions and two essay questions. Location The location for the event. Example: 'Columbia, Schermerhorn 614'. Private Whether the event should be marked private. Enter True if the event is private, and False if it isn't.
Example: True The examples above would create the event 'Final exam' on May 30, 2020 from 10:00 AM to 1:00 PM. The location would be 'Columbia, Schermerhorn 614,' the description would be '50 multiple choice questions and two essay questions,' and it would be a private event. ICalendar files are a standard calendar format used to transfer calendar data. If you get an error while importing an iCAL ('ics') file, you might be able to fix the formatting. Open an existing ICAL file or create a new one. You'll need to use a text editing application that can save iCalendar files. Format your file according to the guidelines below.
You can export an ICAL file from Google Calendar to use as an example. When you're done, save the file as an iCalendar ('ics') file. Format iCalendar files The first line in an iCalendar file must always be the header BEGIN:VCALENDAR. This must be followed by other header information, including VERSION:2.0 and 'PRODID:'. The last line of the file must be the footer END:VCALENDAR.
Between these lines is where all the events in the calendar are entered. Each event must be between BEGIN:VEVENT and END:VEVENT lines. If you need to manually edit an iCalendar file, make sure that each file contains the header and footer. If you're not sure where your header ends, just copy and paste the text until one line above BEGIN:VEVENT, which is where your header ends and your event data starts. Here's what an iCalendar file looks like.
An iCalendar file can also have more information, but these are the required parts. BEGIN:VCALENDAR VERSION:2.0 PRODID: (other header information goes here) BEGIN:VEVENT (event details) END:VEVENT BEGIN:VEVENT (event details) END:VEVENT END:VCALENDAR Troubleshooting Get help fixing.
Related articles.