Strapi 5 Export/Import CSV Plugin

Features

• Adds export/import buttons to configured Strapi content types
• Exports data to CSV format with selected fields
• Imports data from CSV while preserving relationships
• Supports various field types with automatic conversion

Installation

npm install export-import-strapi5-plugin

Configuration

Add to ./config/plugins.js:

module.exports = ({ env }) => ({
  'export-import-strapi5-plugin': {
    enabled: true,
    config: {
      entities: {
        'api::product.product': {
          fields: [
            'category.name',
            'brand.name',
            'name',
            'slug',
            'price',
            'sale',
            'hit',
            'available',
            'popularity',
          ],
        },
        // Add other content types as needed
      },
    },
  },
});

Configuration Options

• entities: Object containing content type configurations
  • Key: Content Type UID (e.g. "api::product.product")
  • fields: Array of fields to include in export/import
    • Supports nested fields with dot notation
    • Omit documentID - it's automatically included

Supported Field Types

Usage Notes

1. Record Identification:

   • Imports update existing records using documentID
   • This field is automatically included in exports
   • Never remove/modify documentID in CSV files

2. Relationship Handling:

   • Relationships are exported (e.g. category.name)
   • Relationship data is read-only during import
   • Only direct fields of the entity are updated

Example CSV Format

For api::product.product:

documentID,category.name,brand.name,name,slug,price,sale,hit,available,popularity
1,Electronics,Sony,TV,sony-tv,999.99,true,true,true,5
2,Electronics,Samsung,Phone,samsung-phone,799.99,false,true,true,8

Limitations

1. Only updates existing records (by documentID)
2. Relationship fields are read-only during import
3. Not all Strapi field types are supported
4. CSV files must maintain original documentIDs

UI Integration

After installation:

1. Navigate to Content Manager
2. Select configured content type
3. Find new buttons in list view:
   • Export CSV - Download current data
   • Import CSV - Update records from file

Note: Always back up your data before performing imports