IBM Lotus Symphony


Importing data

You can directly import data into a spreadsheet and customize your import options here.

To import data into a spreadsheet, do the following steps:
  1. Open the spreadsheet you want to import data into, and click Data > Import Data.
  2. 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)
  3. Select the data source file and click OK. You can see that all the sheets have been selected in the selection list.
  4. By default, the data are imported to new sheets in the spreadsheet. You can customize your import options.
    • To specify the range of the source data, select only the sheets or data ranges you want in the selection list.
    • To import the data to new sheets, click New sheet in the Import data to area.
    • To import the data to the sheet that you currently focus on, click Existing place in the Import data to area. The detailed location is displayed in the field at the bottom of the window.
      Note: The Existing place option is available when only one sheet or data range is selected.
  5. Click OK.

Product Feedback | Additional Documentation | Trademarks