After a workbook is created, you can write data to the workbook for data analysis. You can also import data from a data source or from your on-premises machine to the workbook for data analysis. This topic describes how to import data to a workbook.

Prerequisites

A blank workbook is created. For more information, see Create a workbook.

Go to the workbook editing page

  1. Go to the workbook page.
  2. In the All Spreadsheets section of the page that appears, click the name of the workbook that you created to go to the workbook editing page.

Import data from your on-premises machine

On the workbook editing page, move the pointer over Import in the upper-right corner and select Local File or File Data to import data from your on-premises machine.
  • If you select Local File, you can import only Excel files from your on-premises machine. Data in all the sheets of a selected Excel file is imported.

    Choose Import > Local File. Select the Excel file that you want to import and click Open to import data in all the sheets of the Excel file to the workbook.

  • If you select File Data, you can import data in workbooks, CSV files, or Excel files from your on-premises machine. If you import data in a workbook or an Excel file, you can specify the sheet from which you want to import data.
    Choose Import > File Data. In the Import dialog box, select one of the following types of source files based on your business requirements:
    • Spreadsheet
      In the Import dialog box, click Spreadsheet, configure parameters, and then click OK.
      ParameterDescription
      SpreadsheetThe workbook from which you want to import data. Select a workbook from the Spreadsheet drop-down list.
      SheetThe sheet from which you want to import data. Select a sheet from the Sheet drop-down list.
      Data PreviewThe data that you want to import.
      Import Start RowThe row from which the data starts to be imported. Default value: 1.
      Placement LocationThe location where the data you want to import is placed. Valid values: Current Worksheet and New Worksheet.
      Placement MethodThe way in which the data you want to import is placed. Valid values: Append, Overwrite, and Active Cell.
    • Local CSV File
      In the Import dialog box, click Local CSV File, configure parameters, and then click OK. Import
      ParameterDescription
      FileThe CSV file from which you want to import data. Click Select File(.csv), select a CSV file from your on-premises machine, and then click Open.
      Original Character SetThe character set that is used by the selected CSV file. Valid values: UTF-8 and GBK. If garbled characters appear, you can change the character set.
      SeparatorThe row delimiter and column delimiter.
      • The following row delimiters are supported: \r\n, \n, and \r.
      • The following column delimiters are supported: commas (,), semicolons (;), and \t.

      If the cell data cannot be correctly separated, you can change the delimiters.

      Data PreviewThe data that you want to import.
      Import Start RowThe row from which the data starts to be imported. Default value: 1.
      Placement LocationThe location where the data you want to import is placed. Valid values: Current Worksheet and New Worksheet.
      Placement MethodThe way in which the data you want to import is placed. Valid values: Append, Overwrite, and Active Cell.
    • Local Excel File
      In the Import dialog box, click Local Excel File, configure parameters, and then click OK. Excel
      ParameterDescription
      FileThe Excel file from which you want to import data. Click Select File(.xlsx), select an Excel file from your on-premises machine, and then click Open.
      SheetThe sheet from which you want to import data. Select a sheet from the Sheet drop-down list.
      Data PreviewThe data that you want to import.
      Import Start RowThe row from which the data starts to be imported. Default value: 1.
      Placement LocationThe location where the data you want to import is placed. Valid values: Current Worksheet and New Worksheet.
      Placement MethodThe way in which the data you want to import is placed. Valid values: Append, Overwrite, and Active Cell.