# Import BRVM prices into Excel, Google Sheets or Power BI

Two public CSV files, no account or key: the latest session of every share and the history of each share. Addresses, steps, refresh and formats.

 

## Which addresses should I use?

For the latest session of every listed share: https://brvmdata.com/telechargements/actions-derniere-seance.csv. For one share's history: https://brvmdata.com/telechargements/actions/&lt;symbol&gt;.csv, replacing &lt;symbol&gt; with the lower-case BRVM symbol (https://brvmdata.com/telechargements/actions/snts.csv for Sonatel).

The first file has one row per share (48 in the bulletin of 19 November 2026), the second one row per session with a trade. The large quote tables on the [Data](<https://brvmdata.com/en/donnees/>) page weigh several megabytes: no need to reload them to follow a few prices.

- Latest session, every share (CSV): ` https://brvmdata.com/telechargements/actions-derniere-seance.csv `
- The same in JSON: ` https://brvmdata.com/telechargements/actions-derniere-seance.json `
- One share's history (CSV): ` https://brvmdata.com/telechargements/actions/<symbol>.csv `

Sources

[Official bulletin no. 221 (19 Nov 2026)](<https://www.brvm.org/sites/default/files/boc_20261119_2.pdf>)

 

## How do I import prices into Google Sheets?

In an empty cell, type =IMPORTDATA("https://brvmdata.com/telechargements/actions-derniere-seance.csv"): the sheet fills with the header, then one row per share.

For Sonatel's history, the formula is the second one below. If your sheet uses a decimal comma and numbers stay left-aligned as text, switch it to a decimal-point locale (File &gt; Settings &gt; Locale, for example United Kingdom).

```
=IMPORTDATA("https://brvmdata.com/telechargements/actions-derniere-seance.csv")
=IMPORTDATA("https://brvmdata.com/telechargements/actions/snts.csv")
```

Sources

[Google Docs Editors Help — IMPORTDATA](<https://support.google.com/docs/answer/3093335?hl=en>)

 

## How do I import prices into Excel?

In Excel for Windows (Microsoft 365 or Excel 2016 and later), choose Data &gt; From Web, paste the CSV file address and confirm: Power Query shows a preview, which you load into a sheet.

1. Data &gt; From Web.
2. Choose Basic, paste the file address, then OK.
3. On the first connection, choose Anonymous access, then Connect.
4. In the preview, check the file origin (65001: Unicode UTF-8) and the delimiter (comma), then Load, or Transform Data to set the column types.

Sources

[Microsoft Learn — Power Query Web connector](<https://learn.microsoft.com/en-us/power-query/connectors/web/web>)

 

## How do I import prices into Power BI?

In Power BI Desktop, choose Get Data &gt; Web, paste the CSV file address, confirm, then Load.

1. Home &gt; Get Data &gt; Web.
2. Choose Basic, paste the file address, then OK; on the first connection, choose Anonymous.
3. In the preview, Load, or Transform Data to set the column types with a locale (see below).

Sources

[Microsoft Learn — Power Query Web connector](<https://learn.microsoft.com/en-us/power-query/connectors/web/web>)

 

## How do I keep the prices up to date?

Refresh the query: the files are regenerated at every data update, at most four times a day (after 07:30, 17:15, 19:45 and 22:45 UTC), at the same address.

Excel: Data &gt; Refresh All; the query properties can also refresh when the file opens or every N minutes. Power BI Desktop: Home &gt; Refresh. Google Sheets reloads IMPORTDATA by itself, at its own pace. Refreshing once an hour is more than enough.

 

## Why are some numbers or dates not recognised?

The files use a decimal point, no thousands separator, ISO dates (YYYY-MM-DD) and UTF-8; software set to a decimal comma may read them as text.

In Power Query (Excel and Power BI), right-click the column header &gt; Change Type &gt; Using Locale, then choose the type (decimal number, date) and English (United States). An empty cell means a missing value, never zero.

Sources

[Microsoft Learn — data types and locale in Power Query](<https://learn.microsoft.com/en-us/power-query/data-types>)

 

## What do the columns contain?

The latest session gives, per share, the close (close\_xof), the day's change, volume, value traded, change since 1 January, P/E, net yield, last dividend and market capitalisation; the basis column says whether prices come from the official bulletin or a provisional session.

The history gives close\_xof, the price as published, and adj\_close\_xof, adjusted for splits as on the charts, with volume, value and source (boc: official bulletin; bfin: session database; intraday: closing screen). The full dictionary is on the [Latest session](<https://brvmdata.com/en/donnees/actions-derniere-seance/>) and [Per-share history](<https://brvmdata.com/en/donnees/actions-historique/>) dataset pages.

 

## Can I reuse this data, and how do I cite it?

Access is free, but this is not a redistribution licence: each source's terms are set out in the [terms of use](<https://brvmdata.com/en/donnees/#licence>).

Cite the original source and brvmdata with the session date, for example: "BRVM, official bulletin of 19 November 2026; data formatted by brvmdata.com (https://brvmdata.com/telechargements/actions-derniere-seance.csv), accessed on &lt;date&gt;". A basis=provisional row is cited as provisional, before the official bulletin.

 

The guide · [How the BRVM works](<https://brvmdata.com/en/guide/fonctionnement-brvm/>) · [Buying shares on the BRVM](<https://brvmdata.com/en/guide/acheter-actions-brvm/>) · [BRVM trading hours](<https://brvmdata.com/en/guide/horaires-brvm/>) · [Reading the Official Quotation Bulletin](<https://brvmdata.com/en/guide/bulletin-officiel-de-la-cote/>) · [Understanding BRVM dividends](<https://brvmdata.com/en/guide/dividendes-brvm/>) · [WAEMU Treasury bills and bonds](<https://brvmdata.com/en/guide/titres-publics-umoa/>) · [P/E ratio and dividend yield](<https://brvmdata.com/en/guide/per-rendement/>) · [Understanding BRVM indices](<https://brvmdata.com/en/guide/indices-brvm/>) · [Glossary](<https://brvmdata.com/en/guide/glossaire/>) · Import BRVM prices into Excel, Google Sheets or Power BI

Documentary content, not investment advice or a recommendation. Official sources checked on 15 November 2026.

---

[Canonical page](<https://brvmdata.com/en/guide/excel-google-sheets-power-bi/>)

Data as of 15 November 2026.

## Sources for this page

- [Official bulletin no. 221 (19 Nov 2026)](<https://www.brvm.org/sites/default/files/boc_20261119_2.pdf>)
- [Google Docs Editors Help — IMPORTDATA](<https://support.google.com/docs/answer/3093335?hl=en>)
- [Microsoft Learn — Power Query Web connector](<https://learn.microsoft.com/en-us/power-query/connectors/web/web>)
- [Microsoft Learn — data types and locale in Power Query](<https://learn.microsoft.com/en-us/power-query/data-types>)
