%20(PRIVATE).png?height=120&name=Logo%20(transparent%20background,%20red%20emblem,%20red%20text,%20tagline%20NOT%20included)%20(PRIVATE).png)
What are the supported document formats for templates and data
Templates
The supported template formats are Microsoft Word, specifically in DOC or DOCX file types. These formats are widely used and compatible with various versions of Microsoft Word, ensuring that users can easily create, edit, and share documents without compatibility issues. The DOC format is the older version, while DOCX is the more modern format that offers improved features such as better data management and enhanced file compression.
DOCX is the preferred format, as it has better font management and lower footprint.
If you need to use a specific font, that is not widely distributed, please make sure you use the "Embed fonts in the file", under Options > Save:
Data
The supported formats for data are as follows:
- XML (eXtensible Markup Language): XML is a versatile and widely used format for structured data. It allows for the representation of complex data structures through a hierarchical format, making it easy to exchange data across different systems. XML is particularly beneficial for dynamic tables, as it supports nested nodes and objects, providing greater flexibility in data representation.
- XLSX (Microsoft Excel Open XML Spreadsheet): XLSX is the file format used by Microsoft Excel for spreadsheets. It is capable of storing large volumes of data and supports a range of features including formulas, charts, and pivot tables. This format is ideal for users who require advanced data manipulation and analysis capabilities.
- JSON (JavaScript Object Notation) (Work In Progress): JSON is a lightweight data interchange format that is easy for humans to read and write, and easy for machines to parse and generate. It is particularly popular in web applications for transmitting data between a server and a web client. Currently, support for JSON is a work in progress, but it is expected to offer dynamic table functionality similar to XML, thanks to its ability to handle nested objects.
- CSV (Comma-Separated Values) (Work In Progress): CSV is a simple file format used to store tabular data, such as spreadsheets or databases. Each line in a CSV file corresponds to a row in the table, and each value is separated by a comma. While CSV is widely supported and easy to use, it does not inherently support complex data structures. Like JSON, support for CSV is currently a work in progress.
Dynamic tables are only supported on XML and JSON formats, due to the need for nested nodes and objects to effectively represent complex data relationships.