You can use Import.. option in SAP HANA Studio to import data from a CSV file. Go to file and click on Import option.
Next is to define Import properties. You can create a new table or you can also use an existing table in HANA database. You can also define if a Header rows exists.