Is it possible to convert the form from Excel and have the submissions populate the Excel sheet?

I need to a) import an existing excel sheet b) convert to form c) email form link to list of people d) have people fill in some "cells" e) download populated data to local excel worksheet. Need to know if this can be done using Jotform API with VB scripting in excel worksheet.

Unfortunately, there is no way to import excel sheet and create a form of it. The only way is to create a form from scratch and mimic the fields from the sheet. 

You can share the form link easily by following this guide: https://www.jotform.com/help/303-How-to-Send-a-Form-via-Email

You can easily integrate the existing form with Spreadsheet by following this guide: https://www.jotform.com/help/228-How-to-Integrate-Form-with-Google-Spreadsheet

Then, every time the form is submitted the data will go to that sheet.

Could that work for you?