How can we update the size chart of products in bulk?

You can update the name of the Size chart in "metafields_size_chart" column in product CSV file.

For more details on how to add size chart please refer https://help.storehippo.com/topic/sizechart

For more details on creating product CSV please refer https://help.storehippo.com/topic/product-csv-file-format