At a glance
- What you can do: import a complete editorial backlog into the Semji planning via a CSV file, in just a few clicks
- Who it's for: content managers, SEO project leads, editorial directors, teams onboarding or migrating from another tool
- Why it matters: what used to take hours of manual work now takes seconds, regardless of volume
What changes for you
Until now, populating your Semji planning meant creating each draft one by one through the "New draft" wizard. Manageable for 10 pieces of content, but completely impractical for 500 or 5,000.
Before: every content piece had to be added manually. Teams with large catalogs spent hours just getting started, and migrating from another tool meant re-entering everything from scratch.
Now: you prepare your CSV file from the tools you already use (Google Sheets, Excel, Search Console, Screaming Frog), drop it into Semji, and your drafts appear instantly in your planning. Your team can start working right away.
Good to know ℹ️: bulk import does not consume any credits. Credits are only used when you launch an analysis on a piece of content.
| Before | With bulk import |
|---|---|
| Manual creation, one draft at a time | Import thousands of pieces of content in a single file |
| Onboarding blocked by catalog entry | Immediate start from day one |
| Migrating from a competitor tool meant total re-entry | Export your CSV, import into Semji in under 10 minutes |
| Annual planning takes days | 350 topics in a Google Sheet? One drag and drop is all it takes |
What you'll get
Once your CSV file is imported, all your drafts appear directly in the active folder of your Semji planning. Each piece of content is created with the information you provided: title, primary keyword, URL (for existing content), status, and any other column defined in the template.
- Drafts created instantly, ready to be assigned and analyzed
- A fully actionable planning view to manage production immediately
- The ability to import existing content (with URL) directly in "Optimize" mode
- A downloadable CSV template from the interface to ensure the right format from the start
[Suggested illustration: Semji planning view after a successful import, showing a list of newly created drafts in the active folder, with the confirmation toast "X Drafts added to planning" visible at the bottom of the screen]
How to use it (step by step)
1) Prepare your CSV file
Download the CSV template directly from the Semji import interface (via the "Download a sample CSV file" link) or from the Help Center. Fill it in with your data: content title, primary keyword, URL if the content already exists on your site, and any other relevant fields.
Save your file as a CSV with UTF-8 encoding and a comma as the separator (not a semicolon). Make sure the file size does not exceed 10 MB.
Tip ✅: for your first imports, test with 5 to 10 rows before loading your full file. This lets you validate the format without any risk.
[Suggested illustration: a CSV file open in Google Sheets or Excel, showing the Semji template columns correctly filled in with sample titles, keywords, and URLs]
2) Open the "New draft" wizard
In your Semji planning, click the "New draft" button. The wizard opens and presents three draft creation options. Select the "Import a CSV file" card (third option).
3) Drop your CSV file
The import screen appears. Drag your CSV file into the drop zone, or click "click to upload" to select it from your computer. Once the file is loaded, its name and size appear on screen. If you want to switch files, delete it and drop a new one.
4) Launch the import
Click "Import". Your drafts are created instantly in the active folder of your planning. A confirmation message displays the number of pieces of content added (for example: "6,000 Drafts added to planning."). You can immediately assign, filter, and launch analyses on these pieces of content.
Tips for getting the most out of it
Always use the provided template. The column format is standardized: starting from the template avoids header errors and ensures your import is accepted on the first try.
Import into the right folder. Drafts land in the active folder at the time of import. Navigate to the correct folder in your planning before launching the wizard.
For existing content, include URLs. If your CSV contains URLs, Semji creates the drafts directly in "Optimize" mode, so you can launch an optimization analysis without any extra steps.
If you get a format error, check two things first: file encoding (UTF-8 required) and the separator used (comma, not semicolon). Most import errors come from one or the other.
Pro tip 💡: if you plan in Google Sheets or Excel, keep your existing workflow. At the end of each week or sprint, export to CSV and import into Semji. Your planning updates in seconds, without touching your source file.
Take it further
Bulk import is especially powerful when combined with other Semji editorial planning features. Once your drafts are imported, you can assign them to writers, schedule publication dates from the calendar view, and trigger analyses in batch to prioritize the highest-impact optimizations.
Watch out ⚠️: in V1, import does not automatically deduplicate content. If you import the same file twice, drafts will be duplicated. Always check your planning before running an import again.
Useful links: