Create CSV files for bulk import in Excel
This document describes the procedure for creating a CSV file for bulk import using spreadsheet applications like Excel.
Creating a CSV File for Text-Only Posts
- In a spreadsheet application like Excel, open the downloaded sample file, or select [File] > [New] to create a new file.
- In column A, enter the desired posting date and time in "YYYY/MM/DD HH:MM" format. Posting dates can be set up to 1 year and 6 months in advance.
- In column B, enter the post content. Line breaks within cells will also be reflected in the post.
- Repeat steps 2 and 3 for the number of posts you wish to schedule.
- Select [File] > [Save As] to export the CSV file.
- From [Save as type], select [CSV UTF-8 (Comma delimited)]. For details on how to save, refer to How to Save as UTF-8 or Shift_JIS.
- Enter the file name and save.
Creating a CSV File for Bulk Importing Posts with Media
With a single CSV file, you can bulk add posts with media and text-only posts to scheduled posts or drafts.
To bulk import posts with media, you must first upload images and videos to the Media Library. For upload instructions, refer to Uploading Media (Images and Videos) to the Media Library.
- In a spreadsheet application like Excel, open the downloaded sample file, or select [File] > [New] to create a new file.
- Create the CSV file according to the format described in Details of Input Fields below.
- Select [File] > [Save As] to export the CSV file.
- From [Save as type], select [CSV UTF-8 (Comma delimited)]. For details on how to save, refer to How to Save as UTF-8 or Shift_JIS.
- Enter the file name and save.
Details of Input Fields
| Field Name | Example Input | Required/Optional | Notes |
| Posting Date/Time | 2025/08/21 10:00 | Required | Enter the date and time in "YYYY/MM/DD HH:MM" format. Posting dates can be set up to 1 year and 6 months in advance. |
| Post Content | This is a sample post | Required | Line breaks within cells will also be reflected in the post. |
| Media 1 | 20250821_01.jpg | Optional | Enter the filename of the media uploaded to SocialDog's Media Library. The filename must include the extension (.jpg/.png). |
| Media 2 | 20250821_02.jpg | Optional | Up to 10 media items can be specified per post (X (formerly Twitter) allows up to 4 images). Enter as many media header rows as needed. |
| Media 3 | Optional | If left blank, the post will be text-only. | |
| Media 4 | 20250821_04.jpg | Optional | |
| Media 5 | 20250821_05.jpg | Optional | |
| Media 6 | 20250821_06.jpg | Optional | |
| Media 7 | 20250821_07.jpg | Optional | |
| Media 8 | 20250821_08.jpg | Optional | |
| Media 9 | 20250821_09.jpg | Optional | |
| Media 10 | 20250821_10.jpg | Optional |
For how to obtain media filenames, please refer to Uploading Media (Images and Videos) to the Media Library.
How to Set the Date Format in CSV Files to SocialDog Compatible Format
Perform the following operations to set the date format in your CSV file to a format compatible with SocialDog.
- Select the cells for which you want to change the date settings, and click Format Cells.
- In the Format field, enter "yyyy/mm/dd hh:mm" and click OK.
How to Save as UTF-8 or Shift_JIS
- Select [File] > [Export] > [Change File Type] > [CSV (Comma delimited)], then click [Save As].
- If the file contains emojis, change [Save as type] to [CSV UTF-8 (Comma delimited) (*.csv)].
- Enter the desired file name and click [Save].
If the file contains emojis, select UTF-8.
About Line Breaks within Cells
When editing directly in a text editor, line breaks must be enclosed in double quotes (""). When editing in Excel, line breaks within cells are automatically converted upon CSV export, so there is no need to enclose them in double quotes.
About Functions like LEN
Functions are converted to text when exported to a CSV file. The registered post content will be displayed on the confirmation screen after upload, so please be sure to review it before registering.