API script and metafields for 2.0 theme

We have 1000’s of products and need to auto populate metafields to our 2.0 theme. Does anyone have a script or write one for use. Our data is on excel spreadsheet.

Thanks in advance!