There are 2 types of files that can be read in through the IMPORT function, namely EXCEL or CSV files. The recommendation is for EXCEL files because here a better control is possible of what and how everything is brought in.
Click on the button for more information of the desired format.