<p>Here is the link.
Just insert this into your excel file</p>

<pre><code>=IMPORTXML("http://coinmarketcap.com/currencies/bitcoin/","//span[@id='quote_price']")
</code></pre>

CC BY-SA 3.0
2017-03-05T05:45:23.183Z
What is the minimum Excel version that supports IMPORTXML?
Dan Dascalescu
CC BY-SA 3.0
2017-06-25T06:43:01.253Z
It works but when I try to work with it for example divide or multiply the price I get #VALUE! error the price is shown as text instead of a number. Any solutions for this? Thanks
Tim GVK
CC BY-SA 3.0
2017-09-01T01:06:04.227Z
This also works with google docs
guribe94
CC BY-SA 3.0
2017-12-07T07:49:10.310Z
use value() to convert the text to a number in Google sheets and Excel
vinnief
CC BY-SA 3.0
2018-01-05T12:45:55.687Z
This works really great. Any chance on improving to get the value only in text-large2
snh_nl
CC BY-SA 4.0
2020-03-24T13:37:35.963Z
NOT WORKING ANYMORE! I used this formula in google docs and it worked for a long time but now it is not working anymore. Do I need to change something?
user2756695
CC BY-SA 3.0
2017-01-16T00:33:06.507Z
2017-05-31T12:59:59.297Z
2017-05-31T12:59:59.297Z
Zee
<p>Here's a simplified macro that works as far back as Excel 2007, original credit <a href="http://investexcel.net/real-time-foreign-exchange-rates-excel/" rel="nofollow noreferrer">Samir Khan</a>:</p>

<pre><code>Sub GetBTCUSD()

Range("BTCUSD").Select
Selection.ClearContents

With ActiveSheet.QueryTables.Add(Connection:= _
     "URL;https://api.bitcoinaverage.com/ticker/USD/last", Destination:=Range("BTCUSD"))
    .Name = "BTCUSD field that will pollute your Name Manager but I don't know how to get rid of"
    .AdjustColumnWidth = False
    .PreserveFormatting = True
    .RefreshOnFileOpen = True
    .BackgroundQuery = True
    .RefreshStyle = xlOverwriteCells
    .SaveData = False
    .RefreshPeriod = 0
    .WebSingleBlockTextImport = False
    .WebDisableRedirections = False
    .Refresh BackgroundQuery:=False
End With

End Sub
</code></pre>

<p>To use the macro:</p>

<ol>
<li>Name a column in your spreadsheet "BTCUSD" (just click in the Name Box in the top left and type "BTCUSD"</li>
<li><a href="https://www.google.com/search?q=how%20to%20insert%20a%20button%20excel" rel="nofollow noreferrer">Add a button</a> to the sheet (you can name it "Get BTCUSD")</li>
<li>Create a new Macro and paste the code above</li>
<li>Right click the button, choose Assign macro, and pick the <code>GetBTCUSD</code> macro.</li>
</ol>

CC BY-SA 3.0
2017-03-05T06:22:28.157Z
2017-03-26T23:31:07.693Z
2017-03-26T23:31:07.693Z
Dan Dascalescu
<p>I tried this with Excel 2016:</p>

<pre><code>Cell J2 = https://query.yahooapis.com/v1/public/yql?q=
Cell J3 = select * from html where url='https://coinmarketcap.com/currencies/bitcoin/' and xpath='//span[@id="quote_price"]'
Cell J4 = &amp;diagnostics=true&amp;env=store://datatables.org/alltableswithkeys
</code></pre>

<p>Insert the following into the Cell where you want the actual price:</p>

<pre><code>=XMLFILTERN(WEBDIENST($J$2&amp;URLCODIEREN($J$3)&amp;$J$4);"//span")
</code></pre>

CC BY-SA 3.0
2017-04-06T20:10:37.287Z
2017-04-06T20:10:37.287Z
weasle
<p>Start here:
<a href="https://groups.yahoo.com/neo/groups/smf_addin/info" rel="nofollow">https://groups.yahoo.com/neo/groups/smf_addin/info</a></p>

<p>While it is a stock market add-in, it works with Yahoo Finanace and since Yahoo now lists Bitcoin (Symbol: BTCUSD=X)  Yes, that is the symbol you use to get the price, it will update your spreadsheet every time there is a change made to the spreadsheet or when you force the sheet to recalculate.</p>

<p>This fits the bill for what you need.</p>

CC BY-SA 3.0
2014-09-27T14:32:23.720Z
2014-09-27T14:32:23.720Z
Thomas Perry
<p>I'm trying to so some maths calculations with Excel but I need to get the current btc value from any website that can provide it in any format but simple as possible.</p>

<p>Do you have any idea to get the current btc value (usd) and update it in real time in an excel sheet? Thanks.</p>

CC BY-SA 3.0
2014-03-16T01:06:58.350Z
Try to use `Web queries` in excel, you can adjust which information you want to retrieve. references - http://office.microsoft.com/en-ca/excel-help/get-external-data-from-a-web-page-HA010218472.aspx
Marek
CC BY-SA 3.0
2017-06-19T12:43:27.123Z
@fredsbend mistake from me, sorry.
zeflex
CC BY-SA 3.0
2017-10-23T05:58:00.290Z
You can use excel add-in http://cryptoexcel.net/
Oleg
<value><btce><live-data>
Get simple BTC value to insert it in excel sheet
zeflex
# Get simple BTC value to insert it in excel sheet

(Asked by: username_0 on 2014-03-15)

I'm trying to so some maths calculations with Excel but I need to get the current btc value from any website that can provide it in any format but simple as possible.

Do you have any idea to get the current btc value (usd) and update it in real time in an excel sheet? Thanks.

**Tags:** value, btce, live-data

> **Comments:**
> **username_1**: Try to use `Web queries` in excel, you can adjust which information you want to retrieve. references - http://office.microsoft.com/en-ca/excel-help/get-external-data-from-a-web-page-HA010218472.aspx  
> **username_0**: @fredsbend mistake from me, sorry.  
> **username_2**: You can use excel add-in http://cryptoexcel.net/  

---

## 4 answers

### Answer by username_3 on 2017-01-16. Score: 3

Here is the link.
Just insert this into your excel file

```
=IMPORTXML("http://coinmarketcap.com/currencies/bitcoin/","//span[@id='quote_price']")

```

> **Comments:**
> **username_4**: What is the minimum Excel version that supports IMPORTXML?  
> **username_5**: It works but when I try to work with it for example divide or multiply the price I get #VALUE! error the price is shown as text instead of a number. Any solutions for this? Thanks  
> **username_6**: This also works with google docs  
> **username_7**: use value() to convert the text to a number in Google sheets and Excel  
> **username_8**: This works really great. Any chance on improving to get the value only in text-large2  
> **username_9**: NOT WORKING ANYMORE! I used this formula in google docs and it worked for a long time but now it is not working anymore. Do I need to change something?  

---

### Answer by username_4 on 2017-03-05. Score: 0

Here's a simplified macro that works as far back as Excel 2007, original credit [Samir Khan](http://investexcel.net/real-time-foreign-exchange-rates-excel/):

```
Sub GetBTCUSD()

Range("BTCUSD").Select
Selection.ClearContents

With ActiveSheet.QueryTables.Add(Connection:= _
     "URL;https://api.bitcoinaverage.com/ticker/USD/last", Destination:=Range("BTCUSD"))
    .Name = "BTCUSD field that will pollute your Name Manager but I don't know how to get rid of"
    .AdjustColumnWidth = False
    .PreserveFormatting = True
    .RefreshOnFileOpen = True
    .BackgroundQuery = True
    .RefreshStyle = xlOverwriteCells
    .SaveData = False
    .RefreshPeriod = 0
    .WebSingleBlockTextImport = False
    .WebDisableRedirections = False
    .Refresh BackgroundQuery:=False
End With

End Sub

```

To use the macro:

1. Name a column in your spreadsheet "BTCUSD" (just click in the Name Box in the top left and type "BTCUSD"
2. [Add a button](https://www.google.com/search?q=how%20to%20insert%20a%20button%20excel) to the sheet (you can name it "Get BTCUSD")
3. Create a new Macro and paste the code above
4. Right click the button, choose Assign macro, and pick the `GetBTCUSD` macro.


---

### Answer by username_10 on 2017-04-06. Score: 0

I tried this with Excel 2016:

```
Cell J2 = https://query.yahooapis.com/v1/public/yql?q=
Cell J3 = select * from html where url='https://coinmarketcap.com/currencies/bitcoin/' and xpath='//span[@id="quote_price"]'
Cell J4 = &diagnostics=true&env=store://datatables.org/alltableswithkeys

```

Insert the following into the Cell where you want the actual price:

```
=XMLFILTERN(WEBDIENST($J$2&URLCODIEREN($J$3)&$J$4);"//span")

```


---

### Answer by username_11 on 2014-09-27. Score: 0

Start here:
<https://groups.yahoo.com/neo/groups/smf_addin/info>

While it is a stock market add-in, it works with Yahoo Finanace and since Yahoo now lists Bitcoin (Symbol: BTCUSD=X) Yes, that is the symbol you use to get the price, it will update your spreadsheet every time there is a change made to the spreadsheet or when you force the sheet to recalculate.

This fits the bill for what you need.


---

