csv2xlsx

README

CSV2XLSX

Finally: a simple, single file executable, no runtime libs command line tool to convert a CSV file to XLSX. And you may even select line and column ranges. :-)

This programm has been created due to an internal requirement for a Bash shell script. After searching the web I found out that even in 2017 there is no simple, binary executable that does not need any runtime, virtual machine or whatever. All you need is a compiler for the Go programming language. If you do not want to compile the source and you decide to trust me (no warranty whatsoever, see the LICENSE file), you may download the binary.

Here are the SHA-256 checksums for the latest binaries:

1eac6529baea280aecedfb2dd225270bb7c8358f39485f1d4ec922bc6244bc8d  csv2xlsx_386.exe
7e4266fdfa7bae89f7e1c587a652e41fff133ead8f9eb485279745b46a388943  csv2xlsx_amd64.exe
5839d5c3ca8c1ddf39032ecb474d9a20a4f5c7dc03d3dbd0f33878ea0ae267df  csv2xlsx_linux_386
6ca329223d2367b57a76e566957ccbaa73f5b4223d58e3f46da1b353322badfa  csv2xlsx_linux_amd64
68bf6b0b9dd58270f357966fd06dd60b2f7bc6de05d20232a714ee2afcf6c9bb  csv2xlsx_osx

Usage

You execute the program from the command prompt of your operating system.

Ths most basic use case is csv2xlsx --infile test.csv --outfile result.xlsx, where you take an input CSV file in UTF-8 and write out the .xslx file under a new file name.

To list all available options, start csv2xlsx with the option --help.

To list all supported encodings, execute csv2xlsx with the option --listencodings

There is no difference if you use one or two hyphens before an option (-infile is the same as --infile)

Default column and row separators

Please note that the default column separator is the pipe char (|) and the default row separator is the newline char (\n). The tools came into existence to solve a problem for me, so this is the default you will have to live with or use the --colsep and --rowsep parameters. ;-)

Source

This tool fulfills a special requirement and I will extend its functionality, if need arises. As I found out there are lots of people looking for such a tool, I decided to make it publicly available. I am in the process of learning Go and therefore I am sure there are much better, more Go-idiomatic ways to achieve this functionality. If you have feedback on how to improve the code or want to contribute, please do not hesitate to do so. I'd really like to improve my GO skills and learn things. As my spare time for coding is limited to some hours around midnight a week, so please have some patience with my answers. I am still amazed what you can accomplish within such a small tool in terms of making the admin part of my life easier. :-)