Bulk Upload Posts Using A CSV File

Bulk uploading via CSV allows you to import and schedule multiple posts at once, making it easy to manage large volumes of content efficiently. The Bulk Editor provides detailed per-post customization with all the features available in the Post Editor. You can import up to 500 posts at once (each assigned profile counts separately).

📌 In This Article

How To Prepare Your CSV File

  1. Use a spreadsheet tool (Google Sheets, Excel, or Numbers). To help you get started, you can download our sample CSV file.
  2. Ensure correct column structure:
    • Column A: Post Text – The main content of your post.
    • Column B: Link – The URL you want to include (optional).
    • Column C: Image(s) – Direct links to images (must be publicly accessible). To add multiple images, separate URLs with commas.
    • Column D: Scheduled Time – Format: yyyy-mm-dd hh:mm (5-minute increments only).
    • Column E: Category – Must match an existing SmarterQueue Category.
    • Column F: Evergreen – Set to TRUE to recycle posts.
    • Column G: Post Title – Required for platforms that use post titles (e.g., Pinterest).
    • Column H: First Comment – Supports Facebook, Instagram, and LinkedIn. 
  3. Formatting rules to follow:
    • Enclose post text in quotation marks when using plain text editors.
    • Links will be automatically shortened if tracking is enabled.
    • Up to 50 images can be added per post (for multi-image posts or variations).
  4. Export the file as a CSV. Be sure to choose UTF8-encoding if you have the option.

How To Upload Your CSV File

  1. Navigate to Discover, then Bulk Upload from CSV.
  2. Drag and drop your CSV file or click "Upload CSV File" to select it.
  3. If errors are detected, SmarterQueue will:
    • Highlight issues (e.g., incorrect dates, broken image links, unrecognized categories).
    • Allow you to exclude problem rows while proceeding with the valid entries.

How To Review & Edit Posts In The Bulk Editor

  • Click "Show More" to expand post details.
  • Edit post text, images, and links, and customize for each profile.
  • Add Snippets, AI-generated captions, variations, and first comments.
  • Ensure post titles apply to supported platforms (e.g., Pinterest).
  • Adjust Evergreen settings, scheduling options, and link tracking.

How To Use Bulk Actions In The Bulk Editor

Click on the "Bulk Actions" button at the top of the Bulk Editor to apply the following to all posts:

  • Post Targeting – Choose post status (Draft or Active), select Social Profiles, assign Categories, and decide on the post type for Instagram, where applicable.
  • Link Settings – Adjust UTMs, click tracking, and link redirection.
  • Scheduling – Set default Queue position (Top/Bottom) and Evergreen settings.

Common Questions

1. Can I upload video files using a CSV?

No, SmarterQueue does not support video uploads via CSV. If you need to include videos in your posts, you must manually add them after importing your CSV by editing the post in the Bulk Editor.

2. Why isn't my CSV importing successfully?

CSV files use comma-separated values, meaning each field must be separated by a comma. Some spreadsheet software (e.g., Apple Numbers) may default to other separators based on your Language & Region settings, which can cause import failures. If you're experiencing issues, open the CSV file in a text editor and check for incorrect separators.

3. Why does my spreadsheet software change my data when opening a CSV?

Spreadsheet programs like Excel often apply mathematical formatting to numbers when opening a CSV file directly, which can alter data (e.g., changing long numbers into scientific notation). To avoid this:

  • Instead of opening the file directly, import the CSV into the spreadsheet program.
  • Set the column format to text to prevent changes.
  • Alternatively, use a text editor like Notepad to create the CSV manually.

4. How do I add images to my CSV file?

Images in a CSV file must be hosted online as direct links. Upload your images to an image hosting platform that provides public, direct links. Recommended platforms:

  • PostImages – Use the Direct link after upload.
  • ImgPile – Use the Direct link after upload.

Google Drive and Dropbox are not recommended, as their links often lead to preview pages instead of direct image URLs.

5. How many posts can I import at once?

The SmarterQueue Bulk Importer can process up to 500 posts per upload. However, each assigned profile counts separately. Example:

  • 100 posts assigned to 4 profiles = 400 total posts counted.
  • Keep this in mind when preparing your CSV file.