Export Blynk app data to Excel Sheet | Blynk Superchart | SBU
ฝัง
- เผยแพร่เมื่อ 8 ม.ค. 2021
- In this episode of SBU, I'm showing you one technique of downloading data from your Blynk application to your computer in CSV Excel sheet format.
In Blynk you can visualise the realtime data as well as the past data in graphical manner which is also shown in this episode of Short But Useful
JOIN techiesms membership for less than a Dollar - / @techiesms
You can support me🙏🏻 and also get benefitted on Patreon :- / techiesms
Subscribe now💪🏻 to watch some amazing videos coming up soon.
bit.ly/techiesms_youtube
_________________________________________________________________
👨🏻💻 Important Links 👨🏻💻
Code used in this project - github.com/techiesms/DHT11_No...
_________________________________________________________________
Now you can get free PCB with every order of techiesms T-shirt or techiesms pocket notebook.
You can buy the merchandise from here,
techiesms.com/merchandise/
_________________________________________________________________
👀 You may Like these videos 👀
Automate any task with time - • Automate the task with...
Get a call every time your favourite TH-camr uploads a new video - • TH-cam Notification P...
_________________________________________________________________
Buy the components from your projects 💡🔌
ESP32 board - amzn.to/3jiwCD6
NodeMCU - amzn.to/2wbzNrZ
5V Relay - amzn.to/2OXAewN
BC547 Transistor - amzn.to/2SK3Fna
9V2A Adapter - amzn.to/3bDZjGx
7805 IC - amzn.to/2SunOic
PIR Motion sensor - amzn.to/2wclovE
DHT11 Temperature & Humidity Sensor - amzn.to/2UP8y0R
Proximity sensor - amzn.to/326YP7P
MQ135 Gas Sensor - amzn.to/2SKFBR4
LDR Light Sensor - amzn.to/2SsYskp
2pin Terminal Connectors - amzn.to/37uezT2
1n4007 diode - amzn.to/2SL4n3x
330 ohm resistors - amzn.to/2OQqUuz
Visit my Amazon Storefront for purchasing any components you need for this project or any other project :-
bit.ly/techiesms-Amazon-Store
_________________________________________________________________
🎥 🎙 My Video Gear 🎙🎥
Camera - Canon 750d
Lens - 50mm f/1.8 STM Lens (amzn.to/32gqnsi), 24mm f/2.6
Key Light - Godox SL60W (amzn.to/3522mHe)
Fill Light/Back Light - Osaka Lightning Setup (amzn.to/2I5cdDi)
Microphone - Samson Meteor (amzn.to/32jfVAt)
Editing - MacBook Pro
_________________________________________________________________
Subscribe Now :- bit.ly/techiesms_youtube
Facebook :- / techiesms
Twitter :- / imtechiesms
Instagram :- / techiesms
Website :- www.techiesms.com
WhatsApp number :- +91 82000 79034
You can support me and also get benefitted on Patreon :- / techiesms
_________________________________________________________________
techiesms
explore | learn | share - วิทยาศาสตร์และเทคโนโลยี
Ive been looking for this. Thank you very much 🙏
I was busy in my job now only I'm watching this video this really awesome feature, I didn't know this feature until I watching this
Thank you really helpful I'm doing my final year project:)
That was both useful and awesome, your English is also excellent.
After a long time SBU tutorial! Good Job
Glad you liked it!
Amei, muito obrigada por esse vídeo tão perfeito.
lovely and straight to the point.
kudos
Thank you
I would just say
#ShareVideoShareKnowledge
Super effort Bro. Kindly you make a video for ESP to cloud connect and share the sensor reading to cloud. It will be very helpful for us. Thank you Bro
Maza aa gaya ye feature jaan k
i like your style. Regards from MExico
always good tutorials, thank you brother
Glad you like them!
Keep it up bro
Really it is very useful stuff for those who are working into commercial projects. Sir I am asking one suggestion to you the Blynk app we can install local server is possible and use unlimited features. Kindly make video on that it is very useful for the organisations.
Thanks very much for the awesome video. I want to make wristband based on esp32 and sensors how can I send the sensor readings wireless without using blynk.
Nice Tutorial keep it up, you are always to the point.
Thanks!!
@@techiesms do you have whatsapp I need to discuss something with you, here my website www.controlsprocess.org
Hi, can I do it automaticaly? I want to make a database of my sensors
PD: GREAT VIDEO
Fantastic and very useful!
Do share it with others if you think it’s useful
Thanks 😊
Hi - good how-to. I was charting a 10 minute event in 1 second intervals but noticed that when doing the CVS extract it only sent about 25 data points even tho the app chart allows scrolling back and forth across the whole 10 minutes. Any idea if the CVS extract is capped at sending the last 25 chart points?
Thank you very much, though I had used this widget not aware of exporting to excel sheet
Glad it helped!
Thank you, it's very interesting. but I'm running local Blynk server and my server can not sent email to me. Is this only work on cloud server?
Great ♥
Thank youuu
I have so many questions, please make code tutorials for esp32 pls
I just found your channel, and I'm really learning a lot from you. Thank you! I have been using Blynk for a while, and I notice that although the superchart can plot real time data every second, when you export it to Excel, you only get data once a minute. Is there a way to export ALL the data collected?
no
lol.. this vid was about that way you were asking here
Useful
Amazing........ ⭐⭐⭐⭐⭐
Thanks 😊
Dear sachin sir
Please make a video explaining how to use blynk app server on computer
Kindly provide iot energy meter using zmpt voltage sensor and split core current transformer
Very information video sir.
Thanks and welcome
It's nice technic
Brother please make a video this under
How many time room lights on and how many time lights off
This events store with current time,date and year also
So that we will able to got the data time to time
Please please make it bro
Hello, how about displaying data from blynk cloud to VS C# Winform?
hi, I'm doing my project and I don't know how to program esp32 in blynk to graph
Hello I love your videos!!!, But I have question , is there anyway to use Blynk in the computer?
You have to install local blynk server
Sir i want to build a sliding gate control panel with wifi , can you help me🙏
Can i do it using free blynk? Or need to pay?
Sir you have made so many home automation like with(Bluetooth+wifi),(withinternet+withoutinternet),(with alexa) ....and so on, all these videos contains only two way operation ,but now make some projects which includes (withinternet+withoutinternet+Bluetooth+Alexa + non humming fan speed controller )all the ingredients in one (ALL IN ONE)whatever you know, because I am waiting for such videos ,it will be fully loaded full functional esp32
how to convert unix timestamp to excel
Superb dude 1st comment
Thank you so much 😀
Can you make a project on how to make a app like blynk. Like can you make a app which has all the features of blynk.
By saying all features i meant that it should have wifi, bluetooth connectivity etc.
I already know this Export CSV option. Now only I know Time stam in XL sheet
i need help why i can't open my data?
Thank you sir, i want to ask about the time (hours and minutes) in excel. why time is not the real time when using formula =(((B1/1000)+19800)/86400)+DATE(1970,1,1) ?
It follow offset in second time zone your region. Change the +19800 with your offset region
yes i knew it before. but u can't see the digital pins record in any app. please tell me how i can see logs of a digital pin?
I think we can use the digital pins as well. It’s pretty straight forward
@@techiesms we can use digital pins but we can't see the logs of digital pins. can we?
Hi, sir data export totally free ?
Yes
please subtitle english 😞