Import data to Google Sheets/Excel
In this article
Introduction
Getting started
Retrieve BTC Exchange Rates in csv format via web browser
CSV import: Microsoft Excel
CSV import: Google Sheets
Summary
Introduction
There are various methods to access market data, including utilizing programming languages or tools that enable REST API requests.
In this guide, we will specifically concentrate on extracting data in CSV
(comma-separated-values) format
using simple approach that involves accessing data directly through web browser
.
CSV
is widely used due to its simplicity and compatibility with various spreadsheet applications like Microsoft Excel and Google Sheets.
Getting started
Before diving into the tutorial, ensure you have:
- Web browser installed:
google chrome
,firefox
,microsoft edge
or any other - A CoinAPI key (obtainable by signing up on the CoinAPI website)
- Spreadsheet application like
Microsoft Excel
orGoogle Sheets
Retrieve BTC Exchange Rates in csv format via web browser
It is possible to control format of data by using output_format variable in query string parameters.
To get BTC
exchange rates in csv
format, copy and paste below URL to address bar of your web browser:
https://rest.coinapi.io/v1/exchangerate/BTC?apikey=YOUR_API_KEY-ed802af4-e855-4505-AEA&output_format=csv
Note: Don't forget to replace YOUR-API-KEY
with your actual API key.
Simple then press ctrl
+a
or command
+a
to select exchange rates,
then press ctrl
+ c
to copy data.
After obtaining the data, you can seamlessly paste it directly into any text editor.
Then, select Save As
option, and don't forget to include the .csv
file extension.
CSV import: Microsoft Excel
To import the .csv
file into the MS Excel application, navigate to the Data
tab, and choose the From Text/CSV
option.
Select your .csv
file which includes BTC exchange rate data in csv
format.
Verify the output of import in preview window.
With these simple steps, you can now efficiently work with and analyze the market data in a familiar spreadsheet environment, empowering you to make informed decisions based on the exchange rate information.
CSV import: Google Sheets
To import the .csv
file into the Google Sheets application, navigate to the File
menu.
Within that menu, select Import
option.
Upload your .csv
file which includes BTC exchange rate data.
Make sure to set correct Import location
and Separator type
, then press Import data
.
Here's the final result:
With these simple steps, you can now efficiently work with and analyze the market data in a familiar spreadsheet environment, empowering you to make informed decisions based on the exchange rate information.
Summary
We have explored a simple approach to access market data in CSV format directly through a web browser.
By utilizing this method, you can easily extract the data you need for analysis and integrate it with various spreadsheet applications like Microsoft Excel
or Google Sheets
.
While the simple approach through a web browser provides easy access to market data in csv format,
there is cryptotick specialized platform (opens in a new tab) that offer a wide range of market data types in csv
format,
including quotes
, trades
, limit order book
, OHLCV
and other.
Happy data exploration!