Schedule Posts in Bulk from a CSV and Export Them

What goes wrong when you schedule one by one

Companies that plan their posts at the start of each month often line up topics and dates in a spreadsheet, show it to a boss or store manager, and then enter the posts. Copying that sheet into the scheduling screen one post at a time can take almost an hour for 30 posts. The more posts there are, the easier it is to shift a date by one day while copying, or to enter the same text twice.

The other problem is a failure partway through. If it stops at post 20, it takes effort to check on screen which ones went in and which didn't. CSV bulk scheduling is a feature to reduce both of these problems together.

The shape of the CSV

The CSV you import has only 3 columns. Column 1 is the date and time to post (Japan time), column 2 is the post text, and column 3 is tags. Tags are optional, and you can add several separated by commas.

Besides "2026-11-03 12:00", a format like "2026/11/3 9:05" can also be read. If the first row is a header row, it is skipped automatically. To put a line break inside the post text, wrap the text in double quotation marks and the break is kept as a line break. The safest way is to download the "Sample CSV" on the screen, which gives you a file in exactly this shape, open it in your spreadsheet software and add your rows.

When you save from spreadsheet software, set the character encoding to UTF-8. In Excel, choose "CSV UTF-8 (Comma delimited)". Saving in another encoding can garble the text.

Fixed limits

You can import up to 350 rows at a time, and the file can be up to 2 MB. The date and time must be at least 10 minutes after the moment you import. If you enter a time too close, the post could go out before you have had a chance to check it.

All rows are checked first, and if any fails, nothing goes in

When you import, SNS TOWN checks every row before scheduling anything. It checks that the date and time can be read, that it is at least 10 minutes ahead, that the text isn't empty, and that it passes that network's pre-publish check. The checks are the same as the pre-publish check, looking at things like the character limit and the spacing between posts.

If even one row needs fixing, not a single post is added. Instead you get a table listing the row number, date and time, the start of the text and the reason it was stopped. Fix the CSV and import it again to start over. We avoid ever leaving things half-imported so that nobody has to work out how far it got.

Items that only call for caution, such as URLs in the text or the number of hashtags, which tend to be disadvantages in X's recommendations, don't stop the import and appear as cautions in the results. CSV rows are treated as posts written by a person, so decisions on style are left to the writer.

Schedule them, or hold them as drafts

The import screen has a checkbox, "Approve and schedule rows that pass the checks". It starts out ticked.

If the sheet has already been approved internally, scheduling is the faster way. For companies where the sheet is made by one person and another reads the text before it goes out, importing as drafts and waiting for approval fits better. The plan allowance is counted the same way as for posts scheduled from the screen. Details are on the pricing page.

After importing, check on the calendar and list

When the import finishes, the posts list opens. The number imported and the number scheduled appear at the top. Imported posts also line up in the week and month views of the calendar, so you can see by eye whether dates are bunched up or posts overlap at the same time. To change a time, drag the post on the calendar.

If you add tags in column 3, you can filter the list by tag. Tagging groups such as "Autumn campaign" or "New product" makes it easier to review just that group later.

Export your posts to CSV

You can also export in the other direction. From "..." on the posts screen, click "Export to CSV" and download up to 5,000 of the company or brand's posts, newest first, as a CSV. It is written in a form that doesn't garble when opened in Excel.

The columns exported are post number, network, account, post time (Japan time), status, how it was made, text, the post ID on the network, post URL, internal note and tags. You can use it to list the posts published at the end of the month for a report, or as a base for next month's plan. Because internal notes are included, the back-and-forth from approval is kept with them. How to build a monthly report is summarized in How to Build a Monthly Social Media Report.

The help guides Schedule a Post for a Set Time and Find Posts in the List are also useful for the steps.

Frequently asked questions