Update post meta data (custom field) by post link

I have not tested this, but the idea is to find the post ID based on the post URL, and then update the meta field for that post.

I would save that excel as csv format. Import it to a new table in your database. That way you can easily have access to that information, instead of having to read a excel file (which could require you to include some extra php classes).

Once you have the excel data in the database you can pull that data and run it in a loop.

For example:

global $wpdb;
    //You can use $wpdb to query non-wordpress tables
    //Here I query I table I created video_urls
    //It has two columns. One with the post url, and one with the video url

    $results = $wpdb->get_results('SELECT * FROM video_urls', OBJECT);

    //Loop through each result

    foreach($results as $result){

        //use the wordpress function url_to_postid() to get the post id

        $post_id = url_to_postid($result->post_url);

        //update the post_meta with the wordpress function below
        //you will need to know the name of the custom field.

        update_post_meta($post_id, "NAME_OF_CUSTOM_FIELD", $result->video_url);

    }

This should work, but please do not just copy and paste and expect it to work. Also, make a backup of your database before running any scripts that attempts to mass update wordpress posts.

This code could be pasted in one of your page templates, and then you can just load that page to run the code once, and comment it out the code later so that it won’t run again.