Best Formatting for Csv Uploads of Contacts

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

A CSV (Comma Separated Values) file is a special blazon of file that you can create or edit in Excel. Rather than storing information in columns, CSV files store information separated past commas. When text and numbers are saved in a CSV file, it'southward easy to motion them from one plan to another. For case, you can export your contacts from Google into a CSV file, and and then import them to Outlook.

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

Create a .csv file from another programme or email provider

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

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

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

Create an Excel file and save it equally a CSV file

If you take contact information in a program that doesn't allow you to export it, you can type it in manually.

1. Create a new document in Excel.

2. Add a column heading for each piece of information you lot want to record (for example, first proper noun, last name, email accost, phone number, and birthday), and then blazon the information in the advisable columns.

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

   

4. Select File > Save As.

5. Utilise the drop-downwards box to select CSV (Comma delimited) (*.csv), give your file a name, and so select Salvage.

   

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

Download a template CSV file

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

1. Download this sample .csv file to your computer. When prompted, choose to Save the file to your computer as a CSV file. If y'all save it as an Excel file (.xls or .xlsm) all of the data will be stuffed into one cavalcade!

   

2. On your computer, open Excel.

3. In Excel, go to File > Open > and so navigate to the .csv file you only 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.

   

At that place are a few things to remember when working with this sample CSV file:

• Outlook requires column headings in the commencement row and so don't supervene upon them with something else.
  The language of the column headings must match Outlook's default language. If Outlook'due south default linguistic communication is set to Portuguese, for example, you must edit the column headings so they announced in Portuguese.

  

• You lot can delete the data in rows ii-six (the sample names, telephone numbers, email addresses, etc).

• Yous don't need to enter values for every column. Merely enter the info you want.

• Save the file with a new name equally a CSV file type (.csv). If you use Excel to piece of work in the file, when you save it, Excel volition prompt you a few times with "are you sure you want to relieve it in CSV format?" Always cull Yes. If you lot choose No, the file will be saved in Excel'southward native format (.xlsx) and Outlook won't be able to use information technology to import data.

• Do importing your CSV file with a few contacts to brand certain you similar the results. Later, you can delete the imported contacts, add more than to your CSV file, and import it again.

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

  

Edit a .csv file of contacts yous want to import to Outlook

Allow's say you want to edit a .csv file that you exported from Outlook, and then import it back to Outlook or some other e-mail provider. Using Excel makes information technology easy to edit the .csv file.

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

• Proceed the cavalcade headings in the first row.

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

Trouble: All my data appears in the first column

Here are a few reasons this happens, and things you tin can practise to try to fix this trouble:

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

• Information technology'due south possible that the programme creating the CSV file is putting extra quote marks in the data. Equally a result, Excel treats the data every bit a unmarried unit. For instance, let'south says your information looks like this:

  a, b, c, d - Excel puts each letter in it's own column.

  "a, b, c, d", e - Excel puts a,b,c,d in ane column and e in another column.

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

  If you find extra quote marks, here'south how to set up your file:

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

  2. At present employ the Text to Columns sorcerer to separate the data in column A into individual columns: on the carte bar, choose Data > Text to Columns.

     

  3. Choose Delimited > Side by side. Then choose Commas > Cease.

  4. Save the file as blazon .cvs so you lot can however import it into Outlook.

Run across Likewise

Import contacts to Outlook

Export contacts from Outlook

Need more help?

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