How to Install CryptoExcel in Microsoft Excel
This guide explains how to install the CryptoExcel add-in on a Windows desktop computer, check the system requirements, and verify that the installation works in Microsoft Excel. For a more detailed walkthrough with screenshots, see the full installation article.
1. System Requirements
- Microsoft Excel: Excel 2010 or later, Windows desktop version only. How to check your Excel version.
- Internet connection: required to retrieve data from cryptocurrency exchanges.
- Python: no separate installation is required. CryptoExcel includes a standalone Python distribution with the required libraries, installed in the
%APPDATA%folder.
2. Download CryptoExcel
Get the CryptoExcel installation package from the Download Page. Follow the instructions supplied with the downloaded package before running the installer.
3. Install the CryptoExcel Add-In
- Open the downloaded and extracted CryptoExcel folder.
- Run the installation batch file included in the package (
Install.bat). - The setup copies the required files, installs the standalone Python distribution in
%APPDATA%, and configures Excel to load CryptoExcel. - Restart Microsoft Excel after the installation completes.
4. Verify the Installation in Excel
- Open Microsoft Excel.
- Check that the CryptoExcel tab appears in the Excel ribbon.
- Test a CryptoExcel function in a worksheet cell, for example:
=st_book("binance","BTC/USDT")
If the formula returns live order book data, CryptoExcel is installed and working.
5. Next Steps
Open the sample Excel files and templates included in the download package to explore CryptoExcel functions and begin working with cryptocurrency exchange data in Excel.