How to bulk upload scheduled social posts from a spreadsheet
Turn a spreadsheet into scheduled social posts in bulk: how to build a CSV, format dates, and upload 100+ posts to Buffer, Hootsuite, and other schedulers.
Bulk upload is the fastest way to fill a content queue: you write a batch of posts as rows in a spreadsheet, export it as a CSV, and the scheduler drops every row into your calendar at the date and time you set. One upload can seed weeks of posts across a channel without touching the composer once per post. It is the standard workflow for anyone who plans in a sheet — agencies loading a client month, e-commerce teams staging a launch, solo creators batching a quarter of evergreen posts.
The catch is that a CSV is unforgiving. Get the date format, the encoding, or the column order wrong and the tool either rejects the file or — worse — schedules 100 posts at the wrong times. This guide covers the mechanics that actually matter: which schedulers support CSV bulk upload and their real limits, how to build the file so it imports cleanly the first time, and the checks that stop a bad batch from publishing.
Every tool has its own template and rules, so treat the numbers below as current-as-of-2026 specifics that you should confirm against the tool's own help page before a large import.
The steps
Confirm bulk upload is the right tool for the job. Bulk CSV upload shines for text and single-image posts you have already written. It is a poor fit for video, Reels, and carousels — most schedulers cannot bulk-upload those at all (Buffer, for example, blocks video and multi-image posts from CSV). If your batch is video-heavy, you will schedule those individually in the composer regardless of the sheet.
Pick a scheduler that supports CSV bulk upload. Not every tool has this feature. Buffer, Hootsuite (Bulk Composer), Sprout Social, SocialPilot, Publer, SocialBee, and Metricool all support CSV or spreadsheet imports on paid plans. Meta Business Suite's native Planner is built around scheduling posts one at a time and lacks the large-batch CSV import that dedicated schedulers offer, so a big spreadsheet-driven batch belongs in a third-party tool. Choose based on the platforms you publish to and how many posts you need per upload.
Download the tool's official CSV template. Always start from the tool's own template rather than a blank sheet — the column headers and order are load-bearing. In Buffer, open the channel settings gear → General → Bulk Upload → Download CSV Template. In Hootsuite, the Bulk Composer screen links its template. Building your own file with guessed headers is the most common cause of a rejected import.
Write your posts as rows in a spreadsheet. Fill one post per row: the caption/message in the message column, the scheduled date and time in their columns, and a public image URL if the template supports it. Keep each caption within the destination platform's character limit (e.g. X at 280) — a bulk tool often will not flag an over-length caption until it fails at publish time. Draft in Google Sheets or Excel, one row at a time.
Format dates and times to the tool's exact spec. This is where most imports break. Buffer requires YYYY-MM-DD HH:mm in 24-hour time (April 6, 2026 at 9am = 2026-04-06 09:00), zero-padded. Hootsuite's Bulk Composer wants the date as MM/DD/YYYY and the time in 24-hour format, with each time at least 20 minutes in the future, ending in a 5 or 0, and only one post per time slot. Read your tool's rule and match it character for character; a stray 25:00 or a US-vs-EU date order silently misschedules everything.
Save the file as UTF-8 CSV. Encoding is the second-biggest failure point. If your captions contain emoji or accented characters, save as CSV UTF-8. Google Sheets exports UTF-8 by default (File → Download → CSV). Excel does not — choose "CSV UTF-8 (Comma delimited)" explicitly, or your emoji import as garbled boxes. Wrap any caption containing commas or line breaks in quotes so a comma inside the text is not read as a new column.
Upload the CSV and review the preview grid. Upload the file, then stop and read the preview before confirming. Every tool shows a grid of the parsed posts with their scheduled times — this is your last chance to catch a shifted date column, a truncated caption, or a broken line break. After the CSV parses, most tools let you attach or swap media and adjust individual times inside the queue.
Verify the queue and spot-check the first publishes. Once scheduled, open the calendar/planner view and confirm the posts landed on the right days at the right times. For the first day of any new bulk workflow, check the actual platforms after the scheduled times to catch silent API failures (token expiry, media rejected, over-length caption). Verify a few, not just the queue.
Common gotchas
Video, Reels, and carousels usually cannot be bulk-uploaded via CSV — Buffer blocks them outright, and most tools limit CSV posts to text plus a single image. Plan to schedule video separately.
Per-upload caps are real: Buffer allows up to 100 posts per channel per upload on paid plans (10 on free); Hootsuite Bulk Composer allows up to 350. Split larger batches across multiple files.
Excel mangles emoji and accented characters unless you save as "CSV UTF-8 (Comma delimited)". Google Sheets avoids this by exporting UTF-8 by default.
Date-order mistakes (MM/DD/YYYY vs YYYY-MM-DD vs DD/MM/YYYY) are silent — the file imports, but every post schedules to the wrong day. Match the tool's exact format.
Hootsuite requires future times ending in a 5 or 0 with one post per slot; two rows sharing a timestamp will error or collide.
A caption with an unquoted comma splits into extra columns and shifts every following field. Quote any cell that contains commas, quotes, or line breaks.
Image URLs in a CSV must be public and directly accessible — a private Drive link or an expired signed URL fails silently at publish.
Where Kompozy fits
Bulk CSV upload is a distribution shortcut, and it exposes the real bottleneck the moment you use it: the spreadsheet has to be full first. Buffer and Hootsuite will happily queue 100 to 350 rows in seconds — but only if you have already written 100 to 350 posts, formatted the dates by hand, and saved the file as UTF-8. The scheduler solves the last mile; the content is still on you.
[Kompozy](/) removes the spreadsheet instead of formatting it better. It is a generation and publishing engine, so the queue is produced, not typed: drop in a source (a video, a blog post, a webinar, a topic), and the engine drafts the batch across 18 formats — [Text Posts and image posts](/glossary/output-buckets) for the CSV-friendly slots, plus the video, [Carousel Posts](/glossary/hyperframes), and persona/avatar formats that no CSV bulk upload will accept. Then it schedules them itself. [Autopilot](/glossary/autopilot) fans the approved set across the eight social platforms plus blog and email on a native cadence, and a per-post review queue is the approval gate — the same "read the preview grid before you confirm" discipline this guide insists on, except you are approving generated drafts rather than proofreading rows you formatted by hand.
The honest boundary: if you already have finished, on-brand copy sitting in a sheet, a bulk-upload scheduler is the cheaper, correct tool — pay for Buffer's queue and move on. Kompozy earns its place when writing and formatting the rows is the work, or when your batch includes the video and carousel content CSV upload can't touch. Creator ($49/mo for 2,500 credits) covers a solo creator who wants the queue generated instead of typed; Pro ($299/mo for 18,000 credits) fits an agency staging many brands' calendars at once; Enterprise is custom.
Frequently asked questions
How many posts can I bulk upload at once?
It depends on the tool. Buffer allows up to 100 posts per channel per upload on paid plans (10 on free); Hootsuite's Bulk Composer allows up to 350 posts. For bigger batches, split the work into multiple CSV files.
What date and time format does the CSV need?
Each tool differs and is strict about it. Buffer wants YYYY-MM-DD HH:mm in 24-hour time; Hootsuite wants MM/DD/YYYY plus a 24-hour time. Always copy the format from the tool's own template and zero-pad every value.
Can I bulk upload video or carousel posts?
Generally no. Most schedulers, including Buffer, exclude video, Reels, and multi-image carousels from CSV bulk upload — you can attach only a single image per row, if that. Video and carousels are scheduled individually in the composer.
Why did my emoji import as garbled characters?
Your CSV was not saved as UTF-8. Excel's default CSV export corrupts emoji and accented characters — re-save as "CSV UTF-8 (Comma delimited)", or build the file in Google Sheets, which exports UTF-8 by default.
Does Meta Business Suite support CSV bulk upload?
Not in the way dedicated schedulers do. Meta Business Suite's Planner is built around scheduling posts one at a time, without the large-batch CSV import that tools like Buffer and Hootsuite offer. For a spreadsheet-driven batch to Instagram and Facebook, use a third-party scheduler that connects via Meta's official API.
Do I still have to write all the posts myself?
Yes — bulk upload only handles distribution. The scheduler takes finished copy from your spreadsheet and queues it; writing the 100 rows is still on you. That is the real bottleneck bulk upload does not solve.