Export the Media Library List to CSV

add_filter( 'bulk_actions-upload', function ( $actions ) {
    $actions['wpide_export_media'] = 'Export to CSV';
    return $actions;
} );

add_filter( 'handle_bulk_actions-upload', function ( $redirect, $action, $ids ) {
    if ( 'wpide_export_media' !== $action || ! current_user_can( 'upload_files' ) ) {
        return $redirect;
    }

    $rows = array( array( 'ID', 'URL', 'Title', 'Alt text', 'Caption', 'Type', 'File size', 'Width', 'Height', 'Uploaded' ) );
    foreach ( $ids as $id ) {
        if ( 'attachment' !== get_post_type( $id ) ) {
            continue;
        }
        $meta   = wp_get_attachment_metadata( $id );
        $file   = get_attached_file( $id );
        $rows[] = array(
            $id,
            wp_get_attachment_url( $id ),
            get_the_title( $id ),
            get_post_meta( $id, '_wp_attachment_image_alt', true ),
            wp_get_attachment_caption( $id ),
            get_post_mime_type( $id ),
            ! empty( $meta['filesize'] ) ? $meta['filesize'] : ( $file && file_exists( $file ) ? filesize( $file ) : '' ),
            $meta['width'] ?? '',
            $meta['height'] ?? '',
            get_the_date( 'Y-m-d', $id ),
        );
    }

    if ( defined( 'WP_CLI' ) && WP_CLI ) {
        return $redirect;
    }

    nocache_headers();
    header( 'Content-Type: text/csv; charset=utf-8' );
    header( 'Content-Disposition: attachment; filename=media-' . gmdate( 'Y-m-d' ) . '.csv' );
    $out = fopen( 'php://output', 'w' );
    fwrite( $out, "\xEF\xBB\xBF" );
    foreach ( $rows as $row ) {
        fputcsv( $out, array_map( function ( $cell ) {
            return is_string( $cell ) && preg_match( '/^[=+\-@]/', $cell ) ? "'" . $cell : $cell;
        }, $row ) );
    }
    fclose( $out );
    exit;
}, 10, 3 );