Cluster CSV Import

The CSV import feature lets you quickly upload clusters, topics, and subtopics into your project. This guide explains CSV preparation and the import process.

Preparing Your CSV File

CSV Format

Your CSV must have these columns in the exact order listed:

1. Cluster Name (Required) - Main content group
2. Topic Name (Optional) - Topic name within the cluster
3. Topic Intent (Optional) - Purpose (Informational, Commercial, etc.)
4. Topic Journey (Optional) - Stage in the customer journey
5. Topic URL (Optional) - Published URL
6. Subtopic Name (Optional) - Subtopic within a topic
7. Subtopic Intent (Optional) - Purpose of subtopic
8. Subtopic Journey (Optional) - Stage in customer journey
9. Subtopic URL (Optional) - Published URL for subtopic

Here is an CSV Example you can use

Important Notes

• Required Column: Only "Cluster Name" is mandatory.
• Hierarchy: To add subtopics, include a "Topic Name."
• Publishing Status: Items with URLs are auto-marked as "published"; items without URLs remain "unpublished."
• File Size Limit: Maximum file size is 3MB.

Importing Your CSV

1. Select your project.
2. Go to the Import tab.
3. Select your CSV file.
4. Click Upload & Import.
5. Await confirmation.

Troubleshooting

If your import fails:

• Confirm CSV formatting matches requirements.
• Ensure file size is under 3MB.
• Remove problematic special characters.
• Check that "Cluster Name" is present for all rows.

Creating Your CSV

Use any spreadsheet tool like:

• Microsoft Excel
• Google Sheets

Save as CSV (Comma Separated Values).

Need Help?

Contact support at help@serp360.ai