- 23 Jul 2021
- 1 Minute to read
Data file formats
- Updated on 23 Jul 2021
- 1 Minute to read
Mozenda supports the following data formats:
CSV is an acronym for Comma Separated Values, meaning it is a plain text format in which values are separated by commas. It is a widely-supported data format used for tabular data and supported by all major spreadsheets, such as Microsoft Excel and Google Sheets.
Mozenda lets you import data in CSV format into a collection and publish and export data in CSV format from the Web Console.
TSV is an acronym for Tab Separated Values, meaning it is a plain text format in which values are separated by tabs. TSV is a widely-supported data format for tabular data, for example a spreadsheet data or database table. It is often used when moving data between spreadsheets.
Mozenda can publish and export collection data in TSV format.
XML is an acronym for eXtensible Markup Language, meaning it is a markup language like HTML. It presents structured information in a text-based format (with tags and attributes) that is human and machine-readable. XML is designed to store and transfer data.
Mozenda lets you publish and export collection data in XML format. The Mozenda REST API also returns information in XML format by default.
Mozenda lets you publish or export data from the Web Console in JSON format. The Mozenda REST API also returns information in JSON format by default.
.xlsx file format is a Microsoft Excel Open XML Format Spreadsheet file. It is a format created by Microsoft for Excel and other spreadsheet grid-editing applications.
Mozenda lets you publish and export collection data in XLSX format.
The following are the specifications that our file formats implement:
CSV - IETF RFC 4180
TSV - IANA text/tab-separated-values MIME type
See also http://jkorpela.fi/TSV.html
XML - World Wide Web Consortium XML 1.0, 5th Edition
JSON - IETF RFC 8259
XLSX - Excel (.xlsx) Extensions to the Office Open XML SpreadsheetML File Format