Supported formats

Note

File formats support can be extended to match specific requirements (for instance, to support a complex XML or a non standard flat file format). Contact your local support team if you need more information on file formats support extension.

Supported file formats

The following table lists the supported format and describes configuration options for each format:

Format Extensions Description Options
CSV .csv, .tsv, .txt, .dat The classic Coma Separated Value file. CSV connector
Microsoft Excel .xls, .xlsx   Spreadsheet connector
OpenDocument SpreadSheet .ods   Spreadsheet connector
JSON .json Simple JSON documents are supported. The platform lets you choose the root path (path to the table of elements to be considered as rows) and the properties path (path to the dictionary holding the list of fields for an element). JSON connectors
GeoJSON .json, .geojson   GeoJSON connector
KML/KMZ .kml, .kmz   KML and KMZ connector
Shapefile .zip A zip archive containing at least the following files: <NAME>.shp, <NAME>.dbf, <NAME>.prj ShapeFile connector
MapInfo .zip A zip archive containing either <NAME>.mid and <NAME>.mif files or <NAME>.map, <NAME>.tab, <NAME>.id and <NAME>.dat MapInfo connector
OpenStreetMap .osm   OSM connector
XML .xml   XML connector

Supported compressed file formats

OpenDataSoft also supports compressed file formats. These are useful to save space, since files added to a dataset can’t be more than 240Mo. Compressed file formats can also be used in the platform to create a dataset with multiple files (see Creating a dataset with multiple files)

  • .zip
  • .bz2
  • .tar
  • .gz
  • .gzip
  • .tar.gr
  • .tgz
  • .tar.bz2