search

jgm / pandoc

Universal markup converter
https://pandoc.org
Other
34.9k stars 3.39k forks source link

csv to spreadsheet (excel or open document spreadsheet ) #7975

Closed dbojan closed 2 years ago

dbojan commented 2 years ago

Hi. Would it be possible to add spreadsheet output format (xlsx or ods), for csv files? Just csv data to simple xlsx table.

Thanks.

alerque commented 2 years ago

Why use Pandoc for this? Pandoc is a swiss army knife for documents, but spreadsheets are more akin to databases than documents. There are lots of command line utilities (in several languages, Python, C++, etc) that can convert CSV to XLS or ODS that have options for handling different data types, headers, sheets, formula expansion, etc. I don't think this can of worms belongs in Pandoc at all.

jgm commented 2 years ago

Since spreadsheet programs can all open CSV files (and save the results in other formats), this doesn't seem worth the trouble.

alerque commented 2 months ago

It does make me curious what the perceived need for this is coming from. It keeps coming up (e.g. #10165) and I really don't understand what the workflow is that people can't ingest CSV on one end, can't output XLSX on the other, and don't run across any of the existing tooling for handling data like this and reach for pandoc in the first place.