How to fetch trending crypto price data into Excel?

How can one effectively retrieve and integrate the latest cryptocurrency price data into an Excel spreadsheet? Are there any specific tools or APIs that can be Leveraged to automate this process, ensuring accuracy and timeliness of the information? Additionally, what steps should be taken to ensure the data is properly formatted and organized within the Excel file for easy analysis and visualization?