I am scrapping data from a website and want to write the output in an Excel file. After adding data scrapping activity, I add Write CSV as the next subsequent activity. I am not sure what to fill in File path and Data Table columns, to get the desired result. Also would this be enough for doing this? Or there are other activities that need to be added?
File path : is specifying your destination path where you want to save the file
eg: “C:\Users\useName\DDesktop\filename.csv”
Data Table: is the output from satascrapping activity
Hello @ritiksuneja,
you can use write CSV and write range as well. have a look at below screenshot,
Sincerely,
Pankaj
Thanks a lot, just want to know if I have to create an empty file and save it in the specified location and it will write the scraped the data in it or it will automatically create a file in the specified location and then write the output.
Also do I need to create any variables for the same?
Hi @ritiksuneja,
You don’t want to create the empty file. If is not exists , it will create the file automatically . If it is exists, it will overwrite.
To Details :
https://activities.uipath.com/docs/write-csv-file
Regards
Balamurugan.
Its working fine, thanks a lot. Really appreciate the quick response 
Hi Balu,
Can we add serial numbers or Something like no result to each row if the search results no data, like i have a results of 100 to be added in excel and if there is no result for one of the search it should write empty in the row or it should leave the row empty with search number.
like
- dfgdfsg
- dsfgdsfgfdg
- empty
- empty
- sdfgdfgdfgdf
because if there is no data for the search it is adding the next search results data to the csv. so if i search for 100 values and found only 80 in that there are only 80 entries in csv for which i’m unable to find which entry has no data.
Please help me.
Anil_G
ashokkarale
jinal.shah
Gautham_Pattabiraman
postwick
chandreshsinh.jadeja
vrdabberu
Ajay_Mishra
sven.wullum1
Vyshnavi_Nalumachu