# Import responses from Excel
For larger events, you can export the event details to Excel format, update with your responses, and then import your updates into Fairmarkit.
Note: The template files work with Microsoft Excel 2007 and later versions.
### Download Excel template
{% stepper %}
{% step %}
Open event.
{% endstep %}
{% step %}
In the **event information** area, click the **Export/Import** button.\
{% endstep %}
{% step %}
Select *1. Export questions to Excel*.\
The Excel template is downloaded, including all of the questions from the event.
{% endstep %}
{% endstepper %}
### Respond to questions
Warning! Additional columns cannot be added to the spreadsheet.
{% stepper %}
{% step %}
Open the template.\
{% endstep %}
{% step %}
Add your response to question. You can quickly and easily respond up to 3000 rows.\
Column descriptions
| Column | Description | |
| ------------- | ------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| | Question Section | Displays the name of the event section. |
| | Line # | Displays the line number for the question. |
| | Line Type | Displays the question type.
- Item Question
Service Question
- Service Question Title Line
- Service Component
- Conditional Question
|
| | Required | Displays if the question is *Required* or *Optional*. You do not have to respond to *Optional* questions to submit your response. |
| | Question Conditions | For *Conditional Questions*, displays a condition (e.g., *if 4.b is equal to true*) for the question to require a response. |
| | Item / Service description | Displays the question, item description, or service description for the line item. |
| | Response Options | Provides a list of valid responses to multiple choice type questions. Multiple choice questions are marked as *multiple\_choice* in the *UOM* column. Check the *Multiple Responses Allowed* to see if you can select multiple options. |
| | Internal part # | Displays the buyer's organization's part number for the item. This field is only populated when the buyer entered a value. |
| | Manufacturer | Displays the manufacturer name for the item. This field is only populated when the buyer entered a value. |
| | MFG Part # | Displays the manufacturer's part number for the item. This field is only populated when the buyer entered a value. |
| | Quantity | Displays the quantity of the line item needed. The quantity measured is based on your selected UOM. If you update your UOM, update this value to match. |
| | [UOM](https://docs.fairmarkit.com/content/glossaries/uom.htm) | Displays the unit of measure. If needed, you can update this value to your necessary unit of measure, and it will be converted for the buyer. This must be a [valid UOM](https://app.gitbook.com/s/XSi8dxrnMaQPYuaoiJWp/glossary/unit-of-measure-overview/uoms). |
| | Original UOM | Displays the unit of measure entered by the buyer. |
| | Original Quantity | Displays the quantity of the line item needed. This is the value entered by the buyer. |
| | Unit Price with Original UOM | Displays the unit price of the line item based on the Original UOM and Original Quantity. This value is automatically calculated. |
| | Multiple Responses Allowed | Displays *Yes* if you can select multiple *Response Options*. |
| | Unit Price | If n/a displays, this field is not required.
If blank, enter the unit price for the line item. Numeric values only; the field title includes the event currency selected by the buyer.
|
| | Delivery Days | If *n/a* displays, this field is not required. If blank, enter the number of days needed to deliver the item (lead time). |
| | Non-price response | If n/a displays, this field is not required.
If blank, enter your response based on the UOM.
- date: Displays MM/DD/YYYY so you know to enter a date response (e.g., 12/10/2023).
- date range: Displays MM/DD/YYYY - MM/DD/YYYY so you know to enter a date range response (e.g., 12/10/2023 - 12/12/2023).
- multiple\_choice: Is blank and available options are available in the Response Options column. If you can enter multiple responses, Yes displays in the Multiple Responses Allowed column. If Multiple Responses Allowed, separate responses with semicolons (Choice 1; Choice 2; Choice 3).
- text: Displays REQUIRED so you know to enter a text response. You can enter up to 4,000 characters.
- yes\_no: Displays Y/N so you know to respond with Y (yes) or N (no).
|
| | Supplier SKU | If available, enter the SKU for the item. |
| | Supplier Minimum Order Quantity | If required, enter the minimum order quantity of the required item. |
| | Country of origin | If available, enter the two letter code for the country of origin for the item. |
| | Supplier Comments | Enter any comments about the line item. You can enter up to 1,000 characters. |
| | Comments from Buyer | Displays any comments the buyer entered about the line item. This field is only populated when the buyer entered a value. |
| | Start date | Displays the start date for the line item. This field is only populated when the buyer entered a value. |
| | End Date | Displays the end date for the line item. This field is only populated when the buyer entered a value. |
| | Id | Displays the line item ID. |
| {% endstep %} | | |
{% step %}
Save your spreadsheet.
{% endstep %}
{% endstepper %}
### Import from Excel
{% stepper %}
{% step %}
Open event and click the **Export/Import** button.\
{% endstep %}
{% step %}
Select *2 Import completed questions*, and then select and open your saved file.\
The line items are updated with your responses.
**Note**: *If there are any issues with your import file, you will receive a message that will tell you which line and column has an issue.*
{% endstep %}
{% step %}
Make any necessary additions or changes to your response before sending it to the buyer.
{% endstep %}
{% endstepper %}