There is a task about data scraping in the UiPath academy training where I need to data scrape from a table in wikipedia and save to .csv file.
When I open the csv file it is only comma separated, but in the demo video the table format is kept.
my file looks like this:
it should look like this:
the video is here: Video Demo 2 - Data Scraping
Hi @nft899 ,
Please do like this:-
Open excel–>Data → from text
Select the csv file location and click import
3)Select delimited
In delimiters select comma and click finish.
Select from which cell you want data to come. I selected default option =$A$1.
Click ok
And voila , your data is ready and the tabular format is retained.
mark as solution 
if it helps you.
Thank you! This was very helpful and solved my issue.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
