Ultimate Guide - Programmatic SEO on Wix via Excel with CapGo.AI's Case Studies

To do programmatic SEO with Wix using a CSV or Excel file, you'll use Wix CMS (Content Manager) and dynamic pages to create SEO-optimized pages at scale. Here's how you can do it:

✅ Step-by-Step: Programmatic SEO with Wix + CSV/Excel

🔧 What You Need:

• A Wix site (any premium plan)
• Content Manager enabled
• A CSV file (or Excel file saved as .csv)
• A dynamic page setup

1. Enable Content Manager (Wix CMS)

• Go to your Wix editor
• Click on Content Manager in the left panel
• Choose Add to Site if it's your first time
• Click “Create a new collection”

2. Create a New Collection

Create a collection that matches your SEO content.

Example: For location-based landing pages, create fields like:

• Title
• Slug
• Meta Title
• Meta Description
• Body Text
• Image, City, Service, etc.

📝 You can customize fields based on your programmatic content (e.g., for real estate, use "Property Name", "Price", etc.)

3. Prepare Your CSV File

Create your spreadsheet matching the fields in your collection.

Sample CSV structure:

Save the file as CSV (.csv) — this is the format Wix supports.

4. Import the CSV into the Collection

1. In the Content Manager, open the collection you created
2. Click the “Import Items” button
3. Upload your CSV file
4. Map the columns from your CSV to the collection fields
5. Click Import

✅ All your items are now available in the collection.

5. Create a Dynamic Page Template

1. In the Editor:
   • Go to Pages > Dynamic Pages
2. Click “+ Add Dynamic Page”
3. Choose the collection you imported to
4. Design the page using:
   • Title → Heading
   • Body Text → Paragraph
   • Dynamic content fields from your collection

📍The URL of each page will use the Slug from your collection:
e.g., yoursite.com/yoga/yoga-nyc

6. Set SEO Settings Per Page

Wix allows dynamic SEO tags for each CMS entry:

• Go to Page Settings > SEO Settings
• Use field values dynamically, like:
  • Title tag: Best Yoga in {Title}
  • Meta Description: {Meta Description}

This makes each page unique and SEO-optimized.

7. Publish & Index

• Click Publish in Wix
• Each dynamic page is now live and indexable
• Go to Wix SEO Tools or Google Search Console
  • Submit your sitemap for indexing: yoursite.com/sitemap.xml

🧠 Bonus Tips

• Use Excel formulas to generate programmatic variations before saving as CSV
• Use Wix Velo (Dev Mode) for custom logic or conditional rendering if needed
• Use Repeater Elements for listing dynamic items in bulk

📌 CAPGO AI Service Model:

CapGo AI provides full AI programmatic SEO and GEO service.

During the collaboration process, CAPGO will provide page structure recommendations and content field requirements.

The client team will then complete the design and configuration of the Wordpress template (such as Liquid templates and Metafields settings) according to the requirements.

Subsequently, CAPGO will generate large-scale SEO content based on the template structure and deliver it to the client via CSV or API for bulk import into Shopify, enabling efficient programmatic landing page construction.