How to Upload an Outlook Calendar .cvs File Into Hotmail Calendar

Create or edit .csv files to import into Outlook

Excel for Microsoft 365 Outlook for Microsoft 365 Outlook 2021 Outlook 2019 Excel 2016 Outlook 2016 Excel 2013 Outlook 2013 Microsoft 365 admin Excel 2010 Outlook 2010 Outlook 2007 Function for business More...Less

A CSV (Comma Separated Values) file is a special blazon of file that you tin create or edit in Excel. Rather than storing data in columns, CSV files store data separated by commas. When text and numbers are saved in a CSV file, it'south like shooting fish in a barrel to movement them from ane program to another. For example, you tin can export your contacts from Google into a CSV file, and so import them to Outlook.

For assistance importing a list of calendar entries into Outlook, see Import and export Outlook email, contacts, and agenda.

Create a .csv file from some other program or email provider

When you export your contacts from another programme, for case, from Gmail, you tin ordinarily select one of several formats. Gmail offers you the option of a Google CSV file, an Outlook CSV file, or vCards. When exporting from one Outlook contour to import into another contour, you can choose to consign into a Comma Separated Values file or an Outlook Data File (.pst).

Download and open a sample .csv file for importing contacts to Outlook

If you want to create a CSV file for your contacts manually, y'all can do that one of 2 means.

Create an Excel file and save it as a CSV file

If you have contact data in a programme that doesn't allow you to export it, y'all can blazon it in manually.

1. Create a new document in Excel.

2. Add a cavalcade heading for each piece of information you desire to record (for instance, first name, last proper noun, email address, phone number, and birthday), and and so type the data in the appropriate columns.

3. When y'all're done, your Excel file should look something similar this.

   

4. Select File > Save Every bit.

5. Utilize the drop-down box to select CSV (Comma delimited) (*.csv), give your file a name, and then select Save.

   

6. Y'all tin can now apply this new CSV file to import your contacts into Outlook.

Download a template CSV file

If you'd like to start with a bare CSV file, you lot can download the sample file beneath.

1. Download this sample .csv file to your computer. When prompted, cull to Relieve the file to your calculator as a CSV file. If you save it as an Excel file (.xls or .xlsm) all of the data will be stuffed into one column!

   

2. On your computer, open Excel.

3. In Excel, become to File > Open > and and then navigate to the .csv file you just downloaded to your computer. To find the .csv file, be sure to look at All Files. Click on the .csv file to open information technology.

   

In that location are a few things to call back when working with this sample CSV file:

• Outlook requires column headings in the first row so don't supersede them with something else.
  The linguistic communication of the cavalcade headings must lucifer Outlook'southward default language. If Outlook's default language is fix to Portuguese, for example, y'all must edit the cavalcade headings and so they announced in Portuguese.

  

• You tin delete the data in rows 2-6 (the sample names, phone numbers, email addresses, etc).

• You don't need to enter values for every column. Simply enter the info you lot want.

• Relieve the file with a new name equally a CSV file type (.csv). If y'all use Excel to work in the file, when you salve it, Excel will prompt you a few times with "are you lot certain y'all want to save it in CSV format?" Always choose Yes. If y'all choose No, the file will be saved in Excel's native format (.xlsx) and Outlook won't be able to utilize it to import data.

• Do importing your CSV file with a few contacts to make sure you like the results. Afterwards, you can delete the imported contacts, add more to your CSV file, and import it again.

  If you were to import the data in the sample CSV file, hither's what it would await like in Outlook on the web for Microsoft 365:

  

Edit a .csv file of contacts you desire to import to Outlook

Let'due south say you lot desire to edit a .csv file that you exported from Outlook, and then import information technology back to Outlook or some other electronic mail provider. Using Excel makes information technology like shooting fish in a barrel to edit the .csv file.

Here are a few things to remember when editing a .csv file:

• Keep the cavalcade headings in the kickoff row.

• When yous save it, Excel will prompt yous a few times with "are y'all sure y'all want to save it in CSV format?" E'er choose Aye. If y'all choose No, the file will exist saved in Excel's native format (.xlsx) and it won't work for importing into Outlook.

Trouble: All my data appears in the first cavalcade

Here are a few reasons this happens, and things you can exercise to try to fix this problem:

• If you lot save CSV file in another format, such as .xls, .xlsx, or .xlm, all of the data will appear in the first column. Go dorsum to the original CSV file and brand certain to save it as type .csv.

• It's possible that the program creating the CSV file is putting extra quote marks in the data. As a result, Excel treats the data as a unmarried unit. For instance, let'due south says your data looks like this:

  a, b, c, d - Excel puts each letter of the alphabet in it's own cavalcade.

  "a, b, c, d", e - Excel puts a,b,c,d in one cavalcade and due east in another column.

  To see if this is the problem with your file, open your file in Notepad: Right-click on the CSV file in Windows, cull Open With > Notepad. Search for actress quote marks.

  If yous find extra quote marks, here's how to fix your file:

  1. Use Excel to open the CSV file. All the data will exist in cavalcade A and the quote marks volition be gone.

  2. Now utilise the Text to Columns wizard to split up the data in cavalcade A into private columns: on the carte bar, cull Data > Text to Columns.

     

  3. Choose Delimited > Adjacent. And so choose Commas > Finish.

  4. Save the file as type .cvs so yous tin can still import it into Outlook.

See Also

Import contacts to Outlook

Consign contacts from Outlook

Need more help?

dicklifecyll.blogspot.com

Source: https://support.microsoft.com/en-us/office/create-or-edit-csv-files-to-import-into-outlook-4518d70d-8fe9-46ad-94fa-1494247193c7

Share this post