strapi-plugin-import-export-data

Import and export for Strapi 5 collection types, with CSV/JSON/XLSX export, date filtering, column selection, import column mapping, batched import progress, and safer handling for Strapi object fields such as blocks.

Compatibility

• Strapi: >=5.0.0
• Tested with Strapi: 5.46.1
• Node: follows your Strapi 5 project requirements
• Supported export formats: CSV, JSON, XLSX
• Supported import format: CSV
• Not supported: Strapi 4

Features

• Export collection entries to CSV, JSON, or XLSX.
• Select exactly which columns to export.
• Include drafts or export only published records for Draft & Publish collections.
• Filter exports by createdAt, updatedAt, or publishedAt.
• Preview collection data before export.
• Preserve Strapi object fields by exporting object values as JSON.
• Import CSV files into collection types.
• Preview CSV rows before import.
• Map CSV columns to Strapi fields before importing.
• Automatically map CSV columns when names match Strapi fields.
• Import records in batches with progress feedback.
• Row-aware import errors for easier troubleshooting.
• Filters out private/password fields from export and import.
• Guards exported CSV values against spreadsheet formula injection.
• Rejects non-CSV spreadsheet packages such as Apple Numbers files.

Installation

npm install strapi-plugin-import-export-data

or:

yarn add strapi-plugin-import-export-data

Restart Strapi after installation.

Configuration

Enable the plugin in your Strapi app config:

// config/plugins.ts
export default {
  'strapi-plugin-import-export-data': {
    enabled: true,
  },
};

Then restart your Strapi server and open the plugin from the Strapi admin sidebar.

Usage

Export Data

1. Open Import-Export Data in the Strapi admin panel.
2. Choose Export.
3. Select a collection.
4. For Draft & Publish collections, choose whether draft records should be included.
5. Optionally choose a date field and date range.
6. Review the KPIs and preview.
7. Select the columns you want to export.
8. Choose CSV, JSON, or XLSX.
9. Click Export.

Object values, including Strapi blocks content, are exported as JSON strings in CSV and preserved as structured values in JSON/XLSX where possible. For Draft & Publish collections, the export preview follows Strapi's draft-side collection view semantics.

Import CSV

1. Open Import-Export Data in the Strapi admin panel.
2. Choose Import.
3. Select a collection.
4. Choose a .csv file.
5. Review the CSV preview.
6. Map CSV columns to Strapi fields.
7. Click Import CSV.

The plugin imports records in batches and shows progress while importing.

CSV Notes

• Upload real .csv files only.
• Spreadsheet files from Apple Numbers, Excel, or Google Sheets must be exported as CSV first.
• For blocks, json, components, dynamic zones, media, and relations, values should be valid JSON.
• Empty cells are skipped during import.
• System fields such as id, documentId, createdAt, updatedAt, and publishedAt are ignored during import.

Limits And Safety

The plugin includes defensive limits and checks:

• Legacy uploaded CSV file size limit: 10 MB.
• Legacy uploaded CSV row limit: 10,000 rows.
• Batched import endpoint limit: 500 records per batch.
• Maximum CSV columns per row: 200.
• Maximum cell length: 1,000,000 characters.
• Private fields and password fields are excluded from export/import.
• Admin and plugin content types are not available for import/export.
• Spreadsheet formula-like values are escaped when exporting CSV.

Troubleshooting

I see [object Object] in old exports

That CSV was exported before object fields were serialized as JSON. Re-export the collection with the latest plugin version.

Import says the file is a spreadsheet package

The selected file is not CSV. Export it from Numbers, Excel, or Google Sheets as comma-separated values (.csv) and import that file.

Import fails for a blocks field

Strapi blocks fields must be valid JSON arrays. Exporting from this plugin produces the expected format.

Published and draft IDs look different

In Strapi 5, draft and published versions of the same logical document can use different database row id values. Use documentId as the stable document identity when comparing versions.

Current Version

Recommended release version:

1.2.0

This is a minor release because it keeps Strapi 5 compatibility while adding JSON/XLSX export, export date filtering, a refined export workflow, clearer file naming, and UI improvements without breaking existing CSV export.

Development

Build the plugin:

npm run build

Verify in a linked Strapi app:

cd ../strapi-plugin-test-app
npm run build

License

MIT