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 about extending the file formats supported.
Supported file formats¶
The following table lists the supported formats. Click the link on each connector name to know more about their available configuration 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 connector|
|Shapefile||.zip||A zip archive containing the following files: <NAME>.shp, <NAME>.shx, <NAME>.dbf and <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|
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 (UTF-8 encoding for filenames is recommended)