While performing bulk operations, all the columns are consolidated into a single column in the template upload file.

Modified on: Mon, 8 Nov, 2021 at 10:31 AM

Scope

Bulk operations - Map unmatched CSV columns from dropdown
The columns are not mapped correctly in the CSV template file. 

The data is merged under one column in the CSV file. 


Summary

The issue generally happens because of the regional settings. In some countries (like Denmark) they use ";" to separate tabs in .csv by default rather than "," and that tricks the system.



Solution

On Microsoft Excel, Navigate to settings > language > related settings > administrative language settings > formats > additional settings > and change "list separator" to ",". Then you have to save the .csv as a new file (replace the old one) and it shall work as expected.

B
Bhaskar is the author of this solution article.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.
×