How to Resolve Bulk Settings File Upload Errors

This article explains how to resolve errors that appear when uploading a CSV file in Bulk Settings.

Check the Error Message

If an error occurs while importing the CSV file, it will be displayed as either an "error message" or an "error file".
Please make the corrections according to the instructions shown, then import the file again.

Image | Error Message (Sample 1)

Image | Error Message (Sample 2)

---

Common Error Messages and How to Resolve Them

If you see one of the following error messages, please try the corresponding solution.

If "File Import Error (Row ○)" Is Displayed

This is displayed when there is a problem with the structure of the CSV file (CSV file rules).

Common Causes

・A cell contains a " (double quote)
・A line break has been entered within a cell using Alt + Enter in Excel

Steps to Resolve

①Check the cell in the row number shown in the error message.
②Check whether that cell contains a " or a line break (entered using Alt + Enter), and remove it.
③In Excel, select "Save As" and save the file with the file type set to "CSV UTF-8 (Comma delimited) (*.csv)".
④Upload the saved file again.

  Note

This is generally not an issue when data is edited and saved using Excel. However, if you edit the CSV file directly using a text editor such as Notepad, a " (double quote) or line break may be inserted in an unintended position, which can break the structure of the file.

---

If "The character encoding is incorrect." Is Displayed

This is displayed when the file's saved format is not supported by the system.

Common Causes

・The file's character encoding is something other than UTF-8 or Shift_JIS
・An Excel file, PDF, or similar file has been uploaded with only the file name extension changed to .csv 

Steps to Resolve

①Download the latest CSV file from the relevant settings screen.
*Please do not use a previously downloaded file.

②Open the downloaded CSV file in Excel, and paste and edit the necessary data.

③Select "Save As", and choose "CSV UTF-8 (Comma delimited) (*.csv)" as the file type, then save.

④Upload the saved file again.

  Note

What Is Character Encoding?
Character encoding is a set of conversion rules for handling characters on a computer. When saving a file, you need to specify which character encoding to save it in. This system supports UTF-8 or Shift_JIS. You can save the file with the correct character encoding by selecting the CSV UTF-8 format from Excel's "Save As" option.

Changing Only the File Extension Does Not Convert the File to CSV
Simply changing the file name of an Excel file (.xlsx) to "○○.csv" does not change its contents — it remains in Excel format. To create a CSV file that the system can read, you need to convert the format using Excel's "Save As" option.

---

If "There was a problem with the file, so it could not be processed correctly." Is Displayed

This is displayed when the file was not saved correctly, or when it contains data that cannot be read.

Common Causes

・The save process was interrupted while the file was being saved (e.g., Excel was closed or the PC went to sleep during saving)
・The file became corrupted while being sent or received via email or cloud storage
・The file was opened and edited before the download had finished

Steps to Resolve

①Download the latest file from the relevant settings screen.
*Please do not use a previously downloaded file.

②Open the downloaded file in Excel and re-enter the data.

③Select "Save As", and choose "CSV UTF-8 (Comma delimited) (*.csv)" as the file type, then save.

④Upload the saved file again.
 

---

If the Issue Is Not Resolved

If the issue is not resolved even after trying the above solutions, please contact Support.
Providing the following information will help us identify the cause more quickly.

・The CSV file in which the error occurred
・The date and time the error occurred
・The error message that was displayed
・The name of the screen you were working on (e.g., User Bulk Settings, Organization Bulk Settings, etc.)