How to bulk upload via CSV
CSV files can have up to 3 columns (without headers). The first column is required, the second and third columns are optional:
REQUIRED The First column contains the message of your post and any link(s).
OPTIONAL The Second column contains the URL of the image you want in your post. If you want to create a post without an image, you can leave this column empty.
Note that this is where you put your image URL. If you want a link in your post, that goes in the First column.
OPTIONAL The Third column lets you set the date and time of each post.
The format should be: MM/DD/YYYY HH:mm
For Example: 12/25/2022 13:05
Note: If the third column is left blank, you can select the date and time of each post after the posts have been uploaded.
How many posts can I upload in a CSV?
You can upload up to 100 different posts in a CSV.
Can I use Google Drive links for my image URLs?
Yes! But it MUST be a publicly accessible URL.
Can I have multiple image URLs in a single post?
No, unfortunately multi-image posts are not supported via bulk upload. They are only supported via the Create A Post page.
Can I upload videos in a CSV?
Video uploads are not supported via CSV upload at this time. However, you CAN bulk upload videos via a CSV using OneUp's Zapier integration (as long as they are Google Drive video URLs), or you can bulk upload videos directly from your computer, Google Drive, or Dropbox
Can I upload GIFs via CSV?
Yes, you can. Correct GIF URLs should end with ".gif", and NOT ".gifv"
GIF URLs that end in ".gifv" will fail to publish.
Where do I select the accounts I am publishing these posts to?
You can select which accounts you want to post to on the scheduling screen (after uploading the CSV). You cannot select which accounts to post to inside the CSV.
Where do I select the repeating interval of bulk uploaded posts?
You can select the repeating interval on the scheduling screen (after uploading the CSV). You cannot select the repeating interval inside the CSV.
TIP: For Google My Business CTA buttons, those can also be added on the scheduling screen after the CSV is uploaded: Can I add CTA buttons for Google My Business posts that are bulk uploaded?
Click here to view a sample Google Sheet with the proper formatting.
Before uploading to OneUp, make sure to export the file as a CSV.
In Google Sheets, you can do so under File => Download => comma-seperated values (.csv)
You can put all links/URLs in the message of your post (First column), and OneUp will automatically extract it.
The image URL in the Second column must be a publicly accessible URL.
I you use Imgur (free) to upload images via CSV, once you upload an image to Imgur, remember to use the image URL instead of the page URL in your CSV.
For example:
The image URL is https://i.imgur.com/r2BPSdo.jpg which you should use, and NOT https://imgur.com/gallery/vMdP4Qh (the page URL)
Correct image URLs should end with either .jpg or .png. To get the correct image URL in Imgur, right-click on an image and click "Open image in new tab".
REQUIRED The First column contains the message of your post and any link(s).
OPTIONAL The Second column contains the URL of the image you want in your post. If you want to create a post without an image, you can leave this column empty.
Note that this is where you put your image URL. If you want a link in your post, that goes in the First column.
OPTIONAL The Third column lets you set the date and time of each post.
The format should be: MM/DD/YYYY HH:mm
For Example: 12/25/2022 13:05
Note: If the third column is left blank, you can select the date and time of each post after the posts have been uploaded.
How many posts can I upload in a CSV?
You can upload up to 100 different posts in a CSV.
Can I use Google Drive links for my image URLs?
Yes! But it MUST be a publicly accessible URL.
Can I have multiple image URLs in a single post?
No, unfortunately multi-image posts are not supported via bulk upload. They are only supported via the Create A Post page.
Can I upload videos in a CSV?
Video uploads are not supported via CSV upload at this time. However, you CAN bulk upload videos via a CSV using OneUp's Zapier integration (as long as they are Google Drive video URLs), or you can bulk upload videos directly from your computer, Google Drive, or Dropbox
Can I upload GIFs via CSV?
Yes, you can. Correct GIF URLs should end with ".gif", and NOT ".gifv"
GIF URLs that end in ".gifv" will fail to publish.
Where do I select the accounts I am publishing these posts to?
You can select which accounts you want to post to on the scheduling screen (after uploading the CSV). You cannot select which accounts to post to inside the CSV.
Where do I select the repeating interval of bulk uploaded posts?
You can select the repeating interval on the scheduling screen (after uploading the CSV). You cannot select the repeating interval inside the CSV.
TIP: For Google My Business CTA buttons, those can also be added on the scheduling screen after the CSV is uploaded: Can I add CTA buttons for Google My Business posts that are bulk uploaded?
Click here to view a sample Google Sheet with the proper formatting.
TIPS
Before uploading to OneUp, make sure to export the file as a CSV.
In Google Sheets, you can do so under File => Download => comma-seperated values (.csv)
You can put all links/URLs in the message of your post (First column), and OneUp will automatically extract it.
The image URL in the Second column must be a publicly accessible URL.
I you use Imgur (free) to upload images via CSV, once you upload an image to Imgur, remember to use the image URL instead of the page URL in your CSV.
For example:
The image URL is https://i.imgur.com/r2BPSdo.jpg which you should use, and NOT https://imgur.com/gallery/vMdP4Qh (the page URL)
Correct image URLs should end with either .jpg or .png. To get the correct image URL in Imgur, right-click on an image and click "Open image in new tab".
To see it in action, watch this video:
Updated on: 11/22/2024
Thank you!