# Contacts - How to Configure the Template File for Editing in Microsoft Excel

In this article, you will learn how to correctly format the template file in Microsoft Excel, ensuring that the data is imported into the system without reading or formatting errors.

#### Follow the step-by-step instructions below:

The most efficient way to open CSV files with accents and special characters in Excel is by importing the data instead of opening the file directly. Here's how to do it:

1. Open Microsoft Excel in a new blank workbook.
2. Go to the Data tab in the top menu.
3. In the Get & Transform Data group (or External Data in older versions), click From Text/CSV (or From Text in earlier versions).
4. Locate and select your CSV file.
5. In the preview window that appears, find the File Origin or File Encoding option.
6. In the drop-down menu, select 65001: Unicode (UTF-8). This will ensure that accents and special characters are displayed correctly.
7. Check the Delimiter (usually comma or semicolon) and make sure the data is being distributed correctly across the columns.
8. Click Load (or Finish in older versions) to complete importing the data into the spreadsheet.

{% embed url="<https://youtu.be/ZFQBDQnzTO4>" %}

{% hint style="danger" %}
Avoid leaving blank rows or columns so as not to cause errors when importing the data.
{% endhint %}

Done — in this way, your template file will be properly configured in Excel, avoiding errors when importing the data into the system.<br>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.sprinthub.com/en/topics/general/contacts/leads-common-questions/leads-how-to-import-a-spreadsheet/leads-how-to-configure-the-template-file-for-editing-in-microsoft-excel.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.