[Escalated to WPML Developers team] Feature request: translation estimate report

function export_word_count_to_csv() {
    // Adjust your query args as needed
    $args = array(
        'post_type'      => 'post', // Change to your desired post type
        'post_status'    => 'publish',
        'posts_per_page' => -1,
        'orderby'        => 'ID',
        'order'          => 'ASC',
    );

    $query = new WP_Query($args);

    if ($query->have_posts()) {
        // Set headers to force download CSV
        header('Content-Type: text/csv');
        header('Content-Disposition: attachment;filename=word-count-export.csv');

        $output = fopen('<em><u>hidden link</u></em>', 'w');

        // Output header row
        fputcsv($output, array('ID', 'Title', 'Word Count'));

        // Loop through posts
        while ($query->have_posts()) {
            $query->the_post();

            $post_id    = get_the_ID();
            $title      = get_the_title();
            $word_count = get_post_meta($post_id, '_wpml_word_count', true);

            // If no value, fallback to 0
            if (!$word_count) {
                $word_count = 0;
            }

            fputcsv($output, array($post_id, $title, $word_count));
        }

        fclose($output);
        exit; // stop script after CSV output
    } else {
        echo 'No posts found.';
    }

    wp_reset_postdata();
}

// You can call this function via a custom admin page, WP-CLI command,
// or hook it to an action like 'init' with a conditional check for a URL param
// Example: <em><u>hidden link</u></em>
add_action('init', function () {
    if (is_admin() || !isset($_GET['export_word_count'])) {
        return;
    }
    export_word_count_to_csv();
});