> For the complete documentation index, see [llms.txt](https://docs.hivesql.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.hivesql.io/tutorials/hivesql-for-microsoft-excel.md).

# HiveSQL for Microsoft Excel

This step*-*by-step tutorial will show how to use Microsoft Excel to retrieve data from the HiveSQL database and present your result in a simple but nice pivot chart.

#### Writing a SQL query <a href="#writing-a-sql-query" id="writing-a-sql-query"></a>

Let’s say for example you want to see how many transactions have been issued each month on the blockchain. The SQL query to get such information will be:

```
SELECT
    YEAR(Blocks.timestamp) AS [Year],
    MONTH(Blocks.timestamp) AS [Month],
    COUNT(*) AS [Transactions]
FROM
    Transactions
    INNER JOIN Blocks ON Transactions.block_num = Blocks.block_num
GROUP BY
    YEAR(Blocks.timestamp),
    MONTH(Blocks.timestamp)
```

**Retrieving data with Excel**

*Start Excel, go to the Data tab and select SQL Server as your data source*

<div align="left"><img src="/files/-M_pIGcZzSeIKcHWJlyb" alt=""></div>

*The Data Connection Wizard will be displayed*

<div align="left"><img src="/files/-M_pI3kuQeFtDMrUMIiU" alt=""></div>

*Enter the connection information in the wizard dialog box as shown and click "Next"*

{% hint style="info" %}
*Use your **HiveSQL account** login and password (see* [*Register your HiveSQL account*](/register-your-hivesql-acount.md)*)*
{% endhint %}

<div align="left"><img src="/files/-M_pJl24O8PXUXiSD15S" alt=""></div>

*Select any table (it doesn’t matter at this stage) and click '"Finish" to close the wizard*

<div align="left"><img src="/files/-M_pK0DxqCYTtS-AB9u3" alt=""></div>

*Click on* *"Properties"*

<div align="left"><img src="/files/-MaUZG3GbmgMaQWon2yt" alt=""></div>

*Select the "Definition" tab and* c*heck the "Save Password" checkbox to avoid Excel asking you for credentials each time you connect to the database.*

![](/files/-M_pMzfz6R6OiT8ZfjzN)

*You can safely ignore the warning if your computer is secure*

<div align="left"><img src="/files/-M_pNS0WLUVgzLRXpNzZ" alt=""></div>

*Open the "Command type" dropdown control and select "SQL"*

<div align="left"><img src="/files/-M_pOIE2BijdqlSGoLUN" alt=""></div>

*Paste your SQL query and click* `OK`

![](https://images.hive.blog/0x0/http://i.imgsafe.org/7e1f6d273e.png)\
\&#xNAN;*Select the type of data presentation you want in Excel.*

#### Finalizing the presentation <a href="#finalizing-the-presentation" id="finalizing-the-presentation"></a>

Now that you got all your data, make a nice chart.

<div align="left"><img src="/files/-M_pRIW5ki4CTA-C0zjQ" alt=""></div>

*Organize your data fields in the pivot properties*

![](/files/-M_pRiD9vyso44AgGR8K)

You now have created your report using the blockchain data.