You can directly import data into a spreadsheet and customize
your import options here.
To import data into a spreadsheet, do the following steps:
- Open the spreadsheet you want to import data into, and click .
- The Import Data window is opened. Click Browse.
Currently you can import data from documents in the following formats:
- ODF Spreadsheet (.ods)
- Microsoft® Excel 97/2000/XP
(.xls, .xlw)
- Text CSV (.csv, .txt)
- Select the data source file and click OK.
You can see that all the sheets have been selected in the selection
list.
- By default, the data are imported to new sheets in the spreadsheet.
You can customize your import options.
- Click OK.