how to send data from excel sheet to thingspeak automatically

Hello Frineds

I am very new to this platform and just explore some very usefull features.

I did test to send data from LabVIEW to thingspeak and also upload my csv file.

what i want is that as my csv file updated on daily basis so i want this updated data should also send to thingspeak.

Any guid or help please?

Thanks

Asif

[Christopher Stapels]

To call an API from Excel, Go to the “Data” tab and click on “New Query” → “From Other Sources” → “From Web”

1. Click on “Advanced”
2. Paste the API URL on the prompt and click OK
3. Select Into Table on the Convert tab

Use the read data api with the '.csv' extention,

The URL looks like this

https://api.thingspeak.com/channels/<channel_id>/feeds.<format>
https://api.thingspeak.com/channels/<channel_id>/feeds.csv

[Asif Iqbal]

Hi Stapels

Thanks for your reply

your method performs to read data from thingspeak to csv file.

but i want my csv data to automatically update on thingspeak.

hope you understand.

Thanks

asif

[Christopher Stapels]

you have data in a csv file that you want to automatically send from your computer to ThingSpeak when you update the data?

[Asif Iqbal]

yes now you get my point.

Answer 1

[Christopher Stapels]

Probably the best way would be to use MATLAB installed on your machine. You can use ThingSpeak write and automate a process in a few different ways,

There is also a write data API that you can send data to, but you would have to look into some way to automate that command based on your computer. If you have a Linux machine, for example, you can use a cron job. Windows has a task scheduler that might help. If you come up with a good tool to use, please post here if you can.

[Asif Iqbal]

Ah, I can not install MATLAB on my computer. while using thingspeak just came in my mind about this idea that the data i have in excel or csv shoud be posted on thingspeak automatically instead of bulk post manually.

any other suggestion would be appriciated.

Thanks

Asif