How to Export Content Metadata from Contentful

Contentful Web App Export

import json, csv

with open("contentful-export.json") as f:
    data = json.load(f)

# Export entries (content items)
with open("contentful_entries.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow([
        "ID", "Content Type", "Created", "Updated",
        "Published Version", "Locale", "Fields Summary"
    ])
    for entry in data.get("entries", []):
        sys = entry.get("sys", {})
        fields = entry.get("fields", {})
        field_summary = "; ".join(
            f"{k}: {str(v.get('en-US', v))[:80]}"
            for k, v in fields.items()
        )
        writer.writerow([
            sys.get("id", ""),
            sys.get("contentType", {}).get("sys", {}).get("id", ""),
            sys.get("createdAt", ""),
            sys.get("updatedAt", ""),
            sys.get("publishedVersion", ""),
            "en-US",
            field_summary,
        ])

# Export assets (media files)
with open("contentful_assets.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow([
        "ID", "Title", "Description", "File Name",
        "Content Type", "Size", "URL", "Created", "Updated"
    ])
    for asset in data.get("assets", []):
        sys = asset.get("sys", {})
        fields = asset.get("fields", {})
        file_info = fields.get("file", {}).get("en-US", {})
        writer.writerow([
            sys.get("id", ""),
            fields.get("title", {}).get("en-US", ""),
            fields.get("description", {}).get("en-US", ""),
            file_info.get("fileName", ""),
            file_info.get("contentType", ""),
            file_info.get("details", {}).get("size", ""),
            file_info.get("url", ""),
            sys.get("createdAt", ""),
            sys.get("updatedAt", ""),
        ])

print("Exported entries and assets to CSV")

Contentful CLI

# Export entire space (entries, assets, content types)
contentful space export \
  --space-id YOUR_SPACE_ID \
  --environment-id master \
  --content-file contentful-export.json

# Export only specific content type
contentful space export \
  --space-id YOUR_SPACE_ID \
  --content-type blogPost \
  --content-file blog_posts.json

# The exported JSON can be converted to CSV using the
# Python script from Method 1 above.

Content Management API (CMA)

import contentful_management
import csv

client = contentful_management.Client("YOUR_CMA_TOKEN")
space = client.spaces().find("YOUR_SPACE_ID")
environment = space.environments().find("master")

# List all entries of a specific content type
entries = []
skip = 0
limit = 100
while True:
    batch = environment.entries().all({
        "content_type": "blogPost",  # Change to your content type
        "limit": limit,
        "skip": skip,
    })
    entries.extend(batch)
    if len(batch) < limit:
        break
    skip += limit

with open("contentful_metadata.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow([
        "ID", "Title", "Slug", "Status",
        "Created", "Updated", "Published At"
    ])
    for entry in entries:
        writer.writerow([
            entry.id,
            entry.fields().get("title", ""),
            entry.fields().get("slug", ""),
            "published" if entry.is_published else "draft",
            entry.sys.get("created_at", ""),
            entry.sys.get("updated_at", ""),
            entry.sys.get("published_at", ""),
        ])

# List all assets
assets = []
skip = 0
while True:
    batch = environment.assets().all({"limit": limit, "skip": skip})
    assets.extend(batch)
    if len(batch) < limit:
        break
    skip += limit

with open("contentful_assets.csv", "w", newline="") as f:
    writer = csv.writer(f)
    writer.writerow([
        "ID", "Title", "Description", "File Name",
        "Content Type", "Size", "Created", "Updated"
    ])
    for asset in assets:
        file_info = asset.fields().get("file", {})
        writer.writerow([
            asset.id,
            asset.fields().get("title", ""),
            asset.fields().get("description", ""),
            file_info.get("fileName", "") if file_info else "",
            file_info.get("contentType", "") if file_info else "",
            file_info.get("details", {}).get("size", "") if file_info else "",
            asset.sys.get("created_at", ""),
            asset.sys.get("updated_at", ""),
        ])

print(f"Exported {len(entries)} entries and {len(assets)} assets")