csvをインポートするトレイルヘッドのまとめに戻る

CSVの区切り文字が違う？　カンマでなくセミコロンになっている

Data Import Wizard

This is due to your csv delimiter being a semi-colon instead of a comma. This happens in some locales since they use the comma as a thousands separator.

Follow this Salesforce article:

https://help.salesforce.com/s/articleView?id=000386073&language=en_US&type=1

https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000QMcKj

This are consideration while importing data from CSV file in salesforce.
https://help.salesforce.com/articleView?id=000313396&type=1&mode=1
https://help.salesforce.com/articleView?id=000331030&type=1&mode=1
Most probably your excel setting changes the delimiter to semi-colon (;) instead of comma (,). To resolve this issue:

Go to your file and right click on it.
Select Open with and select notepad
Once the file open in notepad, click on the Edit Tab.
Select replace
On the "Find what" field enter the value (;) semi-colon
On the "Replace with" field enter the value (,) comma
Click on the Replace all button.
Save the file and add the .CSV on the end of the file name.
Once done with the last step, don't open again the save file on excel. This will ensure that the delimiter of the file is save as comma delimited. The file should be good for import. Please let me know if this answer your query or you can mark it as solved.

CSVが変。フィールドが分割できない

なんとダブルコーテーションが機能しない。

"FNAME,LNAME,CELL,EMAIL,SALUTATION,TITLE"

Data Import Module - Mapping Issue

The problem is that there are double coatings only on both ends.

"FNAME,LNAME,CELL,EMAIL,SALUTATION,TITLE"

Originally, it should be formatted as follows.

"FNAME","LNAME","CELL","EMAIL","SALUTATION","TITLE"

マッピングは正しいです。私の列ヘッダーも正しいです。問題はExcelデータにあり、私の姓のレコードの1つが空白です。それが投げたエラーは誤解を招くものでした。データについて文句を言うのではなく、マッピングを指しています。データを修正した後、動作しました。

Auto Numberフィールドがあるとややこしい。

カスタムオブジェクトのcsvファイルをインポートしようとしています。動作しません。次のエラーメッセージが表示されます。「選択した一致するフィールド（* CustomeObject *）はマップされておらず、更新および挿入操作に必要です。」

Macを使った場合の注意　excelでないからかな？

You can open the .xlsx file in Numbers, make the assigned edits, and afterwards choose File > Export To > CSV... from the Numbers menu bar. This will allow you to save the file in the proper .csv format.

Numbersで.xlsxファイルを開き、割り当てられた編集を行ってから、NumbersメニューバーからFile> Export To>CSV...を選択できます。これにより、ファイルを適切な.csv形式で保存できます。

Issue with importing data using Data Import Wizard

You can open the .xlsx file in Numbers, make the assigned edits, and afterwards choose File > Export To > CSV... from the Numbers menu bar. This will allow you to save the file in the proper .csv format.

I would like to know how to correctly import data from an excel csv file with Data Import Wizard.

This is due to your csv delimiter being a semi-colon instead of a comma. This happens in some locales since they use the comma as a thousands separator.

Follow this Salesforce article:

https://help.salesforce.com/s/articleView?id=000386073&language=en_US&type=1

Excelが無い場合

Import and Export with Data Management Tools