CSVファイルのフォーマットが問題となっている場合(カンマでなくセミコロンになっている)

[csvをインポートするトレイルヘッドのまとめに戻る](https://qiita.com/Keiji_otsubo/items/74259ef8c1e245e68e68)


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

+ [Data Import Wizard](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V000077C6q3)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/e05af20a-28ab-2a28-f0e3-4c69c84dca97.png)

:::note
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
:::

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/e9d2d7ca-498c-4237-22bd-14cdc87e5fab.png)

+ [マップするオブジェクトがないデータインポートウィザード](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000Gzn5ySAB)
+ [Comment créer le fichier CSV pour le mappage des champs avec l'assistant d'importations de données](https://trailhead.salesforce.com/ja/trailblazer-community/feed/0D54S00000Gi4VkSAJ)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/7002e473-dbf2-3ff1-6e03-c5a2ccde5205.png)
+ [No se que CSV utilizar](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000HEVBrSAP)

+ [Excelでの変換例あり](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000JdYKaSAN)

+ [Problem in Data Import Wizard with CSV](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007T45bySAB)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/8a1846f9-d97f-b1a7-799d-aa0c5137f97a.png)

:::note
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:

1. Go to your file and right click on it.
2. Select Open with and select notepad
3. Once the file open in notepad, click on the Edit Tab.
4. Select replace
5. On the "Find what" field enter the value (;) semi-colon
6. On the "Replace with" field enter the value (,) comma
7. Click on the Replace all button.
8. 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.
:::

+ [Excel different in exercise - Use the Data Import Wizard](https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX00000PZp2Z)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/74d31132-fe6a-41b0-b69b-a1c3e9ec1e98.png)



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

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

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


![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/68f56da6-5e81-ec2e-7d78-94eaf5e3a7c4.png)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/c7a6ae65-1d8d-8765-6005-50325a54335a.png)

+ [Data Import Module - Mapping Issue](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000HDZl3SAH)

:::note
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つが空白です。それが投げたエラーは誤解を招くものでした。データについて文句を言うのではなく、マッピングを指しています。データを修正した後、動作しました。

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/1224d986-968c-e319-678a-6b149c07e6ea.png)

+ [必要なフィールドの連絡先をマップする必要があります姓のエラー-データインポートウィザード](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000A7vldSAB)
+ [Dreamhouse：データインポートウィザードでプロセスに従いましたが、それでもエラーが発生します。ヘルプをリクエストする](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000HCuWw)

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

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/eba50d74-e5e0-083e-b942-8bd2aa7175b4.png)


[カスタムオブジェクトのcsvファイルをインポートしようとしています。動作しません。次のエラーメッセージが表示されます。「選択した一致するフィールド（* CustomeObject *）はマップされておらず、更新および挿入操作に必要です。」](https://trailhead.salesforce.com/ja/trailblazer-community/feed/0D54S00000HDLdZhttps://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000HDLdZ)



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

+ [Export with Data Management Tools - Use the Data Import Wizard](https://trailhead.salesforce.com/en/trailblazer-community/feed/0D54S00000G38vBSAR)

+ [.S. I have tried two internet browsers (DuckDuckGo & Safari); I do not use Google Chrome.](https://trailhead.salesforce.com/trailblazer-community/feed/0D5KX000000n7aO)

:::note
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](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000NQdlWSAT)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/b474695f-979a-0882-6c2f-f18136f75e47.png)


:::note
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.](https://trailhead.salesforce.com/trailblazer-community/feed/0D54S00000QMcKj)

![image.png](https://qiita-image-store.s3.ap-northeast-1.amazonaws.com/0/328136/9c03e7f2-991b-0e49-bb49-82490b2af5e8.png)

:::note
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](https://trailhead.salesforce.com/trailblazer-community/feed/0D54V00007Uvj1c)