Backup Steem Posts in Airtable! #13

in steemsecrets •  last year

secret 13.png

When we invest hours writing posts for Steem, does it seem wise to take a minute to keep a copy of our work in case it is lost? Definitely! What is the easiest way to do that? Using Airtable to save each post into an entry on a spreadsheet is the fastest and most accessible way I know of to keep a copy of all my posts here!

I Love Airtable!

Thank you very much to my friend @jordanarsenault who invited me a few months ago to join online spreadsheet service Airtable which has made backing up everything I do, collaborating on posts, and syncing my work on multiple computers WAY easier than using Microsoft Excel! I already wrote a couple of posts about Airtable previously which you might enjoy if you want the long version:

  1. Best Microsoft Excel Alternative in 2017 is Airtable at
  2. My YouTube Video to Steem Post Creation Process at

This short post features just how I use Airtable to quickly back up every post I make here including this one! If you would like to join Airtable, would you please accept my invitation at because I get a $10 credit on my bill if you use my link?

Setup Spreadsheet

To backup posts, a very simple two step process makes it easy! First, format a spreadsheet in Airtable for Steem with the following columns with each row equaling a post!

  1. Name for the title of the post.
  2. Post for the text of the post.
  3. Tags for the tags on the post.
  4. Thumbnail or Images for either the first image or for all the images on a post.
  5. Link to the finished post.
  6. Date because this will allow for filtering all completed posts to make space to focus on new posts and ideas!

Here is what mine looks like grouped by date for me to easily browse! Note that I took the filter off to show all my posts. Normally I only see unpublished posts.

jerrybanfield airtable steem.jpg

Copy and Paste!

Before I make posts, I have everything copied and pasted into Airtable in case the post does not go through. While the browser correctly keeps a draft sometimes on days where DDOS attacks or missed blocks cause a lag in making a post or a failure for the post to go through, other times the browser wipes the entire post. Thankfully so far every Steem post I have written has either went through and/or been backed up prior to submission with Airtable and all I had to do was copy and paste it in and try again.

Learning Airtable

While it might seem a little painful to take the time to learn a new system instead of using Microsoft Word or Excel, what rocks about Airtable is the mobile app and availability on any device or computer! Want to write a post and have it ready for eSteem when on the road? Airtable makes it easy to copy and paste a post written on a desktop and delivered through eSteem! Have a great idea on the road but no time to write? Put the title into Airtable and then write the post at home!


Yes everything I just shared here is totally free! I used Airtable for months without needing to pay anything and finally just paid because I love it so much and want to give back along with having a longer revision history and bigger attachment size! I easily could keep using it free for years if I wanted to!

Since I started using Airtable I now have integrated what once was a very sloppy collaboration, recording keeping, and backup system into one smooth interface which I hope is useful for you to discover here!

Are Shorter Posts Better?

Do you prefer shorter posts along with the longer ones? My steemsecrets series of posts are generally shorter in response to requests to not always write a novel in every post! I hope this thirteenth Steem secret is easy to start using and helpful for avoiding any of the problems coming from not having each post backed up!

Jerry Banfield

Stay updated via email?

Shared on

PS: Would you please make a vote for jerrybanfield as a witness or set jerrybanfield as a proxy to handle all witness votes at because as a top 20 witness I am pledging 80% of my earnings (~$200 a day) towards ads for Steem on Facebook and Google! Thank you to the 1361 accounts voting for me as a witness, the 718M VESTS assigned from users trusting me to make all witness votes by setting me as proxy, and @followbtcnews for making these .gif images!

Vote Jerry Banfield Steem Witness Rank 29


Set JerryBanfield proxy

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

Got to do it. I lost this *post when I push it through and it was the DDOS attack. It was funny I didn't know why so I sent it through esteem. Better be safe than sorry.
Airtable here I come

steemit - fantastic.gif

I will start using AirTable to back up my posts.
Thanks for the heads up.

Wow, this is epic😱I Was just checking out a YouTube video about bitcoins last Saturday(7-9-2017, I have also attached the video

This triggered my interests and went on searching about bitcoins and I found thought of trying it and created an account in steemit . Today(10-9-2017) I got my account approved and started reading more about steemit and I can across a video that you made and gave a nice
explanation about steemit .I'm have also attached the time I'm watching right now where you said about commenting
and had to see it for myself! So I'm posting a comment on your recent video. Sorry, I hadn't read your post yet. I'll definitely read it once, I'm done watching the video.Thank you so much for the explanation.


Hey @jerrybanfield thanks I missed two time my post not properly posted due to congestion in network.
Thank you buddy.
Follow me @oodeyaa

@jerrybanfield, Yes backing things UP is so Important. I recently had my computer Hard Drive on my laptop go down after a little over 6 years. I did have a lot of it backed up to an external hard drive. Once again you reminded me Jerry why it is so important that we back things up. I actually have some Crypto Currencies that are in a MEW (My Ether Wallet) and if I take the time to go through my backup I am pretty sure I will find my Private Key to retrieve them or at least I hope so. Relax and Take it all One Day at a Time.........

Excelente postagem @jerrybanfield você sempre traz bons conteúdos com postagens incríveis parabéns

Backing up posts is a great idea.
I should do that.
What I would really like is an easy way to access the posts that I've already made on steemit.
Thanks for the suggestion.

Awesome idea, I make a copy in my PC but it's not so good idea for having lots of folders here just occupying space. This is an easy perfect way.
Gonna check out those videos carefully. Thanks for this.

I'm very interest with your post @jerrybanfield
Can I ask you officially to be the team re-post with using my language, Bahasa Indonesia?
I think it will be make benefit for you and of course for Indonesian Steemit Community

Its Nice Post Since No One Having Knowledge About It.

Backing up your post is very good idea. thanks buddy

Backing up your work is always a wise idea. I back mine up using Open office, that way I can always keep it.
Here's praying that the almighty block chain doesn't let us down.

@jerrybanfield This is a nice program, backing up all the data is most important. I save all my posts on my mac. I will give a try at this program.
Thank you.

Congratulations @jerrybanfield, this post is the second most rewarded post (based on pending payouts) in the last 12 hours written by a Superhero or Legend account holder (accounts hold greater than 100 Mega Vests). The total number of posts by Superhero and Legend account holders during this period was 28 and the total pending payments to posts in these categories was $1376.80. To see the full list of highest paid posts across all accounts categories, click here.

If you do not wish to receive these messages in future, please reply stop to this comment.

Very nice! With the slowdown of the site that happened recently, and because of my increasing posts, I was looking a good way to back up my posts!

Airtable looks clear to use. I am going to try this later!

Thanks @jerrybanfield

I learned about backing up files the hard way. It is a real bummer to lose your work. Thanks for this info re: Airtable.

What a relief and very informative,I have been doing this on Microsoft word. thanks for sharing. But is there any way steemit can improve on this, that is having ways to save our work here?

Very interesting and valuable post sir,,, Please let me i need to learn more. Can i save this blog?

Awesome information on backing up content. I will definitely incorporate into my blog strategy. However, do google penalize us for having both posts on Steemit as well as our own personal blog website?

I've voted you as one of the witnesses. But it's sad you don't have enough time to check every chat and replies :(

I will definetly give Airtable a try. Thanks man.

Thank you sir for guiding us
You are doing great job. @jerrybanfield

I learnt about Airtable through one of your Youtube videos about Steemit, I guess one the very firsts on Steemit. I have not tried but after reading this post, I will definitely give Airtable a shot. Anyways, thanks for the informative post. Best wishes.

You remind me a bit of Aaron Paul from Breaking bad.
Nice YouTube videos. Very passionate.

Thanks @jerrybanfield. Good idea!

i wonder about that, isnt all my stuff secure on the blockchain?


It is but this is also about when your upload fails so u have a backup.

Very informative @jerrybanfield. Looking forward for more.
I made you steemit newspaper hehehehe

This is always good to have a backup when you use any webform as submission can fail, your connection might freeze, or your page could get refreshed and this is where you can lose your work. This can happen in WordPress and other content software as well, so the tip is not only good for Steemit.

Heya i have replied u but i didnt got any msg from you anyways
God bless u tc

Thank you for the advice! I use Grammarly for keeping my English correct. Before using it I did so many errors !

Thanks jerry for updating us, for some time now i have been looking for a way to do this. i will leverage from this.
steemit Well done GIF.gif

This is a great tip. I used google docs but airtable has more function.

Thank you very much for your publication is interesting to know and learn more every day. This is a contribution to our knowledge. I hope you continue publishing more articles of interest to all of us

Very Useful Information Sir... Hope we will get the same in your upcoming posts.

Thanks jerry.

Thanks information

Thanks @jerrybanfield would check it out

never knew of this though...will do just that in a jiffy..but l want to thank you for the impressive work here on steemit...its helpful...

Good bro

Wow !
Great @jerrybanfield .
I will try it . Thanks for sharing 👍👍👍 !

Sorry off tropic..
How you can upload video on Dtube??
I try many times but cannot, its show ipfs error..
Please help me

Do you why STEEM prices are going back under a dollar?

This post has been ranked within the top 10 most undervalued posts in the first half of Oct 09. We estimate that this post is undervalued by $77.45 as compared to a scenario in which every voter had an equal say.

See the full rankings and details in The Daily Tribune: Oct 09 - Part I. You can also read about some of our methodology, data analysis and technical details in our initial post.

If you are the author and would prefer not to receive these comments, simply reply "Stop" to this comment.

Hi most respected sir. i need your little help. I want to learn earning method on steemit from you. I belong to a poor family. I shall be thankful to you for this kindness.
This is my email address @Jerrybanfield

Nice Posts Jerry

Hey Jerry,
I wanted to thank you for opening me up to Steem...I just started and i'm ready to get my witness on :)

Nice! I really like this...very practical and happy to read more into your process. Thank you :)

Congratulations @jerrybanfield!
Your post was mentioned in the hit parade in the following category:

  • Upvotes - Ranked 2 with 740 upvotes

Your ideas are true, for such posting you are very deep in heart, thank you. I hope to give these types of advice to us so that I can learn a lot, and I will regularly visit you and vote for you and I hope you and me will vote VP, Thank you Sir,

You are doing amazing job, I remember about a 2 weeks ago I saw your video after google search.
I am happy to join steemit love watching your videos thanks for all these great news.

Thanks for being honest and very informative.

voted you as a witness