How to Import Images With Spreadsheet Then Upload

Majority importing is a characteristic of the Business and Agency Plans, besides as Custom Plans with the Intermediate Importer improver.

Bulk importing is a great way to add a large number of Posts to your Queue at once. With SmarterQueue, you can bulk import up to 200 Posts at a time, in just a few seconds. 💪

---

In This Article

• Video Walkthrough
• Getting Your Spreadsheet Ready For Import
• How To Locate & Initiate A Bulk Import
• Managing Your Bulk Import Options
• Common Questions

---

Video Walkthrough

---

Getting Your Spreadsheet Ready For Import

Creating and formatting your spreadsheet properly is an of import first footstep to importing your posts.

To view a sample CSV file, click here.

1. Use software similar Excel, Numbers, or Google Sheets, to create your spreadsheet
2. You may go on the header row; otherwise, the start row should contain your first postal service
3. Whether or not you go along the header row, your content must follow this order for each column:
   1. Column A= Post Text
   2. Cavalcade B= Link
      1. Links will be shortened if you have link-tracking turned on in your Settings
   3. Column C= Image
      1. If you want to majority upload images with your CSV, you'll need to upload your images to the spider web first
      2. Nosotros recommend the following three platforms that can exist used to upload images. Images must be in .jpg, .jpeg, .png, or .gif formats.
         
         
         
         • https://postimages.org/ - make sure to choose "Straight link" later on upload
           
         • https://imgshare.io/ - make certain to choose "Direct link" later upload
           
         • https://imgpile.com/ - make sure to cull "Direct link" subsequently upload
      3. Google Bulldoze and Dropbox are not recommended to host image URLs equally files are not commonly visible to the public.
   4. Column D= Scheduled Time
      1. The time must be written yyyy-mm-dd hh:mm:ss with this verbal punctuation. If you lot change a - too a / for instance, the time will not register correctly in your import.
   5.  Column East= Category
   6. Cavalcade F= Evergreen
      1. All Posts are imported using your default Evergreen setting unless you write "Once" in Column F
4. Write all of your posts accordingly filling out each section of the CSV file where necessary
   1. Annotation:All columns are optional, just you must accept something in at least one of the outset iii columns (Post Text, a link, or an image)
5. Once yous're finished writing and formatting your posts, export the file as a CSV
   1. When saving the CSV file, be sure to choose UTF8-encoding if you have the option
6. You can only import 200 rows at a fourth dimension. If you need to import more items, create separate CSV files using a tool like http://filesplit.org/
7. Yous will be able to review and edit imported Posts before they are added to your Queue, including specifying which Social Profiles to post to 💪

Note: Go on in listen that CSV stands for Comma Split up values, pregnant that the information in every line of your CSV needs to exist separated past commas. When saving every bit CSV, some software (ex: Numbers) could default to other separators that won't work, based on your Language & Region settings. If you lot're CSV isn't successfully importing, open the file and cheque if other separators are being used.

---

How To Locate & Initiate A Majority Import

• Select 'Find Content' from the top carte du jour of your SmarterQueue dashboard

• Then select 'Majority upload from spreadsheet'

• Drag and drop your CSV file onto the screen or click the blueish 'Upload CSV File' button to initiate the import

• Y'all'll and then meet all of your posts inside of the Bulk Importer
• Using the Bulk Editor, you lot can and so conform whatsoever of your import settings including choosing a Category for your posts, selecting the relevant Social Profiles, adjusting epitome and Evergreen settings

Managing Your Majority Import Options

To access your import options, click the blue ' Import Options' button at the bottom of the page.

From here, you tin can choose whether to add imported Posts to the top or bottom of your Queue or save them equally drafts.

Looking at the options in the screenshot below, you tin can also choose whether to utilise the 'initial' or 'expanded' link, turn click tracking on or off, and plow UTM tracking on or off.

---

Common Questions

What happens if I attempt to majority import a Post that is too long for Twitter or LinkedIn?

When majority importing, you will always have the chance to edit the Mail service Text earlier adding it to your Queue.

If you are importing to a Twitter account, we will check the post length (including any links and images), and warn you if the Post exceeds Twitter's 280-grapheme limit or LinkedIn's 1300 character limit.

You can then edit the text so that it doesn't exceed the character limit.

Images - when calculation posts from CSV import, are the images hosted on SmarterQueue's servers?

When you import Posts to SmarterQueue via a CSV file, you can add a link to an image for each Post.

The images that you specify for each Post are imported and hosted on our servers, then you don't have to worry nearly keeping the images online after the import.

How should I format my CSV import?

If you are curious virtually how to format your CSV, and so you download the CSV Import Template we accept fabricated available in the SmarterQueue dashboard.

Information technology will guide you lot through what each column should be used for.

carranou1971.blogspot.com

Source: https://help.smarterqueue.com/article/162-how-do-i-bulk-import-posts-from-csv-excel-spreadsheet

Share this post