The most practical way to import Binance market data into Excel and keep it auto-updating is to connect Power Query to Binance's public API. You don't need an API key, you don't need to write code, and a simple refresh gets you the latest prices. But there is one catch: Binance's public API has rate limits, so the Power Query refresh interval should not be set too short. Otherwise, your IP may be temporarily banned.
The world's largest cryptocurrency exchange by trading volume,leading in security and liquidity.
New user benefit: Enjoy 20% off trading fees upon registration!
Create a Market Data Table with Power Query
Binance's public market endpoint api.binance.com/api/v3/ticker/price requires no authentication, so Power Query can pull data directly from it.
Steps:
- In Excel, open the Data tab and select Get Data → From Other Sources → From Web.
- In the URL box, enter the Binance market endpoint. If you want to pull multiple trading pairs, it is more efficient to use the ticker/24hr endpoint with the symbols parameter, for example https://api.binance.com/api/v3/ticker/24hr?symbols=["BTCUSDT","ETHUSDT"]. You can pull up to 100 trading pairs in a single request.
- Power Query will return a table. If the result is a single row of JSON, you may need to convert it with Json.Document and then expand it.
- Click Close & Load, and the data will be loaded into an Excel worksheet.
An Excel file template that is already connected to the Binance API can be used directly. It automatically refreshes data every 1 minute through Power Query. You can adjust the refresh frequency according to your needs, but do not set it lower than this value.
Refresh settings are under Data → Queries & Connections → right-click the query → Properties. You can set it to refresh when the file opens, or refresh every N minutes. For market monitoring, 1–5 minutes is a reasonable range.
Price Validation: Don't Blindly Trust Imported Numbers
If you use API prices directly, there is an easy trap to fall into: you may be pulling testnet data.
An issue in the python-binance library recorded a real case: a user created a client with testnet=True and pulled BNB USDT K-line data. The opening price showed 240.6, but on the real Binance market, the opening price of the same K-line at the same time was 240.3. Testnet prices are generated by the test environment and are completely different from the mainnet.
If you use Python scripts or certain connectors to pull data, make sure you are connected to the mainnet endpoint (api.binance.com), not the testnet or any sandbox environment. Power Query connected directly to api.binance.com will not have this problem because there is no testnet option in the URL.
Another direction for validation is structural consistency. A mature OHLCV validation framework checks whether K-line data meets basic constraints: the highest price cannot be lower than the lowest price, volume cannot be negative, and the opening price cannot be zero. These checks do not require complex code; simple conditional formatting or formulas in Excel can do the job. If any row pulled from the API shows high < low or volume < 0, that row is bad and should not be used in any calculation.
Rate Limits: The Most Common Cause of Failure
Binance's IP request weight limit is 6,000 per minute. Exceeding this limit will result in HTTP 429. If you keep making requests after receiving 429, your IP will be banned (HTTP 418), with ban times ranging from 2 minutes to 3 days.
A single ticker/24hr request for all trading pairs (3,500+) may carry a significant weight. If you only pull a few trading pairs, the weight is very small, and refreshing every 1 minute is completely safe. But if you pull the entire market at once, do not set the refresh interval too short. Every Power Query refresh sends a new request, and frequent auto-refresh is the main cause of rate limiting.
If you receive a 429, stop refreshing immediately and wait at least one minute before trying again. Do not repeatedly click the refresh button, because that will only turn a 429 into a 418.
If You Need Higher-Frequency Updates
Power Query's refresh mechanism is suitable for minute-level monitoring. If you need second-level price updates, you need to take the WebSocket route, such as Binance's wss://stream.binance.com market data stream. Excel itself does not natively support WebSocket, so you need Python scripts or a dedicated Excel add-in to push data into the sheet. For most price validation and manual recording scenarios, Power Query's minute-level refresh is sufficient.
The world's largest cryptocurrency exchange by trading volume,leading in security and liquidity.
New user benefit: Enjoy 20% off trading fees upon registration!
References
- Binance Square·Latest BinanceAPI News, no update date indicated; checked on 2026-10-08.
- Apify·Binance Scraper API | Real-Time Crypto Tickers & Prices, published or updated on 2026-03-03; checked on 2026-10-08.
- Binance Developer Documentation·API Authentication Types, published or updated on 2026-07-30; checked on 2026-10-08.
- Binance Support·API FAQ, published or updated on 2018-06-04; checked on 2026-10-08.
- Binance Developer Documentation·Market Data Streams, published or updated on 2026-10-01; checked on 2026-10-08.
- GitHub·Inaccurate prices with get_klines · Issue #1379, published or updated on 2023-12-09; checked on 2026-10-08.
- GitHub·VersoXBT/live-ohlcv-validation-framework, published or updated on 2026-04-11; checked on 2026-10-08.
