"Write CSV" not putting scraped data in to columns

Help
,
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

datascrape%20preview
datascrape%20preview844×850 44 KB

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

nocolumns
nocolumns1066×567 45.1 KB

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:

scrapesequence
scrapesequence478×759 37.5 KB

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.