Skip to main content

VAD KAN VI HJÄLPA DIG MED?

Kontakta oss om du inte hittar det du letar efter.

Generic selectors
Exact matches only
Search in title
Search in content
Post Type Selectors
post
portfolio
page
Filter by Categories
Analyze
Contacts
Monitor
Övrigt
Publish
Settings
Contacts

How do I import contacts from a csv file to Excel?

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

Leave a Reply