Import Data

Supported Data Formats

Maptable currently supports importing files in the following formats:

1.
CSV / XLSX (Excel)​

GeoJSON

If your data is in SHP format, you can convert it to GeoJSON using tools like Mapshaper

For large datasets, use Mapshaper to simplify the data, which can significantly improve loading speed and performance

3.
GPX​

4.
KML​

5.
Zipped versions of the above file types are also supported​

📌

Before importing data, ensure that your data file contains coordinate fields, latitude and longitude that meets the following requirements:​

1.
WKT format. For example: POINT (-107.099759 38.646155). These will be automatically recognized as coordinate fields.​

2.
Longitude and latitude. During import, Maptable will automatically infer longitude and latitude based on field names. Supported field names include: Longitude, Lon, Latitude, Lat, etc.​

Importing from Local Files

1.
Select the import file format and upload the file​

common.docs_name - LarkCCM_Docs_Menu_Image

Choose the import method

◦
Import as a new data table: This is the default option, which uploads the file and imports it as a new data table​

◦

Import into an existing data table: Upload the file and import it into an existing project data table. This is suitable for updating data records in existing projects. For details, see Append Data

3.
Field type settings ​

•
Automatic field type detection ​
◦
Maptable will automatically infer field types. In the settings popup, click the triangle to the right of the field to manually update the column's field type​

•
Primary column ​
◦
Used to identify each record, it cannot be deleted, moved, or hidden. Maptable will default to the first column in the data table as the primary column, but you can set another column as primary in the field settings​
◦
After import, the primary column will be frozen as the first column in the data table​

•

Select columns to upload

◦
In "Adjust Fields > Import Fields", you can customize which fields to upload​

Import Data​

Import Data