"Write CSV" not putting scraped data in to columns

After using the Data scraping method I am able to succesfully scrape the data (I can see this in the preview). When I use the output to write in a csv file all the data is added in one single column.

Does anybody have a clue how to fix this?

Kind regards,

Robert

Hi @robertrozenberg, may I get a screenshot of your scraping preview?

@quihan the screenshots shows the preview. The second screen shot (csv file) is the file I’m getting after using the robot.

Hi @robertrozenberg, are you using write CSV activity? Do you mind taking a screenshot of your process?

Cheers.

Hi @quihan, thank you for wanting to get to the bottom of this problem :slight_smile: . Screenshot of the flow below:

Your workflow looks good to me. Could try this? Just open IE, navigate to amazon and search for harry potter books

Test1.xaml (9.1 KB)

Cheers.

I’m getting the same problem. Maybe it has something to do with my Excel settings? No idea what though.

I guess it is Excel’s problem too. Your data should be fine. If you use Read CSV, it should read back the same data.