Tutorial - Using exported Data from Superchart in MS Excel


Blynk team created a great widget we can use it to visualize the Data which is Superchart
we can attach many Virtual pins to generate a charts which is very helpful.

also we can export the data in "CSV" format , buy clicking the three dots under the superchart widget and select "export to CSV" you will receive and email from Blynk to your registered email address

in the email you will find attached CSV file for all the Vpins in your superchart

when opining it using MS excel you will find it as below


the Data is saved in we will find it in Unix timestamp format which is 10 digits represent the total number of seconds since midnight (GMT time) on January 1, 1970
So how can we convert it to a readable Date and time in MS excel

Below is the exact data we found after export without any edit we can see in Cell “B1” the value
“1537022340000” of timestamp which is 13 Digit but we need to use the first 10 digits only from the left
You can add the below formula in cell D1

=TEXT((LEFT(B1,10)/60/60)/24+DATE(1970,1,1)+(3/24),"DD/MM/YYY - hh:mm:ss")

if you will use it in any other similar conversion you can replace the"Timestamp Column" with your exported data , and "GMT Offset" with the number of hours from GMT to your local time zone , for example yourtime zone is +3 GMT use +(3/24) , if it is -1 GMT use -(1/24)

if you drag the formula to the reset of the rows you will get a similar result to below image


i hope this will be helpful to some of Blynkers here


Hello. Have you seen reporting widget?

not before you asked , as i can see it has alot of option and that is great thing.
but i noticed the energy required is zero to set up , but when i run the project it shows that it will cost 2,900 energy
is this is per report run or one time payment ? is it recoverable when widget deleted ?

i will take detailed look into this widget later , thanks @Dmitriy for the continuous great work

One time.


Muchas gracias, me sirvió la explicación de SuperChart Para Argentina utilice

Segundos desde 1/1/1970 =((IZQUIERDA(V7;10)/60/60)/24)+FECHA(1970; 1; 1)-(3/24)

1540500240000 17:44:00 - 25/10/2018 y la celda de la formula formato h:mm:ss - dd/mm/aaaa

Gracias, un cordial saludo desde Mar del Plata, Argentina. Eduardo Caporale.

Thank you very much, the explanation helped me SuperChart For Argentina use

Seconds since 1/1/1970 =((IZQUIERDA(V7;10)/60/60)/24)+FECHA(1970; 1; 1)-(3/24)

1540500240000 17:44:00 - 25/10/2018 and the cell of the formula format h:mm:ss - dd/mm/aaaa

Thank you, cordial greetings from Mar del Plata, Argentina. Eduardo Caporale


you are welcome , glad it help you

Thank you for the explanation of the timestamp format in the Blynk data and how to convert it into the Excel date value text. However, it’s better practice in Excel to use the internal timetime value rather than the converted text as in the example. So, I would use the formula


This converts the UnixDateText to the Excel datetime value (the floating number of days since 1/1/1900).

Then you can use a custom cell format like “YYYY-MM-DD HH:MM:SS” to display the number as a date/time value even though the date value is stored in the cell. This way, when you plot data in an x-y scatter chart as function of time, the axis will show the dates. If the time column is text, Excel will ignore it and plot the data as a simple line chart with the index value along the x-axis.


Hi, the 3 dots that were previously used in Blynk to generate the report are now missing in the new Blynk 2.0, do you by any chance know of another method of generating the excel sheet of data?