On a Windows PC:
– Open a new empty workbook in Excel without opening the downloaded file
– Select to open the file, if the Text Import Wizard is not automatically started, import textfile from Data/import
3. Select to import Delimited data, set Comma (,) as delimiter and quotation mark (“) as the text qualifier
– Click on From Text and choose your file
– Marking the file and clicking on Import will open a window where you choose Next
– Mark Delimited and make sure that only Comma is activated as delimiter
– File origin should be Unicode (UTF-8)
– Confirm the remaining steps.
On a Mac computer:
– Open a new empty workbook in Excel without opening the downloaded file
– Click on Data in Excel and choose Get External Data and then Import Text File
– Choose your file and click on Get Data
– Mark Delimited and file origin should be Unicode (UTF-8)
– In the next step, mark Comma (,) as delimiter and the quotation mark (“) as text qualifier
– Confirm the remaining steps
You can find a more detailed instruction on the Microsoft support page.
Learn more about Contacts in our Guides
or get information on how to Download your contact lists