csv file you just downloaded to your computer. In Excel, go to File > Open > and then navigate to the. xlsm) all of the data will be stuffed into one column! If you save it as an Excel file (.xls or. When prompted, choose to Save the file to your computer as a CSV file. If you'd like to start with a blank CSV file, you can download the sample file below.ĭownload this sample. You can now use this new CSV file to import your contacts into Outlook. Use the drop-down box to select CSV (Comma delimited) (*.csv), give your file a name, and then select Save. When you're done, your Excel file should look something like this. If you have contact information in a program that doesn't allow you to export it, you can type it in manually.Īdd a column heading for each piece of information you want to record (for example, first name, last name, email address, phone number, and birthday), and then type the information in the appropriate columns.

Create an Excel file and save it as a CSV file If you want to create a CSV file for your contacts manually, you can do that one of two ways. csv file for importing contacts to Outlook When exporting from one Outlook profile to import into another profile, you can choose to export into a Comma Separated Values file or an Outlook Data File (.pst). Gmail offers you the choice of a Google CSV file, an Outlook CSV file, or vCards.

When you export your contacts from another program, for example, from Gmail, you can usually select one of several formats. csv file from another program or email provider For example, you can export your contacts from Google into a CSV file, and then import them to Outlook.įor assistance importing a list of calendar entries into Outlook, see Import and export Outlook email, contacts, and calendar. When text and numbers are saved in a CSV file, it's easy to move them from one program to another. Rather than storing information in columns, CSV files store information separated by commas.

A CSV (Comma Separated Values) file is a special type of file that you can create or edit in Excel.

How to convert a file to csv format