Exporting data

With Builder, you can export your map data in multiple file formats: CSV, GeoJSON, GeoPackage, GeoParquet, KML and Shapefile. This lets you take a filtered dataset straight into the tools you already use without any manual conversion. This functionality respects all the filters you set using the feature selection tool, widgets, or SQL parameters, and the exported file includes detailed attributes and, if applicable, a geometry column.

Configuring what can be exported

As an Editor, you control which data can be exported from your map and how:

• Exportable sources: Choose which data sources are eligible for export. This includes data sources that power widgets or SQL parameters but have no visible layer, which can now be exported too.

• Exportable columns: For each eligible source, whitelist the specific columns that can be exported, so sensitive attributes never leave your data warehouse.

• Available formats: For each eligible source, select which file formats are available for export. You can enable multiple formats per source, and your users will pick one format per export. Sources without a geometry column can only be exported as CSV or GeoParquet (written as a plain Parquet file).

Exporting data as an Editor

The export viewport data button is located in the three dots, at the right top corner. It should be enabled as long as there are exportable data sources in Builder.

How to export:

1. Click the 'Export data' button. This considers the current viewport extent and any applied filters.

2. In the export window, select the data source(s) you wish to export and, for each, the file format.

3. Each selected source generates a job in the activity panel. You can monitor export progress here while continuing your work.

4. Once an export job is complete, click on it in the activity panel to download the file(s).

Bucket considerations

For CARTO Cloud, CARTO automatically manages buckets and data exports. Be aware that for exports from Snowflake and Redshift sources, the AWS cluster needs to match the organization's CARTO Cloud region. Check your CARTO Cloud region in Settings.

For Self-Hosted deployments, a bucket owned by the customer needs to be configured. Please refer to this documentation for more information.

Enabling export for Viewers

To allow viewers of your map to export data:

1. Navigate to the 'Map settings for viewers' button located next to the 'Preview' button.

2. Turn on 'Export viewport data', to enable viewers using the export viewport data functionality.

3. Publish your changes.

Exporting data as Viewer

Viewers can export data following these steps:

1. Click the export icon located at the top left corner.

2. Choose the data source(s) to download and the file format from the modal window.

3. Each source's export creates a job for tracking. Monitor the progress in the dedicated section.

4. Upon completion, click on the export job and download the file(s).

Export limitations

• Spatial Index data sources (H3, Quadbin) can only be exported as CSV or Parquet.

• When exporting to Shapefile, the export is aborted if the estimated result is larger than 2 GB.

• Pre-generated tileset and raster data sources don’t support export.

Admins can disable exporting data from Builder maps for the whole organization from the Governance settings.