I am trying to import users or organizations and get an error

<h2 id="h_01J73RFNY0J49NGPWWX2CRA4QN">Issue symptoms</h2><p>I get an error when I try to import <a href="https://support.zendesk.com/hc/en-us/articles/4408893496218-Bulk-importing-users" target="_blank" rel="noopener noreferrer">users</a> or <a href="https://support.zendesk.com/hc/en-us/articles/4408885980186-Bulk-importing-organizations" target="_blank" rel="noopener noreferrer">organizations</a> into my Zendesk account.</p><h2 id="h_01J73RFNY0JJAVW3E6QZB9QW4Q">Resolution steps</h2><p>The majority of errors related to user or organization import are a result of formatting issues in the CSV file.</p><p>If you get an error message, check the table below for potential solutions:</p><figure class="wysiwyg-table wysiwyg-table-align-left" style="height: 711px; width: 610px;"><table><tbody>
<tr style="height: 22px;">
<td style="height: 22px; text-align: center; width: 272.031px;">Error message</td>
<td style="height: 22px; text-align: center; width: 314.969px;">Solution</td>
</tr>
<tr style="height: 67px;">
<td style="height: 67px; width: 272.031px;"><strong>Your CSV file request frequency limit has been exceeded. Try again later</strong></td>
<td style="height: 67px; width: 314.969px;">CSV (comma separated values) exports are limited to 100,000 results per hour and per user.</td>
</tr>
<tr style="height: 89px;">
<td style="height: 89px; vertical-align: top; width: 272.031px;"><strong>UTF-8 Errors</strong></td>
<td style="height: 89px; width: 314.969px;">
<p>This error occurs when the uploaded file isn't in UTF-8 format. </p>
<p><strong>Convert your CSV file to UTF-8</strong></p>
<p>Your import file might use another format, such as ISO-8859, instead of UTF-8. Use one of the following methods to convert the file.</p>
<p><strong>Use Google Sheets</strong></p>
<ol>
<li data-list-item-id="e52b721e8974e2a72f1650ee3a0709bd5">Open Google Drive.&lt;/mark&gt;</li>
<li data-list-item-id="e52997124652ac903dc11ef36c889f693">Create a new Google Sheets document.</li>
<li data-list-item-id="e514e5c24dd93e1c07d309dddcfbb6c46">Import your CSV file.</li>
<li data-list-item-id="e47b27e264b116cad7ecb4ce758861d37">Select File &gt; Download &gt; Comma-Separated Values (.csv).</li>
</ol>
<p>The downloaded file uses UTF-8 encoding. You can use it to import users or organizations.</p>
<p><strong>Use Microsoft Excel</strong></p>
<ol>
<li data-list-item-id="e4a8794fd5461a450da3bad5aa3e86c78">Open the CSV file in Microsoft Excel.</li>
<li data-list-item-id="eae975f65e9861bf440ceb2bf9cece99d">Select File &gt; Save As.</li>
<li data-list-item-id="ec2183af6882812be1a66f54ccc054174">Select CSV UTF-8 (Comma delimited) (*.csv) as the file format.</li>
<li data-list-item-id="e5545aa9026e528820a868c1d4ae2e7b0">Select Save.</li>
</ol>
<p>If you cannot save the file as a UTF-8 CSV file in Excel, save it as Unicode Text (.txt), open it in Notepad, replace the tab characters with commas, and save the file with UTF-8 encoding and a .csv file extension.</p>
<p>Open the converted CSV file to check the data before importing it. If you find a problem, fix the original spreadsheet and repeat the conversion steps. Saving the file again in Excel can cause the UTF-8 error to return.</p>
</td>
</tr>
<tr style="height: 111px;">
<td style="height: 111px; width: 272.031px;"><strong>Upload failed. File type is not supported.</strong></td>
<td style="height: 111px; width: 314.969px;">The file must be a CSV file. If you use a CSV but still get this error, consider passing the file through Google Sheets as described in the tip at the bottom of this article to fix any potential encoding issues.</td>
</tr>
<tr style="height: 111px;">
<td style="height: 111px; width: 272.031px;"><strong>Failed to process row. Import aborted.</strong></td>
<td style="height: 111px; width: 314.969px;">These errors occur because of an issue with the formatting of the CSV file. To ensure that you format the file correctly, follow the guidelines on <a href="https://support.zendesk.com/hc/en-us/articles/4408893496218-Bulk-importing-users" target="_blank" rel="noopener noreferrer">bulk importing users</a>.</td>
</tr>
<tr style="height: 111px;">
<td style="height: 111px; width: 272.031px;"><strong>Column 'user_id' cannot be null</strong></td>
<td style="height: 111px; width: 314.969px;">These errors occur because of an issue with the formatting of the CSV file. To ensure that you format the file correctly, follow the guidelines on <a href="https://support.zendesk.com/hc/en-us/articles/4408893496218-Bulk-importing-users" target="_blank" rel="noopener noreferrer">bulk importing users</a>.</td>
</tr>
<tr style="height: 44px;">
<td style="height: 44px; width: 272.031px;"><strong>User_id is invalid</strong></td>
<td style="height: 44px; width: 314.969px;">Include the <code>user_id</code> field in the header of one of the columns of your CSV file.</td>
</tr>
<tr style="height: 67px;">
<td style="height: 67px; width: 272.031px;"><strong>Missing mandatory field in header: name</strong></td>
<td style="height: 67px; width: 314.969px;">The <strong>name</strong> field is required when you bulk import new users with a CSV file. For details, see <a href="https://support.zendesk.com/hc/en-us/articles/4408893496218-Bulk-importing-users" target="_blank" rel="noopener noreferrer">Bulk importing users</a>.</td>
</tr>
<tr style="height: 89px;">
<td style="height: 89px; width: 272.031px;"><strong>403 error</strong></td>
<td style="height: 89px; width: 314.969px;">This occurs when the import feature isn't turned on for your account.</td>
</tr>
</tbody></table></figure><p>If you still experience an error when you import users or organizations, try these common troubleshooting steps:</p><ol>
<li data-list-item-id="e0c12b6e86b10a43ba83475f4a73633ff">Check the first row of your file to make sure you have all the required headers</li>
<li data-list-item-id="e226ebf711268e04d602e25effc69a613">Review your CSV file for any formatting issues or unsupported characters</li>
<li data-list-item-id="e8b79ec31dafb20b92023b13418106e74">Copy and paste your data into a new CSV file to avoid formatting issues</li>
</ol><div class="p">
<div class="note tip">
<span class="tiptitle">Tip:</span> If you have trouble with an unknown error, upload your CSV file to Google Sheets and download the file in a CSV format. This process ensures that the sheet is encoded correctly, which solves a number of import errors.</div>
<!-- AI knowledge DO NOT DELETE -->
<style>
.ai-only {
position: absolute !important;
width: 1px !important;
height: 1px !important;
padding: 0 !important;
margin: -1px !important;
overflow: hidden !important;
clip: rect(0, 0, 0, 0) !important;
white-space: nowrap !important;
border: 0 !important;
}
</style>
<div class="ai-only" aria-hidden="true">
<details>
<summary>THIS SECTION IS AI CONTENT. DON'T EDIT OR DELETE.</summary>
<h2 id="h_01KXKJTAJHP8XP65X4HRE76Q99">Why do I get an error when I try to import users or organizations into my Zendesk account? Why does my customer upload fail? Why does my CSV bulk import return an error?</h2>
<p>Most errors related to user or organization imports result from formatting issues within your CSV file.</p>

<h2 id="h_01KXKJTAJHCMSVKFS4AQK8ADAC">How do I troubleshoot user import errors? How do I fix organization CSV upload issues? What steps resolve data import failures?</h2>
<p>Follow these troubleshooting steps to resolve the issue:</p>
<ol>
<li>Check the first row of your file to ensure you include all required headers.</li>
<li>Review your CSV file for formatting issues or unsupported characters.</li>
<li>Copy and paste your data into a new CSV file to avoid formatting issues.</li>
</ol>

<h2 id="h_01KXKJTAJHC7NQEXWFQFA3NMBV">How can I fix an unknown import error? How do I ensure my CSV file uses the correct encoding? How do I resolve format errors using Google Sheets?</h2>
<p>Upload your CSV file to Google Sheets and download the file in a CSV format. This process ensures correct sheet encoding, which solves a number of import errors.</p>
</details>
</div>
</div>