To export Telegram channel history to CSV for a specific date range, enter a public channel username, set the start and end dates in UTC, and export the resulting messages from Apify. For this walkthrough I used @cointelegraph, selected November 18–19, 2026 UTC, and exported ten posts. Each CSV row has a timestamp and a link back to the original message. You can follow along in Apify without a Telegram login.
Open the Telegram channel history export task
1. Filter public Telegram channel messages by date
Open the task and choose the option to try it in Apify Console. Sign in to Apify if prompted. The example opens with the Telegram announcements channel and a saved date range. Replace those values before starting the run. In the JSON input editor, use this configuration to reproduce the selection:
{
"channels": ["cointelegraph"],
"afterDate": "2026-11-18",
"beforeDate": "2026-11-19",
"maxMessagesPerChannel": 10,
"maxMessages": 10,
"outputPreset": "compact",
"includeChannelInfo": true,
"downloadMedia": false
}
Use the channel username without the @ sign. The compact preset gives you flat columns for a spreadsheet. Both limits are ten here because we want a small sample from one channel. For a larger export, adjust both limits and review the pricing. For this run I set the maximum charge to USD 0.02 in Run options.
2. Run the export and check the timestamps
Click Start, wait for the run to finish, and open its dataset under Output. The run returned ten distinct message IDs, all dated November 19 UTC. The earliest returned post was published at 15:16:01 and the latest at 22:40:01. The run reached its ten-post limit, so this sample cannot tell you how many messages appeared across both days. To examine November 18 by itself, select that day and check whether your result cap was reached again.
Selected columns from the actual dataset, displayed as a local CSV preview. View counts reflect the time of collection.
3. Export Telegram messages to CSV for Excel or Google Sheets
In the dataset, choose Export, select CSV, and download the file. To match the example below, keep the five columns in the header. For content analysis, also include the dataset’s text column. Open the CSV in Excel or import it into Google Sheets. Keep publishedAt in UTC when comparing it with the input dates.
Copy the full sample below into channel-history.csv to open it in a spreadsheet.
channelUsername,messageId,publishedAt,messageUrl,views
cointelegraph,73399,2026-11-19T22:40:01.000Z,https://t.me/cointelegraph/73399,1
cointelegraph,73397,2026-11-19T20:35:01.000Z,https://t.me/cointelegraph/73397,3420
cointelegraph,73396,2026-11-19T19:56:32.000Z,https://t.me/cointelegraph/73396,4500
cointelegraph,73395,2026-11-19T18:10:39.000Z,https://t.me/cointelegraph/73395,5480
cointelegraph,73394,2026-11-19T17:13:49.000Z,https://t.me/cointelegraph/73394,6140
cointelegraph,73392,2026-11-19T17:04:27.000Z,https://t.me/cointelegraph/73392,5230
cointelegraph,73391,2026-11-19T16:52:20.000Z,https://t.me/cointelegraph/73391,5400
cointelegraph,73389,2026-11-19T16:40:01.000Z,https://t.me/cointelegraph/73389,5230
cointelegraph,73388,2026-11-19T15:50:01.000Z,https://t.me/cointelegraph/73388,6330
cointelegraph,73386,2026-11-19T15:16:01.000Z,https://t.me/cointelegraph/73386,6300
Open the first row’s link to inspect the source. A live view count can grow after export. If you combine overlapping date windows, use the original message URL as the unique key so the same post appears once. Check the first post on Telegram
Try the date-range export with your own channel. If you have a topic but still need to find the channels discussing it, start with the Telegram keyword search walkthrough.


Top comments (0)