Search code examples
google-sheetsbinance

Get Binance Fees into Spreadsheets (Google Sheets)

I am trying to import a table from Binance fees (https://www.binance.com/en/fee/depositFee) to Google Sheets (buy i am trying into MS Excel).

When i get data, i dont know how split files for each network type.

Now, i have data like this:

=IMPORTHTML("https://www.binance.com/en/fee/depositFee"; "table"; 0)

Caputre of sheet data

Thanks!!!

Solution

  • One solution is, after importing data as you did, is to split each line as following

    =iferror(transpose(flatten(arrayformula(transpose(split(transpose(C3:F3),char(10)))))),"")

    You will get multiple blocks of 4 columns. And finally you can group data like this way, assuming there is a max of 4 blocks :

    =query({query( 'raw data'!A3:V,"select A,B,G,H,I,J");query('raw data'!A3:V,"select A,B,K,L,M,N");query('raw data'!A3:V,"select A,B,O,P,Q,R");query('raw data'!A3:V,"select A,B,S,T,U,V")},"select * where Col3<>'' order by Col1")

    https://docs.google.com/spreadsheets/d/1JCjJywK9qPprynX2byvAnU7jS4S9cAYmHAfLcuyW3oQ/edit?usp=sharing