Upload Contacts to Microsoft Outlook in Vcf or Csv?

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 Function for business organization Microsoft 365 admin Excel 2010 Outlook 2010 Outlook 2007 More...Less

A CSV (Comma Separated Values) file is a special type of file that you can create or edit in Excel. Rather than storing information in columns, CSV files store data separated by commas. When text and numbers are saved in a CSV file, it's easy to motion them from 1 plan to some other. For instance, you can consign your contacts from Google into a CSV file, and and so import them to Outlook.

For assistance importing a list of calendar entries into Outlook, come across Import and export Outlook electronic mail, contacts, and calendar.

Create a .csv file from another program or email provider

When you lot export your contacts from another programme, for example, from Gmail, you can usually select one of several formats. Gmail offers you the pick of a Google CSV file, an Outlook CSV file, or vCards. When exporting from 1 Outlook profile to import into another profile, you can choose to export into a Comma Separated Values file or an Outlook Information File (.pst).

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

If you desire to create a CSV file for your contacts manually, you can do that one of two ways.

Create an Excel file and salvage information technology every bit a CSV file

If yous accept contact information in a programme that doesn't allow you to consign it, you tin type it in manually.

1. Create a new certificate in Excel.

2. Add a cavalcade heading for each slice of information you lot desire to tape (for example, first name, final proper name, electronic mail address, phone number, and birthday), so type the information in the appropriate columns.

3. When you're done, your Excel file should wait something similar this.

   

4. Select File > Salvage Equally.

5. Apply the drop-down box to select CSV (Comma delimited) (*.csv), requite your file a name, and then select Salvage.

   

6. You lot can now employ this new CSV file to import your contacts into Outlook.

Download a template CSV file

If you'd like to showtime with a blank CSV file, you can download the sample file below.

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

   

2. On your reckoner, open up Excel.

3. In Excel, go to File > Open > and then navigate to the .csv file you just downloaded to your figurer. To find the .csv file, exist certain to wait at All Files. Click on the .csv file to open it.

   

There are a few things to call up when working with this sample CSV file:

• Outlook requires column headings in the first row and so don't supervene upon them with something else.
  The language of the cavalcade headings must lucifer Outlook's default language. If Outlook's default language is set up to Portuguese, for example, you must edit the column headings so they appear in Portuguese.

  

• You tin can delete the data in rows 2-6 (the sample names, telephone numbers, electronic mail addresses, etc).

• Yous don't need to enter values for every cavalcade. Only enter the info yous want.

• Save the file with a new name as a CSV file type (.csv). If you employ Excel to work in the file, when you salvage it, Excel will prompt you a few times with "are you certain yous want to salve it in CSV format?" Always choose Yes. If you choose No, the file volition be saved in Excel'southward native format (.xlsx) and Outlook won't be able to utilize it to import information.

• Exercise importing your CSV file with a few contacts to make sure y'all similar the results. Later, yous can delete the imported contacts, add together more than to your CSV file, and import it again.

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

  

Edit a .csv file of contacts y'all want to import to Outlook

Let's say you want to edit a .csv file that y'all exported from Outlook, then import it back to Outlook or some other electronic mail provider. Using Excel makes information technology piece of cake to edit the .csv file.

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

• Keep the cavalcade headings in the first row.

• When yous save information technology, Excel will prompt you a few times with "are you certain you want to save information technology in CSV format?" Always choose Aye. If you lot cull No, the file volition be saved in Excel's native format (.xlsx) and information technology won't piece of work for importing into Outlook.

Problem: All my data appears in the first column

Hither are a few reasons this happens, and things you tin exercise to try to ready this problem:

• If you relieve CSV file in some other format, such equally .xls, .xlsx, or .xlm, all of the data volition appear in the start column. Go back to the original CSV file and make certain to save it equally type .csv.

• Information technology's possible that the program creating the CSV file is putting extra quote marks in the data. As a outcome, Excel treats the data as a single unit of measurement. For example, let's says your data looks similar this:

  a, b, c, d - Excel puts each alphabetic character in it'south own column.

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

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

  If you find actress quote marks, here's how to fix your file:

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

  2. Now apply the Text to Columns wizard to carve up the data in cavalcade A into individual columns: on the carte bar, choose Data > Text to Columns.

     

  3. Cull Delimited > Next. Then choose Commas > Finish.

  4. Save the file every bit type .cvs and so yous can still import it into Outlook.

Encounter Also

Import contacts to Outlook

Export contacts from Outlook

Need more help?

wigginsuposs1994.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