# Import responses from Excel

For larger reverse auction 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 <a href="#downloadexceltemplate" id="downloadexceltemplate"></a>

{% stepper %}
{% step %}
Open event.
{% endstep %}

{% step %}
In the **Quote line items** area, click the **Export/Import** button.
{% endstep %}

{% step %}
Select *Download line items*.\
The Excel template is downloaded, including all of the relevant information from the event.
{% endstep %}
{% endstepper %}

### Respond to line items <a href="#respondtolineitems" id="respondtolineitems"></a>

Warning! Additional columns cannot be added to the spreadsheet.

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

{% step %}
Add your response to each line. You can quickly and easily respond up to 150 rows.

<table><thead><tr><th width="165.421875">Column</th><th>Description</th></tr></thead><tbody><tr><td>#Line</td><td><p></p><p>Displays the line item hierarchy.</p><ul><li>Item: Numbers the line items sequentially (e.g., 1, 2, 3).</li><li>Item Group:Uses whole numbers to identify the group description and then uses letters to identify individual sub-items for each group (e.g., 4, 4.a, 4.b,4.c).</li><li>Service: Numbers the line items sequentially (e.g., 1, 2, 3).</li><li>Service Group: Uses whole numbers to identify the group description and then uses letters to identify individual sub-items for each group (e.g., 4, 4.a, 4.b,4.c).</li></ul></td></tr><tr><td>Line Type</td><td><p>Displays line item type.</p><ul><li>Item</li><li>Service</li><li>GroupItem</li><li>GroupService</li></ul></td></tr><tr><td>Item / Service description</td><td>Displays a brief description of the line item.</td></tr><tr><td>Manufacturer</td><td>Displays the manufacturer name for the item. This field is only populated when the buyer entered a value.</td></tr><tr><td>MFG Part #</td><td>Displays the manufacturer's part number for the item. This field is only populated when the buyer entered a value.</td></tr><tr><td>Quantity</td><td>Displays the quantity of the line item needed. The quantity measure is based on your selected UOM.</td></tr><tr><td>Unit of Measure</td><td>Displays the unit of measure.</td></tr><tr><td>Internal part number</td><td>Displays the buyer's organization's part number for the item. This field is only populated when the buyer entered a value.</td></tr><tr><td>Comments</td><td>Displays any comments the buyer entered about the line item. This field is only populated when the buyer entered a value.</td></tr><tr><td>Start date</td><td>Displays the start date for the line item. This field is only populated when the buyer entered a value.</td></tr><tr><td>End Date</td><td>Displays the end date for the line item. This field is only populated when the buyer entered a value.</td></tr><tr><td>Attachments</td><td>Displays if the buyer added attachments to the line item. This field is only populated when the buyer entered a value.</td></tr><tr><td>Bid on this Line</td><td>Enter <em>Yes</em> if you are responding to the line. Enter <em>No</em> if you are not responding to the line.</td></tr><tr><td><strong>*Unit Price/Response</strong></td><td>Enter the unit price for the line. If the UOM is Yes/No, enter <em>yes</em> or <em>no</em>.</td></tr><tr><td><strong>*Delivery Days</strong></td><td>If the line item is for an Item or Group Item, enter the number of days needed to deliver the item (lead time).</td></tr><tr><td>Supplier SKU</td><td>If available, enter the SKU for the item.</td></tr><tr><td>Country of origin</td><td>If available, enter the country of origin for the item.</td></tr><tr><td>Minimum Order Quantity</td><td>If required, enter the minimum order quantity of a item required.</td></tr><tr><td>Comments</td><td>Enter any comments about the line item.</td></tr></tbody></table>
{% endstep %}

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

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

{% stepper %}
{% step %}
Open event and click the **Export/Import** button.
{% endstep %}

{% step %}
Select *Upload completed line items*, 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 %}

<br>