---
title: Excel template for importing answer options
description: You can use an excel sheet to add multiple answer options.
---

[Skip to content](https://portal.snapaddy.com/knowledge/excel-template-for-importing-answer-options#main-content)

- [English](https://portal.snapaddy.com/knowledge/excel-template-for-importing-answer-options)
- [Deutsch](https://portal.snapaddy.com/de/knowledge/excel-vorlage-für-den-import-von-antwortoptionen)

English

Show submenu for translations

[![AppSignet](https://portal.snapaddy.com/hs-fs/hubfs/AppSignet.png?width=60&height=60&name=AppSignet.png)](https://portal.snapaddy.com/knowledge?hsLang=en)

Open main navigation

Close main navigation

- - [English](https://portal.snapaddy.com/knowledge/excel-template-for-importing-answer-options)
    - [Deutsch](https://portal.snapaddy.com/de/knowledge/excel-vorlage-für-den-import-von-antwortoptionen)

  English
  
  Show submenu for translations
- [snapAddy website](https://www.snapaddy.com/)

[snapAddy website](https://www.snapaddy.com/)

 snapAddy Knowledge base - How can we help?

- There are no suggestions because the search field is empty.

1. [snapAddy Knowledge Base](https://portal.snapaddy.com/knowledge?hsLang=en)
2. [snapAddy VisitReport](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en)
3. [Working within the VisitReport Dashboard](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#working-within-the-visitreport-dashboard)

# Excel template for importing answer options

## You can use an excel sheet to add multiple answer options.

Sometimes you need to provide a large number of answer options for a question. In order to insert these more quickly, it is possible to upload an Excel spreadsheet. 

This works as follows:

1. Call up the questionnaire in the desired event.
   
   ![](https://portal.snapaddy.com/hs-fs/hubfs/image-png-Aug-11-2025-09-51-03-0738-AM.png?width=670&height=410&name=image-png-Aug-11-2025-09-51-03-0738-AM.png)
2. Go to the question to which you would like to add several answer options and click on "Add option" or on the pencil in the bar.
   
   ![](https://portal.snapaddy.com/hs-fs/hubfs/image-png-Aug-11-2025-11-47-14-5885-AM.png?width=600&height=196&name=image-png-Aug-11-2025-11-47-14-5885-AM.png)
3. Select the "Answer options" tab.
4. Click on "Excel import" or "Use Excel import!" at the bottom of the pop-up.
   
   ![](https://portal.snapaddy.com/hs-fs/hubfs/image-png-Aug-11-2025-11-48-57-2314-AM.png?width=600&height=598&name=image-png-Aug-11-2025-11-48-57-2314-AM.png)
5. Add an Excel file.
   
   ![](https://portal.snapaddy.com/hs-fs/hubfs/image-png-Aug-11-2025-11-49-37-9659-AM.png?width=600&height=417&name=image-png-Aug-11-2025-11-49-37-9659-AM.png)
6. Assign the correct columns.
7. Click on "Import options" and then on "Save changes".
   
   ![](https://portal.snapaddy.com/hs-fs/hubfs/image-png-Aug-11-2025-11-55-26-3207-AM.png?width=600&height=356&name=image-png-Aug-11-2025-11-55-26-3207-AM.png)  
   ![](https://portal.snapaddy.com/hs-fs/hubfs/image-png-Aug-11-2025-11-53-32-5114-AM.png?width=600&height=640&name=image-png-Aug-11-2025-11-53-32-5114-AM.png)

You can use the template attached here to import answer options, but you can also use your own Excel spreadsheet with a similar structure.

[Download Excel template](https://downloads.snapaddy.com/mapping/excel-templates/import-answer-options-xslx/snapADDY+-+template+for+importing+answer+options.xlsx)

There is a limit of 50 answer options for single selection or multi selection. If this is exceeded, you cannot add the imported options.  In this case, it is advisable to select the question types typeahead single selection or typeahead multi selection.

If you have any further questions, please feel free to contact [support@snapaddy.com](mailto:support@snapaddy.com) or your Customer Success Manager.

- [Global Settings](https://portal.snapaddy.com/knowledge/global-settings?hsLang=en#main-content)

    - [Frequently Asked Questions (FAQ)](https://portal.snapaddy.com/knowledge/global-settings?hsLang=en#frequently-asked-questions-faq)
    - [Profile Settings](https://portal.snapaddy.com/knowledge/global-settings?hsLang=en#profile-settings)
    - [User Management](https://portal.snapaddy.com/knowledge/global-settings?hsLang=en#user-management)
    - [General Settings](https://portal.snapaddy.com/knowledge/global-settings?hsLang=en#general-settings)
- [Video Tutorials](https://portal.snapaddy.com/knowledge/video-tutorials?hsLang=en#main-content)

    - [snapAddy VisitReport](https://portal.snapaddy.com/knowledge/video-tutorials?hsLang=en#snapaddy-visitreport)
    - [snapAddy LeadResearch](https://portal.snapaddy.com/knowledge/video-tutorials?hsLang=en#snapaddy-leadresearch)
    - [snapAddy BusinessCards](https://portal.snapaddy.com/knowledge/video-tutorials?hsLang=en#snapaddy-businesscards)
    - [snapAddy Quick Tips](https://portal.snapaddy.com/knowledge/video-tutorials?hsLang=en#snapaddy-quick-tips)
    - [CRM Integrations](https://portal.snapaddy.com/knowledge/video-tutorials?hsLang=en#crm-integrations)
- [CRM Integrations](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#main-content)

    - [Frequently Asked Questions (FAQ)](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#frequently-asked-questions-faq)
    - [CRM System integration (Mapping)](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#crm-system-integration-mapping)
    - [Salesforce](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#salesforce)
    - [MS Dynamics 365 CRM](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#ms-dynamics-365-crm)
    - [SAP Sales Cloud](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#sap-sales-cloud)
    - [HubSpot CRM](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#hubspot-crm)
    - [Pipedrive](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#pipedrive)
    - [Sugar CRM](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#sugar-crm)
    - [Suite CRM](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#suite-crm)
    - [SAGE CRM](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#sage-crm)
    - [Close CRM](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#close-crm)
    - [weclapp](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#weclapp)
    - [snapAddy API](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#snapaddy-api)
    - [Zapier](https://portal.snapaddy.com/knowledge/crm-integrations?hsLang=en#zapier)
- [snapAddy BusinessCards](https://portal.snapaddy.com/knowledge/snapaddy-businesscards?hsLang=en#main-content)

    - [Frequently asked questions (FAQ)](https://portal.snapaddy.com/knowledge/snapaddy-businesscards?hsLang=en#frequently-asked-questions-faq)
    - [First steps](https://portal.snapaddy.com/knowledge/snapaddy-businesscards?hsLang=en#first-steps)
    - [Export](https://portal.snapaddy.com/knowledge/snapaddy-businesscards?hsLang=en#export)
    - [Digital business cards](https://portal.snapaddy.com/knowledge/snapaddy-businesscards?hsLang=en#digital-business-cards)
    - [BusinessCards Quick Tips](https://portal.snapaddy.com/knowledge/snapaddy-businesscards?hsLang=en#businesscards-quick-tips)
- [snapAddy VisitReport](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#main-content)

    - [Frequently Asked Questions (FAQ)](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#frequently-asked-questions-faq)
    - [Working with the VisitReport app](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#working-with-the-visitreport-app)
    - [Working within the VisitReport Dashboard](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#working-within-the-visitreport-dashboard)
    - [Export (CRM, PDF, Excel ...)](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#export-crm-pdf-excel)
    - [Inventory Data](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#inventory-data)
    - [Video instructions](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#video-instructions)
    - [E-Mail Integration](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#e-mail-integration)
    - [Meetings](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#meetings)
    - [VisitReport Quick Tipps](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#visitreport-quick-tipps)
    - [Questionnaire](https://portal.snapaddy.com/knowledge/snapaddy-visitreport?hsLang=en#questionnaire)
- [snapAddy LeadResearch](https://portal.snapaddy.com/knowledge/snapaddy-leadresearch?hsLang=en#main-content)

    - [Frequently Asked Questions (FAQ)](https://portal.snapaddy.com/knowledge/snapaddy-leadresearch?hsLang=en#frequently-asked-questions-faq)
    - [Installation and Setup](https://portal.snapaddy.com/knowledge/snapaddy-leadresearch?hsLang=en#installation-and-setup)
    - [Working with contact data](https://portal.snapaddy.com/knowledge/snapaddy-leadresearch?hsLang=en#working-with-contact-data)
    - [Exporting the contact data](https://portal.snapaddy.com/knowledge/snapaddy-leadresearch?hsLang=en#exporting-the-contact-data)
    - [LeadResearch in Chrome & Edge](https://portal.snapaddy.com/knowledge/snapaddy-leadresearch?hsLang=en#leadresearch-in-chrome-edge)
    - [LeadResearch in your CRM System](https://portal.snapaddy.com/knowledge/snapaddy-leadresearch?hsLang=en#leadresearch-in-your-crm-system)
    - [Technical requirements](https://portal.snapaddy.com/knowledge/snapaddy-leadresearch?hsLang=en#technical-requirements)
    - [Microsoft 365 Integration (Outlook)](https://portal.snapaddy.com/knowledge/snapaddy-leadresearch?hsLang=en#microsoft-365-integration-outlook)
    - [Automation](https://portal.snapaddy.com/knowledge/snapaddy-leadresearch?hsLang=en#automation)
- [snapAddy DataAgents](https://portal.snapaddy.com/knowledge/snapaddy-dataagents?hsLang=en#main-content)

    - [Frequently Asked Questions (FAQ)](https://portal.snapaddy.com/knowledge/snapaddy-dataagents?hsLang=en#frequently-asked-questions-faq)
    - [Installation and Setup](https://portal.snapaddy.com/knowledge/snapaddy-dataagents?hsLang=en#installation-and-setup)
    - [Workflows](https://portal.snapaddy.com/knowledge/snapaddy-dataagents?hsLang=en#workflows)
- [Data Enrichment](https://portal.snapaddy.com/knowledge/data-enrichment?hsLang=en)

[![sA Logo](https://portal.snapaddy.com/hs-fs/hubfs/sA%20Logo.png?width=120&height=29&name=sA%20Logo.png "sA Logo")](https://www.snapaddy.com)

Haugerkirchgasse 7  
97070 Würzburg  
Germany

[Legal notice](https://www.snapaddy.com/en/legal/imprint.html)

<https://linkedin.com/company/snapaddygmbh> <https://www.xing.com/companies/snapaddygmbh> <https://www.youtube.com/channel/UComiI_lYMqWGmC-dzU78pHw> <https://medium.com/snapaddy-tech-blog> <https://de-de.facebook.com/snapaddy/> <https://www.instagram.com/snapaddy/>

Copyright © 2025, snapAddy GmbH  
<https://www.snapaddy.com/en/legal/imprint.html>