CSVImporter-for-googlesheet

Easily Import CSV according to filter of columns, appending to a old sheet

Code written in AppScript and HTML

Steps

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