@aternus/csv-to-xlsx

Convert CSV files to XLSX (Excel 2007+ XML Format) files.

Written in JavaScript. Available for Node.js CLI and API.

Binaries are available for:

• Windows x64
• Linux x64
• macOS x64

Install with confidence 🛡️

Features

• Binaries: download and run via your OS's command-line utility
• Fast and Reliable
• Full UTF-8 support
• CSV Column detection
• Batch mode: convert a CSV folder to an XLSX folder
• Node.js CLI and API

Installation

npm install @aternus/csv-to-xlsx

Usage

Binaries

Download the executables from the latest release.

./csv-to-xlsx-linux -i "input-file-or-directory" -o "output-directory"

Make sure to ONLY use the binaries provided by the project, safe use of binaries (how to avoid viruses).

Node.js CLI

Type --help for a full list of options.

npx @aternus/csv-to-xlsx -i "input-file-or-directory" -o "output-directory"

Node.js API

const path = require('path');
const {convertCsvToXlsx} = require('@aternus/csv-to-xlsx');

let source = path.join(__dirname, 'report.csv');
let destination = path.join(__dirname, 'converted_report.xlsx');

try {
  convertCsvToXlsx(source, destination);
} catch (e) {
  console.error(e.toString());
}

Safe use of Binaries

One of the project's goals is to allow running the CSV to XLSX tool directly on your computer.

Create a directory, put the executable inside of it, create a csv folder for the CSVs and the xlsx folder will be populated with the converted files; plain and simple, you don't even have to use a terminal (CLI).

To achieve this goal, we pack all the code that makes this possible into a single file, called a binary. This binary has a couple of parts, a Node.js runtime and the source code of this tool that uses it.

Unfortunately, this causes some Antivirus programs to flag it as a Trojan. This is a known issue and should be fixed when Node.js ships with a built-in mode for generating single executable applications.

Until then, please make sure that you download binaries from the release page of csv-to-xlsx.

If you have doubts about the origin of your executable, you can check the sha256 of your executable against the one specified in the release assets.

Checking sha256 of a binary

macOS / Linux

shasum -a 256 ./csv-to-xlsx-macos

Windows:

certutil -hashfile .\csv-to-xlsx-win.exe SHA256

macOS: how to run csv-to-xlsx

csv-to-xlsx binary - macOS.webm

Windows: how to run csv-to-xlsx

csv-to-xlsx binary - windows.webm

License

Released under the MIT License - see LICENSE.md for details.