Download CSV & Clearing data | improvements requests. | Feature Requests | Forum


Please consider registering


— Forum Scope —

— Match —

— Forum Options —

Minimum search word length is 3 characters - maximum search word length is 84 characters

Register Lost password?
sp_Feed sp_TopicIcon
Download CSV & Clearing data | improvements requests.
New Member
Forum Posts: 2
sp_UserOfflineSmall Offline
January 2, 2018 - 10:21 pm
sp_Permalink sp_Print

Hello, there is a good feature called "Download all of this Channel's feeds in CSV format" but it would be even better if it would be possible to download the data for the last day/week/month/year instead of downloading the whole data.

Also, it would be great to have the ability to clear the data for the last day/week/month/year instead of clearing all data.

The ability to clear the data for the last day or week would be very useful when sensors for some reason start to send some wrong data to ThingSpeak.


Forum Posts: 126
sp_UserOfflineSmall Offline
January 3, 2018 - 2:30 pm
sp_Permalink sp_Print

You can complete the desired download with a REST API call.


If you want more than one day, add the days parameter

See the get channel feed documentation or get a channel field feed documentation for more parameters.

You can append multiple parameters using &, for example:


If you want, go to your channel private view and use the 'Data Export' button there.  Its next to the 'Add Visualizations' button.  When you press the button, it builds the URL for you and opens a new tab (for .json or .xml).  Look at the address and you can modify it to what you need.  The default is 1 day or 8000 points.  For '.csv' you can see the address when you hover over the '.csv', or just change the address from '.json' to '.csv'.

It is currently not possible to selectively delete data, I will look into if it could be included in a future update, thanks for your suggestions.


Forum Posts: 126
sp_UserOfflineSmall Offline
January 8, 2018 - 5:51 pm
sp_Permalink sp_Print

As of January 2018, ThingSpeak is not yet expiring any data.  Your past data usage does not count against your new capacity. If you intend to convert to a free license, the easiest thing you can do is slow down the data rate from your devices. Your existing data collected on ThingSpeak will remain. Slowing down of ingesting data to ThingSpeak will ensure you don't exhaust the capacity.  If you want to download a complete copy of your historical data, please reach out to support 'at' mathworks dot com with details about your channel that you want the data for.  We can email you a csv file or a link to the file of your complete data set.

Forum Timezone: America/New_York

Most Users Ever Online: 114

Currently Online:
18 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

rw950431: 252

Vinod: 164

cstapels: 96

piajola: 75

vespapierre: 63

Adarsh_Murthy: 59

Newest Members:







Forum Stats:

Groups: 4

Forums: 17

Topics: 1313

Posts: 4565


Member Stats:

Guest Posters: 1

Members: 5703

Moderators: 0

Admins: 2

Administrators: Hans, lee