> ## Documentation Index
> Fetch the complete documentation index at: https://help.kajabi.com/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://help.kajabi.com/feedback

```json
{
  "path": "/articles/contacts/manage-your-contacts/having-issues-formatting-a-csv-for-contact-imports",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

# Format a CSV for contact imports

> Resolve CSV import errors by converting the file to UTF-8 encoding in Excel or Numbers.

Receiving an error when importing contacts with a CSV? Find out why you may receive this error and how you can ensure that your CSV is formatted properly when importing your contacts to Kajabi.

## Understand the error

The Import Importer Tool requires .csv files to conform to the **UTF-8** standards in order for them to be parsed accurately by the system.

The most common reason for this error is if a non-UTF-8 character such as "**Å**" is present in the .csv file. To successfully upload your .csv file, you will need to open your .csv file and change the file type.

This process will look different depending on the program you are using, so the steps below cover both **Excel** and **Numbers**.

## Format in Windows

1. Open your .csv in **Excel**.

<Note>
  **Note:** If you use a different spreadsheet program, check their support documentation for instructions on how to download as a CSV UTF-8.
</Note>

2. Select **File** and click **Save As**.
3. From the file type dropdown, select **CSV UTF-8 (Comma delimited (\*.csv)**.
4. Click **Save**.

<div className="w-full aspect-video">
  <iframe src="https://fast.wistia.net/embed/iframe/6ur80is381" allow="autoplay; fullscreen" allowFullScreen className="w-full h-full" />
</div>

## Format in macOS

1. Open your .csv in **Numbers**.
2. Select **File**.
3. Hover over **Export To** and select .csv.
4. In the export options, select **Advanced Options**, and specify **Unicode (UTF-8)**. If there is another .csv export option shown, click into the dropdown and choose **Unicode (UTF-8)**.
5. Confirm by selecting **Export** on the following screen.

<div className="w-full aspect-video">
  <iframe src="https://fast.wistia.net/embed/iframe/5w5hj9ev9i" allow="autoplay; fullscreen" allowFullScreen className="w-full h-full" />
</div>