Question: how to import data from csv file to sqlite?
Answer: Open the destination table to view then choose File -> Import CSV from the menu.
Or you can right-click on the table name from the right panel (or even any data cell of the table), choose Import CSV .