While performing bulk operations, all the columns are consolidated into a single column in the template upload file.
Scope
Map unmatched CSV columns from the dropdown. The columns are not mapped correctly in the CSV template file. The data is merged under one column in the CSV file.
Summary
This usually happens because of regional settings. In some countries, such as Denmark, the default list separator in a CSV file is a semicolon (;) rather than a comma (,). Chargebee then reads the row as one column.
Solution
In Microsoft Excel, go to settings > language > related settings > administrative language settings > formats > additional settings, and change the list separator to a comma (,). Save the CSV as a new file and replace the old file. The columns then stay separate.