Importing Grid Data from Spreadsheet

  1. Select Import Grid Data from the Tools menu.
  2. If you import from Excel spreadsheet, make sure the file format is CSV.
  3. Click Browse to locate the excel file and enter the worksheet name from which to import data.
  4. Specify a range of cells from which to import data (for example, A1:B10) under the Define Cell Range heading:
  5. Click Preview and then click Continue to import the data.