I hav a google published csv sheet. I created a html table and want to display csv values from published csv sheet into all input fields inside html table.
due to a unspecified reason this question has been moved.
You can use Split() function https://www.w3schools.com/jsref/jsref_split.asp
let splitedResult = xmlhttp.responseText.split("\r");
You can assign the values to
element.value = splitedResult[0].trim();
element1.value = splitedResult[1].trim();
Check out this link for the implementation https://jsfiddle.net/SyamKumarD/xa49vspy/29/
I would suggest you to provide a iterable id to your table elements, so you don't need to hardcode the index to your split result and you can iterate through the element and assign the split value dynamically.