Feature Request: Extend Import Functionality to Support Additional Spreadsheet Formats (e.g. ODS)
Opened this issue · 1 comments
Describe the problem to be solved
Grist currently allows users to import files to either create a new document or add data to an existing document. The supported file formats include Excel, CSV, JSON, tab‐separated files, and files from Google Drive. For instance, to create a new document, users are instructed to click the “Ajouter Nouveau” button on the homepage and select “Importer un document”. Similarly, to add data to an existing document, the user may click “Ajouter Nouveau” and then “Importer depuis un fichier”, with the option in the preview dialogue to choose an existing Grist table as the destination. Users can also import these formats from a URL by selecting “Importer depuis une URL”.
However, there remains a notable omission for those who utilise open source office suites such as LibreOffice, as the ODS (OpenDocument Spreadsheet) format is not currently supported. This gap forces users to convert their data into one of the supported formats, which is both inconvenient and potentially error‐prone.
Describe the solution you would like
I propose that the import functionality be extended to support the ODS format. The enhancement should allow ODS files to be imported seamlessly in the same manner as the currently supported formats—whether when creating a new Grist document or when adding data to an existing one. Ideally, the user experience should mirror the present process, permitting imports both from local files and via URL. This addition would not only improve the accessibility of Grist for users of open source office suites but also further broaden its versatility and appeal.
Thank you for considering this feature request.
Hello, came here to suggest the same.
All my currently spreadsheets are authored either in LibreOffice on OnlyOffice in the standard OpenDocument
Spreadsheet (ODS) format. I’m considering switching to Grist, but won’t be able smoothly if there’s no way to import them.
For an freely licensed app, it’s also inconsistent not to support the freely licensed spreadsheet format, which is standardised by OASIS and ISO/IEC.
https://en.wikipedia.org/wiki/OpenDocument
https://en.wikipedia.org/wiki/OpenDocument_technical_specification
https://www.oasis-open.org/2021/06/16/opendocument-v1-3-oasis-standard-published/
Additionally to importing, there could be an “Download as ODS” option as there is for XLSX and CSV.