How to Import Contact Lists with Microsoft Excel
ProProfs Survey Maker provides you various ways to import contact lists for sending surveys to leads and respondents. You can import contact lists from Gmail, Microsoft accounts, MailChimp, Constant Contact, and of course, Excel. With Microsoft Excel, you can upload up to 100 contacts in one go.
Benefits of importing contacts using MS Excel:
- Easily bulk-import contacts
- Share surveys with multiple contacts instantly
- Save time that you would otherwise spend doing it manually
How to Import a Contact List Using Microsoft Excel
Step 1. From your ProProfs Survey Maker dashboard, click on the send icon of the survey you want to share. This is going to open the sharing customization window.
Step 2. On the Email tab, click the MS Excel icon.
NOTE: Read the instructions around the format of the file or download the sample Excel file and fill in the email addresses.
.jpg?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8yMDg2LzM1NDYvY2tmaW5kZXIvaW1hZ2VzL3F1L0V4Y2VsJTIwKDUpLmpwZyIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTcxMzkxNzUyN319fV19&Signature=FSmO2BXLR3y8T3qtbWXZm8elmTAVWgC3AXvlcboFltM0lda~U1Si5nt68y~gVzlazOLZL4Tw90fRvT2bqHP~FsoFY3xkjcdmUVJ9eYe-qYfoiFicOBpj~c7-y9XdIPMekhTGMl87K-iqJ09i9tI4MRSmeK2~aNEu234qQahSqOOKGbc2aFD6J28Tp5nu~h36BvQWGU8drvvCwl3YnILOwrYYV3rsClzbcwnjsxp-5o8WDnDI~QpBfEywesKDmVcrt4nzuVeCHqBxIJSRNVVnR-EX48eSvsV3S7NN-SqsMMW~AAo-hAkFyMJoWwB5YZgAe0kOZpvZph9joguqp0S7Jw__&Key-Pair-Id=K2TK3EG287XSFC)
Below is a screenshot showing a downloaded MS Excel file. Enter the email addresses of your contacts you want to import, as shown below. The header 'Email Addresses' is entered by default, do not change it.
.jpg?Policy=eyJTdGF0ZW1lbnQiOlt7IlJlc291cmNlIjoiaHR0cHM6Ly9kemY4dnF2MjRlcWhnLmNsb3VkZnJvbnQubmV0L3VzZXJmaWxlcy8yMDg2LzM1NDYvY2tmaW5kZXIvaW1hZ2VzL3F1L0V4Y2VsJTIwKDIpLmpwZyIsIkNvbmRpdGlvbiI6eyJEYXRlTGVzc1RoYW4iOnsiQVdTOkVwb2NoVGltZSI6MTcxMzkxNzUyN319fV19&Signature=f~1txcEBKiRc4RYe1F5z5AUoTqGR95kWNULfSfDaoZOxNqYt4nNeh92RD2t66pfdfRWovwy56Pg47NMB6B-qru4lx6OAo1wlr9KsB8914EwiJveW07srFk8kmK61Z2UoKsmwebMYFUs8GCreHB50uFiXhgvG1TfRxgit~90Ub~x8eAY-Pyr3yW3DT28GxjUEP4pUpm1eKOr3HO-80Fc8oMie4rdQFy1AhL7CQRlBZ34HQp8xYXfWhgEKpThCemr2vFOdzeHMTDssrgXRyIyrcmsEf8CTkixmZUFIXOnVht2SWi2-LzdaKZAee3VrwtS1f0l38M~UmUqw81doaG0mtw__&Key-Pair-Id=K2TK3EG287XSFC)
Step 3. Upload the updated MS Excel file to import your contacts.
You will see a confirmation message upon successful upload of email IDs.
That is all about importing contacts lists via Microsoft Excel.