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.
Using Excel makes it easy to edit the. 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 save CSV file in another format, such as. Go back to the original CSV file and make sure to save it as type. 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 single unit. For example, let's says your data looks like this:. Search for extra quote marks. Use Excel to open the CSV file. All the data will be in column A and the quote marks will be gone. Import contacts to Outlook. Export contacts from Outlook. Manage and organize. Import and export. Create or edit. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you!
Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Yes No. Sorry this didn't help. Thanks for your feedback. I wanted to import some data name, birthday, etc from a CSV file into Outlook The Outlook Contacts Birthday field would not accept the column from the CSV file that contained the birthday date data.
Outlook repeatedly found no birthday, even when I had carefully mapped the fields in the import from CSV to Outlook. The dates are in the format "Nov. For example, April birthdates show first, because the "A" in "April" in first alphabetically among the months.
For this data to display properly as birthdays in Outlook, must the data be in the "Birthday" field? Or, can I use the "User Field 2" to display birthdays correctly? In either case, how can I format the data so that Outlook recognizes them as date entries. In other words, how can I make Outlook sort like this:. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.
0コメント