Need help exporting csv file from Thingspeak

2 次查看（过去 30 天）
Paul
Paul 2025-4-12
评论： Manikanta Aditya 2025-4-14
Hi All,
I'm trying to export my data from the Thingspeak site, I am getting the csv file but it only contains field 1, besides the timestamp and lat/long data, which is blank as I don't use. I have a total of 3 fields. I am using the "DOWNLOAD" button at the bottom of the import/export page for my channel.
I know I'm missing something but several hours of searching yields nothing.
Any help would be greatly appreciated.
Cheers
Paul

请先登录，再回答此问题。

采纳的回答

Manikanta Aditya
Manikanta Aditya 2025-4-12
编辑：Manikanta Aditya 2025-4-12
Hi @Paul,
It sounds like you're encountering an issue with exporting all your fields from ThingSpeak. Here are a few steps you can try to resolve this:
  • Ensure that all three fields are enabled and actively collecting data in your ThingSpeak channel settings.
  • Verify that your CSV file is properly formatted. The headers should include all fields you want to export, such as created_at,field1,field2,field3,latitude,longitude,elevation,status.
  • When using the "DOWNLOAD" button, make sure you're not inadvertently selecting only field 1. You might want to try exporting data using the API to ensure all fields are included. Use the following API endpoint to export all fields:
https://api.thingspeak.com/channels/<channel_id>/feeds.csv?api_key=<APIKEY>
Replace <channel_id> and <APIKEY> with your actual channel ID and API key.
Refer to the following MATLAB Answer which talks about the similar issue you encountered:
I hope this helps.
  4 个评论
显示 2更早的评论
Paul
Paul 2025-4-14
Hello @Manikanta Aditya,
We're in business! Thank you. I looked at my channel setup and everything was set correctly, nothing has changed in a long time, all 3 fields were checked etc.. I decided just on a whim to hit the SAVE button again then tried using the EXPORT button and this time it worked, dowloaded all 3 fields and I can see the data!
I have no idea why it fixed things but it did. You have taught me now multiple ways to extract data from Thingspeak, thank you so much for your help.
Cheers
Paul

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Downloads 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by