rsv icon indicating copy to clipboard operation
rsv copied to clipboard

date fields converting to XLSX

Open Bodo-E opened this issue 1 month ago • 2 comments

Thanks for this awesome (and super fast) tool! When I convert data from CSV to XLSX, I’d like the date fields from the CSV (e.g. 01.01.2026) to show up as actual date fields in Excel (e.g. 46023). Is there a way to make that happen?

Bodo-E avatar Nov 06 '25 16:11 Bodo-E

Do you mean convert CSV str field to date series number in Excel? I can add the functionality. But I highly recommend you trying other data manipulating tools like Polars for flexibility. It is written in Rust and super fast. And it provides tons of flexibility.

And for the comment, which one is your use case: rsv select data.csv | rsv to data.xlsx or rsv out data.xlsx data.csv

ribbondz avatar Nov 07 '25 03:11 ribbondz

This is my case: rsv to data.xlsx data.csv

That would be really nice if you could extend it with this feature. Then your tool would be perfect for me. But out of curiosity: I don’t know Polars. I need a Windows command-line tool. Would converting CSV to Excel also be possible with Polars?

Bodo-E avatar Nov 10 '25 07:11 Bodo-E