How to create a public URL of your images while creating a CSV?
You need to ensure the image URLs you are adding into your CSV are public URLs.
You can create a public URL for images in the following ways:
1. Pull an image URL from your website
If you are hosting a web page, you can add your images there and create your public URLs from the host.
2. Create a public URL using Dropbox
- Upload your images from your computer to your Dropbox
- As you upload your images to Dropbox, hover over your image and click on the 'Share' button.
- A pop-up window will appear where you need to click on the 'Create a link' button.
- Click on the 'Copy link' button and your link will be copied to the clipboard.
- Open a new tab and paste the copied link there. You'll see the parameter 'dl=0' at the end of the link. Now you need to make sure you add a parameter '&raw=1' after 'dl=0' to make the URL a public URL.
For e.g. This is how your link looks when pasted into a new tab:
https://www.dropbox.com/s/sn8u7kt9ughzq7k/14713006_574837712717387_4421355489031779756_o.png?dl=0
You need to make it look like this:
https://www.dropbox.com/s/sn8u7kt9ughzq7k/14713006_574837712717387_4421355489031779756_o.png?dl=0&raw=1 - Now, you can add this public URL in the second column of your CSV.
Note: If there are no parameters (like 'dl=0' or 'dl=1') at end of your image URL, then add the parameter '&raw=1'
3. Create a Public URL using Google Drive
- Upload an image from your computer to your Google Drive account.
- As you upload your image to Google Drive, hover over your image and Right-click on it. You will see a 'Share' button. Click it.
- A pop-up window will appear. At the bottom right corner click on “Advanced”.
- Now you will see your image access as Private, Press “Change” and choose “On – public on the web”, then press “Save”.
- Now you will see the “link to share” on the top of your pop-up window.
- Just copy the URL ID from the whole link. it includes all the symbols going after id, and click on "Done".
- For example, https://drive.google.com/file/d/1pZqz5HDU7x4BF7Ye3dQYUjJ7mCaMwTyf/view?usp=sharing
All the symbols in bold black are your image file id. - Now insert the copied ID in the link given below
"http://drive.google.com/uc?id=Paste Your ID HERE "
For example, http://drive.google.com/uc?id=1pZqz5HDU7x4BF7Ye3dQYUjJ7mCaMwTyf - Now, you can add this public URL in the second column of your CSV.