Importing an XLS format file
Importing an XLS format file
Data can be imported from an .xls or .xlsx file created using Microsoft Excel or another spreadsheet program. The imported data fills a new table that is created automatically during import, and the new table is formatted automatically to match the format of the original spreadsheet.
1 Do one of the following to choose XLS In ():
On the ribbon, choose Insert > XLS In (in Data).
On the menu, choose Insert > XLS In.
Type xlsimport and then press Enter.
2 Choose the .xls or .xlsx file that contains the data you want to import.
3 Click Open.
4 If the specified file contains more than one sheet, enter the name of the sheet to import. If necessary, type ? and press Enter to see a list of sheet names.
5 Specify the insertion point for the upper-left corner of the table.