DataWorks DataAnalysis includes an online spreadsheet that lets you organize, calculate, and visualize data without writing SQL or setting up a separate business intelligence (BI) tool. Enter data directly or import it from a local file, then analyze and share results with your team.
Prerequisites
Before you begin, make sure that:
-
You have access to DataAnalysis.
-
To share or download spreadsheets, the tenant administrator has enabled Allow Sharing and Allow Downloads for Spreadsheet in Security Center > Data Query and Analysis Control > Query Result Control. For details, see Data Query and Analysis Control.
Limits
Visualization charts: The Basic Edition supports 7 chart types. Upgrade to Standard Edition or higher to access additional chart types.
Sharing limits: The maximum number of editors and viewers varies by edition.
| Feature | Basic Edition | Standard Edition | Professional Edition | Enterprise Edition |
|---|---|---|---|---|
| Maximum editors | 0 | 3 | 5 | 10 |
| Maximum viewers | 0 | 10 | 20 | 30 |
Open Spreadsheet
On the DataAnalysis page, click Go To DataAnalysis. In the left menu bar, click the 
or 
icon to open the Spreadsheet page.
Create a spreadsheet
Before analyzing data, create a spreadsheet to hold it.
New DataAnalysis
-
On the Spreadsheet page, click the
icon in the upper-right corner of the left directory tree to open the spreadsheet editor. -
Analyze your data, then click Save in the upper-right corner.
-
In the Save File dialog box, enter a File Name and click OK.
Legacy DataAnalysis
-
On the Spreadsheet page, under New spreadsheet, click the
icon to open the spreadsheet editor. -
Analyze your data, then click Save in the upper-right corner.
-
In the Save File dialog box, enter a File Name and click OK.
Import data
Spreadsheet supports direct data entry and importing from local files or other spreadsheets.
On the spreadsheet editing page, click Import in the upper-right corner and select an import type.
Import a spreadsheet
In the Import dialog box, click Spreadsheet and configure the parameters.
| Parameter | Description |
|---|---|
| Spreadsheet | Select the name of the spreadsheet to import. |
| Sheet | Select the sheet to import. |
| Data preview | Preview the data before importing. |
| Import start row | Row to start importing from. Default: 1. |
| Placement location | Current Worksheet or New Worksheet. |
| Placement method | Append, Overwrite, or Active Cell. |
Import a local CSV file
In the Import dialog box, click Local CSV File and configure the parameters.
| Parameter | Description |
|---|---|
| File | Click Select File, select the CSV file, and click Open. |
| Original character set | UTF-8 or GBK. If garbled text appears after import, switch the character set and check the data preview. |
| Separator | Row delimiters: \r\n, \n, or \r. Column delimiters: ,, ;, or \t. If data doesn't split into cells correctly, adjust the separator and check the data preview. |
| Data preview | Preview the data before importing. Use this to verify that the character set and separator settings are correct. |
| Import start row | Row to start importing from. Default: 1. |
| Placement location | Current Worksheet or New Worksheet. |
| Placement method | Append, Overwrite, or Active Cell. |
If numeric data appears as text after import (for example, a column of numbers that won't plot on a chart), right-click the column and select Convert this column to numeric.
Import a local Excel file
In the Import dialog box, click Local Excel File and configure the parameters.
| Parameter | Description |
|---|---|
| File | Click Select File, select the Excel file, and click Open. |
| Sheet | Select the sheet to import. |
| Data preview | Preview the data before importing. |
| Import start row | Row to start importing from. Default: 1. |
| Placement location | Current Worksheet or New Worksheet. |
| Placement method | Append, Overwrite, or Active Cell. |
Analyze data
Spreadsheet provides data analysis operations similar to Microsoft Excel. On the spreadsheet editing page, adjust font, alignment, number format, rows and columns, conditional formatting, and styles. Run data profiling to understand data quality and distribution.
For details on each toolbar button, see Toolbar reference.
Formatting and styles
Use the top toolbar to adjust font, alignment, number format (such as currency or percentage), and conditional formatting.
Use formulas and functions
Enter = in a cell to start a formula. Common functions such as SUM and AVERAGE are supported.
Create charts
-
Select the data range to visualize.
-
In the top menu bar, select Chart and choose a chart type: Column Chart, Line Chart, Pie Chart, or others.
-
The system detects the data type and generates the chart automatically.
If a chart doesn't appear as expected, right-click the target column and select Convert this column to numeric. This typically happens when numeric data is stored as strings after import.
Use data profiling
Data profiling analyzes the quality, structure, distribution, and statistics of your data.
-
Basic mode: Select data and click Data Profile in the toolbar. The system analyzes each column and shows Type, Distribution, Null Values, and Duplicate Values.
-
Verbose mode: In basic mode, click Detailed Mode in the upper-right corner for per-column details including Field Name, Field Type, Chinese Field Name, Field Description, and Security Level.
| Data type | Basic mode | Verbose mode |
|---|---|---|
| String / Date | Displays as rich text: percentage of the Top 2 values, percentage of other values, and total unique value count if distinct values exceed 50% of total values. | Basic information: field count, unique values, valid values, null value percentage, and more. Top 5 duplicate values. |
| Numeric (integer / float) | A binned column chart shows the data range and distribution. | Basic information: field count, unique values, zero values, null value percentage, and more. Top 5 duplicate values. Statistics: max, min, and average values. Histogram. |
| Boolean | A pie chart shows the percentage of true and false values. String values true and false, and numeric values 0 and 1 are recognized as Boolean. |
Basic information: field count, unique values, zero values, null value percentage, and more. Top 5 duplicate values. Pie chart distribution. |
| Mixed | A pie chart shows the percentage of each data type in the column, indicating dirty data. If the dirty data is removed, distribution is shown based on the remaining data types. | Not applicable. In verbose mode, analysis is based on the predefined field type. |
| Null | The percentage of NULL values is highlighted in red. |
Shown as the null value percentage in the basic information section for each data type. |
View and manage spreadsheets
-
On the spreadsheet editing page, click Spreadsheet in the upper-left corner or the
icon in the left menu bar to go to the spreadsheet list. -
On the Spreadsheet page, view your spreadsheets in the I Created and Share it with me lists under All Spreadsheets.
-
Manage spreadsheets using the icons next to each file:
Action How Rename Click the 
icon. In the Rename dialog box, enter a new File Name and click OK.Change owner Click the 
icon. In the Change Owner dialog box, enter and select the new owner, then click OK.Clone Click the 
icon. A copy is created with a _copysuffix.Delete Click the 
icon. In the Delete dialog box, click OK. -
Click a file name to reopen the spreadsheet editor.
Export, share, and download spreadsheets
After analyzing your data, export it to MaxCompute, share it with specific users, or download it locally.
Export to a MaxCompute table
Spreadsheet generates a MaxCompute table creation statement based on your data. Copy the statement and run it in DataStudio. A maximum of 100 rows of data can be exported.
-
In the upper-right corner of the spreadsheet editing page, choose Export > Generate MaxCompute Build Table Statement.
-
In the Export As MaxCompute Table dialog box, configure the parameters.
ImportantOnly non-partitioned tables are supported. The SQL statement is limited to 100 lines.
Insert mode Parameter Description Insert data into MaxCompute table (INSERT OVERWRITE) Workspace Select the target workspace. Table Enter and select the table name to insert data into. Create MaxCompute table and insert data Workspace Select the target workspace. Table name Enter a name for the new table. The name must be unique. Click Check For Duplicates to verify. 
-
Click Copy SQL Statement, then click Close.
-
Click the
icon in the upper-left corner, then choose All Products > Data Development And Task Operation > DataStudio. -
Use a MaxCompute SQL node to run the statement:
-
New DataStudio: see Develop a MaxCompute SQL node.
-
Legacy DataStudio: see Develop an ODPS SQL task.
-
-
Click Submit To Development Environment or Submit To Production Environment.
In a workspace running in basic mode, click Submit To Production Environment.
Share a spreadsheet
Share a spreadsheet for collaboration or read-only viewing.
On the spreadsheet editing page, click Share in the upper-right corner.
| Sharing option | How to configure |
|---|---|
| Link | Specify who can edit or view, or make the spreadsheet visible to everyone. Click Copy Link and send it to recipients. Enable Access Code to protect the link with an extraction code. |
| Users with Edit Access | Select Users with Edit Access > Add, enter and select members, then click OK. |
| Visible To All | Turn on the Visible To All switch to make the spreadsheet accessible to all users. |
| Users with Read Access | Turn off Visible To All, then select Users with Read Access > Add, select members, and click OK. |
After sharing, send the link to the intended recipients. The View Records section in the upper-right corner shows who has viewed the spreadsheet. Shared spreadsheets appear in the Share list on the Spreadsheet page.
Download a spreadsheet
On the spreadsheet editing page, click Download in the upper-right corner to download the spreadsheet to your local machine.
Toolbar reference
Font
| # | Feature | Description |
|---|---|---|
| ① | Font | Select the font type. |
| ② | Font size | Select the font size. |
| ③ | Bold | Make text bold. |
| ④ | Italic | Italicize text. |
| ⑤ | Underline | Underline text. |
| ⑥ | Strikethrough | Add a strikethrough to text. |
| ⑦ | Border | Add a border to cells. |
| ⑧ | Background fill | Set the cell background color. |
| ⑨ | Text fill | Change the text color. |
Alignment
| # | Feature | Description |
|---|---|---|
| ① | Top align | Align text to the top of the cell. |
| ② | Middle align | Center text vertically between the top and bottom of the cell. |
| ③ | Bottom align | Align text to the bottom of the cell. |
| ④ | Auto Wrap | Display long text on multiple lines. |
| ⑤ | Align left | Align text to the left. |
| ⑥ | Center | Center text horizontally. |
| ⑦ | Align right | Align text to the right. |
| ⑧ | Merge and center | Merge selected cells into one and center the content. |
Number
| # | Feature | Description |
|---|---|---|
| ① | Data type | Select the cell format: Number, Currency, Short Date, Long Date, Time, Percentage, Fraction, Scientific, or Text. |
| ② | Percentage | Set the cell format to percentage. |
| ③ | Two decimal places | Format values to two decimal places. |
| ④ | Thousands separator | Add a thousands separator to values, for example, 1,005. |
| ⑤ | Currency | Set the cell format to currency: CNY, USD, GBP, EUR, or CHF. |
Rows and columns
| # | Feature | Description |
|---|---|---|
| ① | Insert row | Add a new row. |
| ② | Insert column | Add a new column. |
| ③ | Delete row | Delete the selected row. |
| ④ | Delete column | Delete the selected column. |
| ⑤ | Lock row | Freeze all rows above the selected row. |
| ⑥ | Lock column | Freeze all columns to the left of the selected column. |
| ⑦ | Hide row | Hide the selected row. |
| ⑧ | Hide column | Hide the selected column. |
Conditional formatting
| # | Feature | Description |
|---|---|---|
| ① | Filter-based conditional formatting | Apply Highlight Cells Rules or Top/Bottom Rules. |
| ② | Color fill conditional formatting | Apply Gradient Fill, Solid Fill, or Color Scales. |
| ③ | Icon fill conditional formatting | Apply Directional, Shapes, Indicators, or Ratings icons. |
| ④ | Clear conditional formatting | Clear Rules From Selected Cells or Clear Rules From Entire Sheet. |
Style
| # | Feature | Description |
|---|---|---|
| ① | Apply table style | Select and apply a table style. |
| ② | Delete | Remove the applied table style. |
| ③ | Cell style | Set the style of individual cells. |
| ④ | Clear | Clear All, Clear Contents, or Clear Formats. |
Edit
| # | Feature | Description |
|---|---|---|
| ① | AutoSum | Calculate Sum, Average, Count Numbers, Max, or Min. |
| ② | Search | Click Search or press Ctrl+F to open the search box. |
| ③ | Sort and filter | Filter data and sort in ascending or descending order. |
| ④ | Clear | Delete selected content. |
Charts
| # | Chart type | Reference |
|---|---|---|
| ① | Column Chart | Column chart |
| ② | Line Chart | Line chart |
| ③ | Pie Chart | Pie chart |
| ④ | More | Area chart, Bar chart, Scatter chart, Stock chart |
Plugins
Click the 
icon to apply Convert To Numeric or Convert To String to the selected data.
Keyboard shortcuts
Click the 
icon to view all keyboard shortcuts.