Save a lot of time on manual typing of data with the ability to create lists and tables through the mechanism of data import.
To start importing data from excel file, go to the designer object repository:
and then select a table or list to which you want to import the data:
After moving to list or table editor, select an option to import data from the .xlsx file:
Data import tool allows you to choose between additive importing (new data will be added to the existing, existing data will be updated), or reimport (the data is overwritten with the imported). After choosing the appropriate import mode, select the file from which you want to import the data. Enter the number of the header lines to be skipped too.
Remember, the file should have the same number and types of columns as the table or list which is the target of the import.