Skip to main content
Text to columns

I can't change my regional settings for internal reasons. How do I change my CSV commission statements so that it can upload?

Amanda de Bruyn avatar
Written by Amanda de Bruyn
Updated over a week ago

What is the problem?

Your data looks like this, not split into their individual columns:


Therefore Commspace cannot identify which data items to process as your product number, client name etc.

This is because your device's regional settings is blocking Excel to split the data by commas. You can have a look at this article if you would like to change your regional settings, however sometimes (due to your company's internal reasons) you cannot change your regional settings.

How can I resolve this?

If you can't change your regional settings, you have to manually split the data into their relevant columns.

Step 1: select the data you want to split into columns:

Step 2: navigate to Data on your Excel Ribbon, and click on "Text to columns"

Step 3: a pop up will appear. Select "Delimited" and click on "Next"

Step 4: select "Comma" as the Delimiter. Your preview will now throw the data into the separate columns. Click on "Finish"


Your data is now in their individual columns, and ready for upload. 😊

Did this answer your question?