Comma-separated values file

For assistance importing a list of calendar entries into Outlook, see Import and export Outlook email, contacts, and calendar. When you export your contacts from another program, for example, from Gmail, you can usually select one of several formats. 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.

If you have contact information in a program that doesn't allow you to export it, you can type it in manually. Add 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.

When you're done, your Excel file should look something like this. Download this sample. When prompted, choose to Save the file to your computer as a CSV file. If you save it as an Excel file. To find the. Click on the. The language of the column headings must match Outlook's default language. If Outlook's default language is set to Portuguese, for example, you must edit the column headings so they appear in Portuguese.

Save the file with a new name as a CSV file type. If you use Excel to work in the file, when you save it, Excel will prompt you a few times with "are you sure you want to save it in CSV format?

If you choose No, the file will be saved in Excel's native format. Practice 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, here's what it would look like in Outlook on the web for Microsoft Let's say you want to edit a. Follow us. Contact us. Help Articles. Contact Us. This website uses cookies to improve your experience.

We'll assume you're ok with this, but you can opt-out if you wish. Close Privacy Overview This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website.

We also use third-party cookies that help us analyze and understand how you use this website. Then you can see the comma separated values in selected cells are split into rows as bellow screenshot shown.

T he Split Cells utility of Kutools for Excel can help you split comma separated values into rows or columns easily. And in the Specify a separator section, select the Other option, enter the comma symbol into the textbox, and then click the OK button.

And then another prompt box will pop out to remind you select a cell to output the result, see screenshot:. If you want to have a free trial day of this utility, please click to download it , and then go to apply the operation according above steps. Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password?

Password Reset. Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account. About Us Our team. How to split comma separated values into rows or columns in Excel?