How to Import Blogs from CSV
The CSV Blog Importer enables you to import dozens of blog posts within minutes - no manual copying or complex setup required. Whether you’re moving from Blogger, Wix, WordPress, or any other platform that supports CSV exports, this guide walks you through every step of the process - from preparing your spreadsheet to reviewing, scheduling, and publishing your posts with ease.
Key Benefits
- Seamless Migration: Eliminate tedious copy-and-paste processes when moving content from other platforms.
- Bulk Uploading: Import up to 60 posts in one file to accelerate onboarding.
- Smart Organization: Automatically match or create authors and categories for cleaner imports.
- Flexible Scheduling: Automatically detect and apply publish dates from your CSV.
- Built-in SEO Preview: Review titles, meta descriptions, and social images before publishing.
How to Use the CSV Blog Importer
Access Blogs & Choose a Target Blog
Log in to your account and navigate to Sites > Blogs from the left menu. Create a new blog site by selecting Create Blog or open an existing one by clicking its name.
Start a CSV Import
Next, click the New Post dropdown and select Import Blog Post from CSV.
Prepare & Upload the File
Doing so will display options for you to download the sample CSV or XLSX template or click Upload (or drag and drop) your prepared file.
Once you have uploaded your file, review the summary and formatting tips, then open any blog card to preview and edit your post as needed.
Set the publish date. Past dates publish immediately, future dates schedule automatically, and blank or invalid dates are saved as drafts.
Import & Confirm
Finally, click Import.
In the confirmation modal, review the summary (number of posts published or saved as drafts) and Click Import to add the posts to your blog site.
The CSV Blog Importer streamlines the blog migration process, empowering you to import, preview, and publish content with confidence and efficiency. Whether you’re managing one site or hundreds, this tool ensures a fast, accurate, and hassle-free transition so you can focus on creating, not copying.
✍Important Notes
- Automatic Validation: The platform scans your CSV headers upon upload and flags any missing or misspelled fields.
- Required Fields: All required headers must be present, though cell values may remain blank.
- Error Detection: Inline error chips highlight issues such as missing images, invalid dates, or long meta descriptions.
- File Size: Keep your CSV under 25MB to avoid timeouts; split larger files into smaller batches.
- Time Zone Handling: The importer respects each account’s time zone to ensure accurate publishing times.
Frequently Asked Questions
Q: What’s the maximum number of posts I can import at once?
- Up to 60 posts per CSV or XLSX file.
Q: Does the importer download and host my images?
- Yes. Include full image URLs or accessible relative paths, and the platform will fetch and host them.
Q: What happens if I re-import a post with the same title?
- A new draft will be created since duplicates aren’t automatically merged.
Q: Do drafts count toward the 60-post limit?
- Yes. All rows in your CSV count toward the cap, regardless of status.
Q: Can I undo an import?
- There’s no one-click rollback, but you can manually delete, or bulk-delete imported posts.