npm install strapi-plugin-csv-exporter

module.exports = {
  'csv-exporter': {
    enabled: true,
  },
};

// for strapi tsconfig
//  "module": "CommonJS",
//  "moduleResolution": "Node",
// use
//
// import type { CSVExporterPlugin } from "strapi-plugin-csv-exporter/dist/server/src";
//
// for
//  "module": "Node16",
//  "moduleResolution": "Node16",
import type { CSVExporterPlugin } from "strapi-plugin-csv-exporter/strapi-server";

module.exports = (): CSVExporterPlugin => ({
  // Content type specific configurations
  config: {
    // Configuration for articles content type
    'api::article.article': {
      // Label shown in the dropdown
      dropdownLabel: 'Published articles',

      // Columns to export
      columns: ['title', 'createdAt'],

      // Relations as column (optional)
      // A single configured column is exported under the relation's own name (e.g. "author").
      // Configuring multiple columns splits them into one cell per column (e.g. "author:name", "author:id").
      // Multiple related records are combined into comma-separated lists (e.g. "author:name": "John, Jane", "author:id": "1, 2").
      // Lists preserve record order; missing values leave empty positions.
      relation: {
        author: {
          column: ['name', 'id'],
        }
      },

      // Filters to apply to the query (optional)
      filter: {
        title: {
          $contains: 'Hello',
        },
      },

      // Status (draft or published, optional)
      status: 'published', // defaults to draft if not provided

      // Custom columns to add to the table
      customColumns: {
        'customColumnName': { // This will be used as collumn title
          // item contains the element containing all columns and relations to build a custom column
          column: (item) => `custom string result with id: ${item.id}`
        }
      }

    },
  },
  // Optional: Fields to globally ignore in exports
  ignore: [], // default
  // Optional: Exclude fields marked `private: true` in the content type schema from exports.
  // Password fields are always excluded regardless of this setting
  excludePrivateFields: false, // default
  // Optional: Global date formatting for all fields that are a valid ISO Date
  dateFormat: 'dd.MM.yyyy HH:mm', // default
  // Optional: Formatting for date-only fields
  dateOnlyFormat: 'dd.MM.yyyy', // default
  // Optional: Formatting for time-only fields
  timeFormat: 'HH:mm', // default
  // Optional: Set a *global* IANA time zone identifier or UTC offset (e.g. 'Europe/Berlin' or '+02:00'). Per default, the current timezone of the client will be used to format timestamps. If no timezone can be determined, default will be UTC+00:00)
  timeZone: '+00:00', // default
  // Optional: Protect against CSV injection by prefixing values that a spreadsheet would
  // evaluate as a formula (values starting with =, +, -, @, tab or CR) with a single quote.
  // Plain numbers (-5, +3.2) are left untouched
  escapeFormulas: true, // default
  // Optional: Prefix the file with a UTF-8 byte order mark, to not assume
  // local ANSI code page and mangle umlauts, accents and other non-ASCII characters
  bom: true, // default
  // Optional: How many rows are fetched per database round trip while exporting
  batchSize: 500, // default
  // Optional: Hard cap on exported rows. Unlimited when not set
  maxRows: undefined, // default
});