Question: how to import data from csv file?
Answer: With the needed spreadsheet open, click the cell where you want to import the data from a . ... 
On the Data tab, in the Get External Data group, click From Text.
Browse for the csv file you want to import, select it and click the Import button (or simply double click the .