Call us: +46 (0)8 410 413 13 Email us: support@ungapped.com
Importing contacts
2024-07-23
To send your mailing or text message you must send it to a contact list that contains at least one contact. These contacts are imported from an external file such as an Excel file.
To import a list
- Create a new list by clicking Create at the top and select “Create new list”
- Give the list a name (and description if you want to)
- Click “New import”, then “Upload File” to upload the file from your computer
- Match any columns from your file with custom fields
- Click “Start import” when ready
- When the import is complete, a red notification will show at the top in the black list – click the notification to download a report of the email addresses that weren’t imported (due to duplicates or invalid email format)
- If you want to double-check that your contacts were imported, navigate to Contacts and search for your list.
You can import Excel files (.xls and .xlsx) and csv files.
Importing contacts to an existing contact list
- Go to Contacts and open the contact list you want to add contacts to
- Click “New import” and proceed as above
If a contact is already in your existing contact list and also in the file you want to import, then the contact will be updated – not added. It is impossible to have duplicates in contact lists (where the email address is unique).
The file structure
The top line (ie, 1A) in your file must contain headings. Top line must not be empty!
It does not matter what order you have your columns in. For example, First Name, Last Name, Email, Company, etc. In total, you can import 10 columns + First Name, Last Name, Mobile Number and Email.
Download an excel file-template »
If you have multiple sheets in your file then only the first sheet will be imported.
If you have duplicates in your file (=duplicated email addresses), only one instance will be imported.
Related manuals:
Name your custom fields »
Add a contact manually »
Create a filtered contact list »
Edit a contact »
Export a contact list »
Manuals
- Manual for surveys & signup forms
- Create a survey
- Survey design
- Get notified when new response
- Required questions
- Show follow-up question (conditions)
- Publish a survey
- Create your own survey template
- Copy a survey
- Copy survey or a survey template to another account
- Matrix question
- Survey question types
- Rating-block
- Video block in survey
- Add an auto-response email
- Add respondents to different lists depending on which option they selected
- Embed a survey on your WordPress website with a plugin
- Group survey responses
- Remind those who did not answer the survey
- Create pre-filled fields
- Find and copy survey URL
- Link to a survey from an email
- Embed a survey on your website via iframe
- Received survey responses
- Delete responses from survey
- Manual for mailings and newsletters
- Copy a previous email
- Preview an email
- Insert links
- Insert survey responses in an email
- Preview an email that contains custom fields
- Do a spam test
- Schedule recurring mailings
- Schedule emails
- Custom fields
- Video block
- Barcodes
- Validate new sender address
- Compilation of e-mail statistics
- Create an email template
- Edit email template
- Copy an email template
- Copy mail/mail template to another account
- A/B testing of content in email
- Newsletter archive
- Send reminder email to inactive contacts
- Using columns in your email
- Always insert alt text to all images in a mailing
- Create a pdf of your email
- Add a background image to a mailing
- Set the subscription category for an email
- Tracking of opens and clicks
- Send Test Emails
- Send mailing
- Insert symbols into the subject line
- UTM tracking
- Change default sender address
- Share on Facebook, Twitter and LinkedIn
- Changing the sender address of a mailing
- Changing the sender name for individual mailing
- Insert the mandatory unsubscribe link and Show as web page link
- Conversion tracking
- Email URL to web version
- Using a pre-header
- Manual for events
- Create the event
- Copy a previous event
- Contact person for the event
- Edit the Sign up form
- Add Registration closes
- Delete answers to sensitive questions
- Add a map image from Google Maps to the event invitation
- Change the name “Speakers” and “Sponsors”
- Landing page: changing logo and footer
- Edit answer in event registration
- Landing page: Design the landing page
- Landing page: change text on button and “You are invited to”
- Countdown timer
- Invitation email
- Guestlist
- Guest list: Add participant manually
- Guestlist: Change the status of a participant
- Guestlist: Change the status of registered to attended
- Guestlist: sort and filter
- “Add this event to your calendar”-link
- Waitlist
- Check-in list
- Check-in list: Add participant manually
- Reminder: not yet registered
- Reminder: “day before” reminder to registered guests
- Evaluation
- Manual for text messages
- Contacts
- Block a contact (sms)
- Importing contacts
- Add a contact manually
- Edit a contact
- Export a contact list
- See Statistics on Bounced Contacts
- Delete a contact
- Show more custom fields in the contact list
- Search for a contact
- Contact filtering (advanced search)
- Block a contact (email)
- Bounced contacts
- Create a filtered contact list
- Images
- Design
- Law, rules and regulations
- More Help Topics
- Hide Ungapped’s free templates
- Forgotten your password?
- Forgotten your user name?
- AI assistent: TRANSLATE SURVEY
- Change your user name
- Add users to your Ungapped account
- Video in emails
- Add a sign up-form to your website
- Error: “Object moved to here”
- Remove users from your Ungapped account
- View the last login date on account users
- SPF-records and DKIM
- What is email authentication and why is it important!
- Color-mark words in mail and questionnaires
- Change password
- Change language
- Switch between accounts
- Print with background image and background color
- I cannot send a test email
- I cannot send my email
- Take a screenshot
- Naming files and documents
