I have many customer who have their data recorded in excel file and they find it difficult to complete form in my knack app using those data one by one. So, my target is to make API call with that excel file and it will create individual record for every single row from that excel file. I tried to do this using excel VBA but I can not find any solution.
Does anyone one know how can I achieve this or Is it possible to do this using Excel VBA.
Also I want to let you know that I want to build this system for my customer so that they can create their own record without any help.