Creating a CSV file for bulk import using Excel
This document describes the procedure for creating CSV files for bulk import using Excel or similar spreadsheet applications.
Creating a CSV file for text-only posts
- In Excel or similar spreadsheet applications, open the downloaded sample file or create a new file by selecting [File] > [New].
- In column A, enter the desired post date and time in "YYYY/MM/DD HH:MM" format. The post date and time can be specified 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 [File type], select [CSV UTF-8 (Comma delimited)]. For details on how to save, refer to How to save in UTF-8 or Shift_JIS.
- Enter a file name and save.
Creating a CSV file for bulk importing posts with media
With a single CSV file, you can collectively add posts with media and text-only posts as 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 Excel or similar spreadsheet applications, open the downloaded sample file or create a new file by selecting [File] > [New].
- 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 [File type], select [CSV UTF-8 (Comma delimited)]. For details on how to save, refer to How to save in UTF-8 or Shift_JIS.
- Enter a file name and save.
Details of Input Fields
| Item Name | Example Input | Required/Optional | Notes |
| Post Date and Time | 2025/08/21 10:00 | Required | Enter the date and time in "YYYY/MM/DD HH:MM" format. The post date and time can be specified 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 file extension (.jpg/.png). |
| Media 2 | 20250821_02.jpg | Optional | Up to 20 media items can be specified per post (up to 4 for X (formerly Twitter), up to 10 for Instagram/Facebook). Add media header rows as needed. |
| Media 3 | Optional | If left blank, it will be a text-only post. | |
| 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 information on how to obtain media filenames, please refer to Uploading media (images and videos) to the Media Library.
How to Set CSV File Dates to SocialDog Compatible Format
To ensure that the date format included in the CSV file is compatible with SocialDog, perform the following operations:
- Select the cell where you want to change the date settings, and click Cell Formatting.
- Enter "yyyy/mm/dd hh:mm" in the format field and click OK.
How to Save in UTF-8 or Shift_JIS
- Select [File] > [Export] > [Change File Type] > [CSV (Comma delimited)], then click [Save As].
- If the file contains emojis, change [File type] to [CSV UTF-8 (Comma delimited) (*.csv)].
- Enter a desired file name and click [Save].
If emojis are included, select UTF-8.
About Line Breaks within Cells
When editing directly with a text editor, line breaks must be enclosed in double quotes (""). When editing with Excel, line breaks within cells are automatically converted during CSV export, so there is no need to enclose them in double quotes.
About Functions such as the LEN Function
Functions are converted to text when exported to a CSV file.
The content of registered posts will be displayed on the confirmation screen after upload, so please make sure to verify it before registering.