Hi Bryce, web pages usually export in html format as the CSS is applied on the site itself. Even Medium exports html format. Try this tip instead, it is manual, but you get format, likes and comments from your posts.
Thanks so much Jayshree! I downloaded the whole index file earlier BUT for me anyways, I could not find the URL link to correspond with each post - so started adding that manually to a separate column... Or am I missing something?
Good tip. I want to point out that your comments, likes - the engagement on the post will not get exported (unless Substack added it recently, which I am not aware of). This gap in the export process was found out the hard way by a Substacker who left to the Ghost platform (you know why) and she realized that the export process was not exactly all-inclusive. I wrote about it here if anyone wants to dig deeper into the export-import process.
I did your trick and turn my phone sideways and I was able to find the import export section. The same happens to me when I’m trying to add a hyperlink to my articles. If I turn it sideways I can add it. Thank you for the tip!
lol, welcome to the UX of this platform! It isn't tested for responsiveness I suppose. Best to do the settings and design aspects from a desktop/laptop browser would be my recommendation.
Wait...so I am not losing my mind here? The only way to get the open rate, views, clicks, etc is to go through post by post or through separate files sendtfor each post? There is no aggregation?
I exported everything just fine but the csv titled: posts (which I thought would give me the summary) only provides:
post_id
post_date
is_published
email_sent_at
inbox_sent_at
type audience
title
subtitle
podcast_url
I am looking to find the average and trends for a newsletter over the years.
It's disappointing that it doesn't seem to retain any formatting for content. Is there a way to export with logical markup <h1> etc?
Hi Bryce, web pages usually export in html format as the CSS is applied on the site itself. Even Medium exports html format. Try this tip instead, it is manual, but you get format, likes and comments from your posts.
https://open.substack.com/pub/techmadesimpleguide/p/want-to-save-your-substack-stories?r=1si0oc&utm_campaign=post&utm_medium=web
Thanks for showing this feature. As an engineer I like backups of everything I run. Just did my fist export of packagemain.tech
Thank you! I had forgotten about this!
You are welcome. I wish Substack would enable an auto-back up option setting. Sigh!
Thanks for this important reminder. This article was so helpful to me, as I was just exporting my email list and not my posts.
So helpful, thank you 😊
Thanks so much Jayshree! I downloaded the whole index file earlier BUT for me anyways, I could not find the URL link to correspond with each post - so started adding that manually to a separate column... Or am I missing something?
Good tip. I want to point out that your comments, likes - the engagement on the post will not get exported (unless Substack added it recently, which I am not aware of). This gap in the export process was found out the hard way by a Substacker who left to the Ghost platform (you know why) and she realized that the export process was not exactly all-inclusive. I wrote about it here if anyone wants to dig deeper into the export-import process.
https://rajofftherecord.substack.com/p/pros-and-cons-of-moving-from-substack
You can get al your likes, comments, per post, when you save the articles as a pdf, so it is possible. I show how to do that here
https://open.substack.com/pub/techmadesimpleguide/p/want-to-save-your-substack-stories?r=1si0oc&utm_campaign=post&utm_medium=web
Jayshree, I will back my work up tomorrow. D
Thanks Jayshree, I’ve saved your post
When I go to settings the “export option” does not show up for me. I wish I could show you a photo. 🤷♀️
Same here. No Export option.
I did your trick and turn my phone sideways and I was able to find the import export section. The same happens to me when I’m trying to add a hyperlink to my articles. If I turn it sideways I can add it. Thank you for the tip!
Try doing a find using the browser - Ctrl-F - for 'export' - it is under Settings and now referred to as Import/Export on the left hand side.
I turned my phone sideways and the two left hand column was visible. Odd the option didn’t show when scrolling through the settings column
lol, welcome to the UX of this platform! It isn't tested for responsiveness I suppose. Best to do the settings and design aspects from a desktop/laptop browser would be my recommendation.
Wait...so I am not losing my mind here? The only way to get the open rate, views, clicks, etc is to go through post by post or through separate files sendtfor each post? There is no aggregation?
I exported everything just fine but the csv titled: posts (which I thought would give me the summary) only provides:
post_id
post_date
is_published
email_sent_at
inbox_sent_at
type audience
title
subtitle
podcast_url
I am looking to find the average and trends for a newsletter over the years.