- Open the sheet
- go to extensions and click App Script
- Add two files Code.gs and index.html
- Copy-Paste the above code
- select onOpen() function from drop down on top
- click run
- go back to sheets and click CSV Utils on the menu bar
- select import csv now just drag and drop and get your csv to sheet as per you want