Import CSV

Instructions for use

CSV (i.e., Comma-Separated Values) is a file that records data in text format, usually with commas as separators. This format is often used for data exchange between different programs. The Import CSV tool can import CSV files as attribute tables or spatial data.

Parameter description

parameter name Parameter Description Parameter Type
Select File Enter the path information of the data to be imported. String
Charset Select the character set type of the file to import, default is ASCII. Charset
Result Datasource Specify the data source where the result dataset is stored. Datasource
Result Dataset The name of the specified result dataset. String
Import Mode Set the import mode when a dataset with the same name exists. ImportMode
Separator Used to set the separator in the CSV file, default is English comma (,). Other optional separators include period (.), tab (Tab), and space. It also supports user-defined characters recognizable by text (including Chinese characters). String
1st Row as Header Set whether the first row of the source file is the field name. By default, it is checked, meaning the field names after import are the values from the first row of the source file. If unchecked, the field names after import will be col0, col1, col2, ..., colN-1. Boolean
Auto Length Set whether to automatically calculate field length during import. If checked, it reads the longest field in each column and adds 10 as the field length for that column. If unchecked, the field length defaults to 255 after import. Checking this option may affect import speed when importing large amounts of data. Boolean
Import Spatial Data Used to set whether to import the data as a spatial dataset or attribute data. Supports obtaining spatial information by specifying a WKT string field or coordinate fields. Boolean
WKT String Field Obtain spatial information by specifying a WKT string field. Boolean
Coordinate Fields Obtain spatial information by specifying coordinate fields. Specify fields for X, Y, or X, Y, Z coordinates. If conditions are met, it generates point or 3D point datasets. String

Output Result

parameter name Parameter Description Parameter Type
Result Dataset Result dataset. DatasetVector