How to export data from CoinMarketCap to Excel?

How to export data from CoinMarketCap to Excel?

Facebook Twitter LinkedIn Telegram Whatsapp

1 answer

Member

by jamir , 10 months ago

@althea_dooley 

To export data from CoinMarketCap to Excel, you can follow these steps:

  1. Visit the CoinMarketCap website (coinmarketcap.com).
  2. Use the search bar to find the cryptocurrency you are interested in.
  3. Once you're on the cryptocurrency's page, you will see a table with various data. By default, only a few columns are displayed.
  4. Click on "Columns" just above the table to customize the columns you want to export. You can select additional columns like market cap, price, volume, etc.
  5. Once you have selected the desired columns, scroll down to the bottom of the table. On the right-hand side, you will find a "Download CSV" button.
  6. Click on "Download CSV" to download the data in a CSV format (comma-separated values). CSV files can be opened in Excel.
  7. Open Microsoft Excel on your computer and create a new blank workbook.
  8. Go to the "Data" tab in Excel and select "From Text/CSV".
  9. Choose the downloaded CSV file from your computer and click "Import".
  10. Excel will open a preview of the data in a new "Text Import Wizard" window. Make sure to select the appropriate delimiter (usually a comma).
  11. Click "Next" and then select the desired data format for each column. You can choose "Text", "General", "Date", or "Do not import".
  12. Once you've set the column format, click "Finish" to import the data into Excel.


Now you have successfully exported the data from CoinMarketCap to Excel. You can further customize the formatting, perform calculations, and analyze the data as needed.