"Write CSV" not putting scraped data in to columns

csv
studio

#1

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


#2

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


#3

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


#4

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

Cheers.


#5

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


#6

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.


#7

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


#8

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.