How To Bulk Upload Images From A CSV File To My Media
In This Article
How To Get Your Images Ready For Upload
Adding images to a CSV file requires that your images are available on the internet, and that you have a public URL for them, which you can add to your CSV file.
If the images are already on a website, you can just use their existing URL.
Note: Dropbox, Google Drive, and Google Photos are not recommended for bulk image upload.
If your images are not already online, you can bulk upload images to https://postimage.org – this is a free service that gives you direct URLs to the image files.
1. Make sure to select 'Don’t Resize My Image' when uploading them.
You can choose to have the upload expire after 1, 7, 31 days, or never. If you decide to give your upload an expiration date, make sure that you finalize uploading the CSV while the links are still valid.
2. Once you’ve uploaded your images to PostImg, in the next window, use the following settings to retrieve your URLs easily:
- Direct Link (as you will need the direct URLs for the CSV file);
- 1 Column (this will display all your links in 1 column, which will allow you to easily copy the links and paste them in the CSV column reserved for images)
The links will contain the image names and the images will be displayed on the bottom. This will help you keep track of what image you will add for which post in the CSV file.
How To Add Your Images To Your CSV
When your images have been uploaded to the web, you can then copy and paste the image URLs into the third column of your CSV import file. Make sure the correct image names match up with the correct posts.
Here’s what your CSV spreadsheet should look like once you have pasted the image URLs into your third column:
You can now save the spreadsheet as a CSV file, and import it to SmarterQueue.
💡 If you are sharing a link in your CSV file’s second column, you may not need to attach an image. If the image is already present on the page that you’re sharing the link for, you can simply manage your image handling when bulk importing from your Settings.
If you just want to bulk upload images to My Media library, but not create posts for them yet, you can simply create a CSV file with just your image URLs.
Once that's done, follow the CSV import steps linked above, but choose 'Save as Draft' from the import options.
This will make all of your images available in My Media.
Note: If you permanently delete a draft post containing an image, and you haven’t created any posts using that image, the image will be deleted.