Profile image
By Joan Reeves aka SlingWords
Contributor profile | More stories
Story Views

Last Hour:
Last 24 Hours:

Uploading a Spreadsheet to Twittimer

Friday, November 11, 2016 0:11
% of readers think this story is Fact. Add your two cents.

Last month, I told you how easy it was to maintain an online social media presence using Twittimer, a website that enables you to schedule social media posts or tweets in advance.

If you missed that post, you can read it here: Save Time On Social Media With Twittimer.

(Note: This post was originally published on Writing Hacks, my free newsletter for working writers. If you’d like articles like this as soon as they are published, subscribe to Writing Hacks: Tips about the Art, Craft, and Business of Writing to make life easier for writers.)

Twittimer is very easy to use. You can schedule a few tweets in advance or upload a CSV file with hundreds of tweets. That’s what today’s post is about: How to Upload a Spreadsheet to Twittimer.

I’ll also tell you how to get an image added to those tweets you upload. So let’s get started.

1. Register for a Twittimer account. They offer a free account, but to utilize the website to the max, sign up for a paid account at the lowest level. For 6 months, it costs a little more than $20.00.

2. Set up your Social Media Accounts. List your FB, Twitter, and Linked In accounts and grant permission for Twittimer to use them. If you have 2 Twitter accounts, one will be listed as TW1 and the other TW2. The same for FB. One will be FB1, etc.

3. Open Microsoft Excel because you’ll be creating a .CSV file. (I believe you can also use the Open Office version as well as the Corel version.)

4.  Don’t post the same message within 24 hours of another identical one. Also don’t post the same message day after day. There must be some variation in the text or Twitter considers them spam, and may ban your account. Twittimer will do the same.


5. Here’s the format for a .CSV file that can be successfully uploaded to Twittimer.

The .CSV will have 4 columns.

Column 1: List the Social Media Account you want the text to post to. Use the code assigned to your accounts, i.e., TW1, TW2, FB1, etc.

Column 2: This is where you type your message. IMPORTANT: Do not use any special characters or punctuation other than comma, period, or question mark. If you use other characters, the post will publish with a little black triangle and question mark where the character should be. If you don’t mind going back and editing each post once it’s uploaded to Twittimer, you can ignore this caution and plan on fixing each instance, but I think it’s easier just to do it right the first time.

Column 3: This is the date you want your message to post written in this formula — MM/DD/YYYY.

Column 4: This is the time you want your post to publish in 24 Hour format, so 6:00pm would be 18:00. Thirty minutes after midnight, or 12:30am, would be 00:30, and 30 minutes after noon, or 12:30pm, would be 12:30pm.

Here’s a picture of a sample .CSV file taken from Twittimer’s Help page.

6. Remember, you can NOT upload Images using a .CSV bulk uploader.

7. Once you have your file completed, proofread it. If you think it’s ready to go, save it as a .CSV (not Excel) with a file name you’ll readily recognize.

8. Sign in to Twittimer. One the left Menu, scroll down to CSV Upload. Browse for the file and click to upload it.

9. It only takes a minute or so to upload the spreadsheet. If there are any errors on the spreadsheet, you’ll get a notice.

Editing a Tweet After Uploading

Once the .CSV file is uploaded, you can edit any way you want. You can edit to add an image to post with the message. Here’s how:

1. Click the gear icon in upper right of each message. That opens the Edit selections.

2. Click Edit / click Add Image / browse for your image. Select and open it to upload as you would any image file. Once it’s uploaded, click the orange EDIT button in lower right of the box to save the edited message.
Another Twittimer Benefit

Once you have a month’s file set up, you can just go in and change the dates and times to publish all of them again the next month.

Takeaway Truth

That’s it! I hope you’ll start using Twittimer. It’s really a great tool for busy authors.

If you’re a writer, you might want to subscribe to WritingHacks, my free newsletter with tips to make your writing life easier.

Joan Reeves aka SlingWords: The Word Slinging Adventures of Joan Reeves


We encourage you to Share our Reports, Analyses, Breaking News and Videos. Simply Click your Favorite Social Media Button and Share.

Report abuse


Your Comments
Question   Razz  Sad   Evil  Exclaim  Smile  Redface  Biggrin  Surprised  Eek   Confused   Cool  LOL   Mad   Twisted  Rolleyes   Wink  Idea  Arrow  Neutral  Cry   Mr. Green

Top Stories
Recent Stories



Top Global


Top Alternative




Email this story
Email this story

If you really want to ban this commenter, please write down the reason:

If you really want to disable all recommended stories, click on OK button. After that, you will be redirect to your options page.