# Import questions from Excel

When you're creating a template and need to add a large number of questions, you can import lines to make the process faster.

Note: The template files work with Microsoft Excel 2007 and later versions.

### Download Excel template <a href="#downloadexceltemplate" id="downloadexceltemplate"></a>

{% stepper %}
{% step %}
Open a template.
{% endstep %}

{% step %}
In one of the Questions sections, click the **Import** button.
{% endstep %}

{% step %}
Select Download template for import.\
The Excel file (rfp\_import\_template.xlsx) is downloaded
{% endstep %}
{% endstepper %}

### Add line items <a href="#addlineitems" id="addlineitems"></a>

Using Excel, you can upload up to 3000 line items to an event and 100 line items per sections. If you exceed 100 line items in a section, additional line items are uploaded to a new section. For each question, you can add [conditional questions](https://docs.fairmarkit.com/buyers/events/create-an-event/add-questions/conditional-questions) to collect more information when a supplier provides a specific response.

Warning! Additional columns cannot be added to the spreadsheet.

{% stepper %}
{% step %}
Open the template in your preferred spreadsheet program.
{% endstep %}

{% step %}
Add line items.
{% endstep %}

{% step %}
Save your spreadsheet.
{% endstep %}
{% endstepper %}

### Import from Excel <a href="#importfromexcel" id="importfromexcel"></a>

{% stepper %}
{% step %}
Open a template, navigate to a question section, and click the **Import** button.
{% endstep %}

{% step %}
Select *Import from Excel* and then select and open your saved file.\
New sections and questions with the information you defined are added. If you exceed 100 line items in a section, additional line items are uploaded to a new section.

*Note: If there are any issues with your import file, you will receive a message telling you which line and column has an issue.*
{% endstep %}

{% step %}
Make any necessary additions or changes and save.
{% endstep %}
{% endstepper %}
