Forum Discussion
NEED TO EXTRACT DATA FROM WEBSITE INTO EXCEL /CSV
I WANT TO USE THE DATA FROM https://www.messivsronaldo.app/match-histories/ronaldo-match-history/ HOW I WILL GET THE DATA IN TABLE FORMAT TO USE IN POWER BI REPORT.
Hi rabeeh -you'll need to scrape or manually export the data into a structured format like a CSV or Excel file for use in Power BI. Since there’s no built-in option to directly download the data.Copy the match history data and performance stats directly from the page.Paste the data into an Excel spreadsheet.Format the table columns to match the data you need (e.g., Date, Match, Goals, Assists).
Suppose, as this is sports statistic websites if there is any API for developers to pull live or historical data. You can check if the site has any API access for this type of data extraction, which can feed directly into Power BI.
Hope the above information helps.
1 Reply
- rajendraongole1
Super User
Hi rabeeh -you'll need to scrape or manually export the data into a structured format like a CSV or Excel file for use in Power BI. Since there’s no built-in option to directly download the data.Copy the match history data and performance stats directly from the page.Paste the data into an Excel spreadsheet.Format the table columns to match the data you need (e.g., Date, Match, Goals, Assists).
Suppose, as this is sports statistic websites if there is any API for developers to pull live or historical data. You can check if the site has any API access for this type of data extraction, which can feed directly into Power BI.
Hope the above information helps.