Introducing the Chargebee CLI

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.