Preparing Your CSV Spreadsheet

The BookBooster bulk upload tool lets you prepare social posts in a spreadsheet and upload them together. This is ideal when you want to schedule a full launch campaign, a month of evergreen content, or a batch of posts created from images.

Use the official template

Always start with the BookBooster CSV template provided on the Bulk Upload page. The template contains the correct column headers and formatting structure for SocialBoost.

Important CSV rules

• Do not rename the column headers.
• Do not delete required columns.
• Use one row per post.
• Keep dates and times in the format shown in the template.
• Check that image filenames or image links match the files you plan to use.
• Remove blank test rows before uploading.
• Save or export the finished file as CSV.

What each row represents

Each row in the CSV should represent one social post. The row may include the post message, platform/profile information, date and time, queue instructions, image information, hashtags and other supported options.

Required vs optional information

• Required fields are needed for SocialBoost to create the post correctly.
• Optional fields add extra information such as hashtags, image references, queue details or platform-specific customizations.

Queue posts vs scheduled posts

• Queue posts are added to the queue and automatically sent at the next available queue slot.
• Scheduled posts are assigned to a specific date and time.

Bulk Importing Posts

Bulk importing posts lets you upload multiple pieces of social content at once instead of creating each post manually. This is useful for authors who like to batch their marketing work.

Before importing

• Download and complete the official CSV template.
• Check every row has the required information.
• Proofread captions and hashtags.
• Check links, dates and times.
• Confirm whether posts should be queued, drafted or scheduled.
• Make sure referenced images are available and correctly named.

How bulk importing usually works

1. Open the Bulk Upload area in SocialBoost.
2. Download the template if you have not already done so.
3. Complete the spreadsheet.
4. Save the file as CSV.
5. Upload the CSV file.
6. Review any validation messages.
7. Confirm the import.
8. Check the imported posts in the queue, drafts or calendar.

After importing

• Review the first few imported posts manually.
• Check image previews.
• Confirm profile selections.
• Check dates, times and timezone.
• Look for missing captions, hashtags or links.
• Fix any failed or skipped rows.

Things to know

• Bulk upload can save time, but it can also multiply mistakes if the CSV is wrong.
• Always test with a small file if you are using the upload process for the first time.
• Do not upload hundreds of posts until you understand how the import behaves.
• Review imported posts before assuming they are ready to publish.

Bulk Importing Images

Many bulk upload posts include images. These may be book covers, quote graphics, carousel slides, launch graphics, reader magnet images or other promotional visuals.

Before importing images

• Use clear filenames.
• Make sure filenames in your CSV match the uploaded files exactly.
• Check file type and size requirements.
• Use the correct aspect ratio for the platform.
• Confirm the images are final approved versions.
• Avoid duplicate filenames that could cause confusion.

Image options may include

• Uploading images directly.
• Using image URLs where supported.
• Selecting images already stored in the Asset Library.
• Matching CSV rows to image filenames.

Good image filename examples

• BookTitle_NewRelease_Square.jpg
• BookTitle_Quote01_Instagram.jpg
• SeriesName_TropePost_1080x1920.png
• ReaderMagnet_Promo01.jpg

Things to know

• Image filenames are often case-sensitive.
• Spaces and special characters can sometimes cause problems.
• Large images may take longer to upload or process.
• Images may crop differently across platforms.
• Always check previews after import.

Creating One Post Per Image

The one-post-per-image workflow is useful when you have a batch of graphics and want each image to become its own social post. This is common for quote graphics, trope slides, review graphics and launch countdown images.

When to use one post per image

• You have a batch of quote graphics.
• You created several launch graphics in Canva.
• You want each book cover to become a separate post.
• You have character graphics for a series.
• You want to fill your queue with evergreen image posts.

Typical workflow

1. Create or export your images.
2. Name the files clearly.
3. Prepare captions in the CSV template.
4. Match each row to one image.
5. Upload the images or make sure they are available in the Asset Library.
6. Upload the CSV.
7. Review the imported posts.
8. Add them to the queue or schedule them.

Example author workflow

1. Author, A. Pen creates 30 quote graphics in Canva.
2. Each image is exported and named clearly.
3. Author, A. Pen downloads the BookBooster CSV template.
4. Each CSV row contains one caption and one matching image filename.
5. The CSV is uploaded to SocialBoost.
6. Imported posts are reviewed in the queue or calendar.
7. SocialBoost publishes queued posts automatically at the next queue slots.

Things to know

• Check image order before importing if the sequence matters.
• Use unique captions where possible.
• Avoid repeating the same sales message on every image.
• Queue evergreen graphics; schedule time-sensitive launch graphics.

Troubleshooting CSV Imports

If a CSV import fails or posts do not appear as expected, the issue is usually related to formatting, missing information, image references or date/time settings.

Common CSV problems

• Column headers were changed.
• Required columns are missing.
• Date or time format is incorrect.
• Rows contain empty required fields.
• Image filenames do not match uploaded images.
• Links contain extra spaces.
• Unsupported characters appear in the file.
• The file was saved in the wrong format.

Image-related problems

• Image file was not uploaded.
• Filename in CSV does not match the image file.
• Image is too large.
• Image type is unsupported.
• Image aspect ratio is wrong for the selected platform.
• Image URL is private or not accessible.

Scheduling problems

• Timezone is incorrect.
• Date format does not match the template.
• Time format is missing or invalid.
• Queue fields and scheduled date fields conflict.
• Posts were imported as drafts instead of scheduled posts.

How to troubleshoot

1. Open the official template again and compare your file.
2. Check that column headers have not changed.
3. Review the first failed row carefully.
4. Check dates, times and required fields.
5. Check image filenames and uploaded files.
6. Remove blank rows at the bottom of the file.
7. Try uploading a smaller test file.

Best practice

If a large upload fails, do not keep uploading the same file without changes. Fix the issue, test a small batch, then upload the full version once the test works.