Bulk Import Blog Posts Using CSV

Overview

The CSV Blog Importer allows you to quickly import multiple blog posts into your CRM by uploading a properly formatted CSV or Excel file. This tool is ideal for migrating content from platforms like WordPress, Wix, or Blogger, or for bulk-creating new posts with minimal manual effort.

Key Benefits

• Efficient Migration: Move dozens of posts from external platforms without manual copying.
• Bulk Creation: Import up to 60 posts in a single file.
• Smart Organization: Automatically match or create authors and categories.
• Flexible Scheduling: Set publish dates directly in your CSV—past dates publish immediately, future dates schedule, and blank dates save as drafts.
• SEO Preview: Review titles, meta descriptions, and images before publishing.
• Error Handling: Inline validation highlights issues like missing fields or invalid data.

Before You Begin

• Ensure your CSV file includes all required column headers.
• Keep file size under 25 MB to avoid upload issues.
• Use the downloadable sample CSV template to prevent formatting errors.
• Provide publicly accessible image URLs if including images.

How to Import Blog Posts

Step 1: Access the Blog Section

Navigate to Sites → Blogs in your CRM. Select an existing blog or create a new one.

Step 2: Start the Import

Click the New Post dropdown and choose Import Blog Post from CSV.

Step 3: Upload Your File

Download the sample template to ensure proper formatting. Click Upload or drag and drop your prepared CSV or XLSX file. Review the file summary and click Continue.

Step 4: Preview and Edit Posts

Review each post in the preview panel. Click the edit icon to make adjustments if needed. Set publish dates using the date picker—past dates publish immediately, future dates schedule, and blank dates save as drafts.

Step 5: Confirm Import

Click Import and review the summary of how many posts will be published, scheduled, or saved as drafts. Confirm to complete the import.

Handling Errors

If any rows fail validation, open Posts with Errors to see a detailed report. Each error will show the post title, the field with issues, and a message explaining how to fix it. Correct errors in your source file and re-upload.

Frequently Asked Questions

How many posts can I import at once?

You can import up to 60 posts per file.

Does the importer host images?

Yes. Provide full image URLs or publicly accessible paths, and the CRM will fetch and store them.

Can I edit posts after importing?

Yes. Imported posts can be edited like any other blog post.

What if I re-import a post with the same title?

A new draft will be created; duplicates are not merged.

Is there a file size limit?

Yes, keep files under 25 MB for best performance.

Can I undo an import?

There is no automatic rollback. You must manually delete imported posts if needed.

What if I leave the publish date blank?

The post will be imported as a draft.

What platforms can I migrate from?

Any platform that supports CSV or Excel exports, such as WordPress, Wix, or Blogger.