DataV-Note import file data-DataV(DataV)-阿里云帮助中心

Import local files into DataV-Note to create file datasets. You can then use these datasets to run queries, perform analytics, and create reports.

Limits

You can only upload data files in CSV, XLSX, or JSON format. The file size cannot exceed 500 MB.
For JSON files, only array-type content is supported.
The uploaded file name must be unique within the current project.

Ensure your table data is clean and structured for accurate and efficient data analytics and visualization in DataV-Note. Follow these guidelines:

Column headings: Use the first row of your table for column headings. Use descriptive field names, such as publication year or sales quantity.
Table data: Arrange the data neatly under the column headings.
General terms: Use simple and common terms for field names. Avoid industry-specific or company-specific jargon.

Important

DataV-Note cannot analyze composite tables or irregularly formatted data, such as:

Tables with multiple data areas.
Tables that contain complex styles, such as merged cells, graphic elements, or conditional formatting (such as a SUM function).
Tables that contain empty rows or columns. Empty rows or columns cannot be analyzed.

The following are examples of tables.

Go to the project editing page.
1. Log on to the DataV-Note console.
2. On the All Projects > All tab, hover over the target project and click Edit to go to the project editing page.
Import the data.
In the Datasets > File Datasets folder in the navigation pane on the left, click the icon and follow the on-screen instructions to upload the file.
(Optional) You can make further edits.
After a CSV or Excel file is uploaded, the platform automatically parses it. You can then change the field types, field names, and the starting row for data processing. You can also click the icon next to the corresponding file in the File Dataset directory on the left and select Edit.
Note
- If the original field is a date type, you cannot change its field type.
- You can import Excel files that contain multiple sheets. After the import, you can create SQL queries directly based on a sheet. However, you cannot directly edit a sheet. To edit a sheet, you must modify the original Excel file.

After you import the file, you can perform SQL analysis on the data.