csv to Excel paste

Hi @TSG ,

Welcome to the community!

Can you change the Row Delimiter to New Line and give a try in c.v step?

Thank you!
It is already row delimiter “new line”, the rows are ok.
But only that all is in column A.
 

Can you expand Column A and check whether the data is available in only column A?

:) 

Hi @TSG 

Can you try to run the bot again, don't think there is any miss from your end. Tested same from my end am able to get the data, PFB screenshots for your reference

@TSG Change radio button to Append to the existing file 

Thank you all for the advice, but still the same. I begin to beleive it´s an issue in my Excel. I have had problem with paste in correct format before, will investigate this with my company support. I will report back to you :)

Welcome @TSG 

Hi @TSG ,

When you CSV in your spreadsheet editor (Excel, for example), it shows all of the data in a single column, instead of splitting them across columns.

The reason behind this behavior is that CSV files (Comma Separated Values) are splitting data into columns using " , " as separator by default. But in certain countries, the default value used as separator is " ; " instead.

To resolve this issue, within your open CSV file, you can click on the Data tab, select Convert and choose commas.

To change the settings for future Excel documents:

Go to your Settings page clicking on the link in the top-right corner of your screen (You have to be an admin)

In the Localization module, change the "List separator for exports" field to  "comma ( , )"

To change the settings for your Windows computer: 

Go to Start > Settings > Control Panel > Regional and Language Options. 
Click “Customize”. 
Enter “,” for “List Separator”