(Node.js) Write utf-8 CSV Compatible with Excel

See more CSV Examples

A CSV containing non-English characters that is saved using the utf-8 character encoding must include a BOM (also known as a preamble) if it is to be correctly loaded into Excel. See https://en.wikipedia.org/wiki/Byte_order_mark

This example shows how to save the CSV to a file using utf-8 with a BOM.

Note: This example requires Chilkat v9.5.0.93 or later.

Install Chilkat for Node.js and Electron using npm at Chilkat npm packages for Node.js Chilkat npm packages for Electron on Windows, Linux, MacOSX, and ARM

var os = require('os');
if (os.platform() == 'win32') {  
    if (os.arch() == 'ia32') {
        var chilkat = require('@chilkat/ck-node21-win-ia32');
    } else {
        var chilkat = require('@chilkat/ck-node21-win64'); 
    }
} else if (os.platform() == 'linux') {
    if (os.arch() == 'arm') {
        var chilkat = require('@chilkat/ck-node21-arm');
    } else if (os.arch() == 'x86') {
        var chilkat = require('@chilkat/ck-node21-linux32');
    } else {
        var chilkat = require('@chilkat/ck-node21-linux64');
    }
} else if (os.platform() == 'darwin') {
    if (os.arch() == 'arm64') {
        var chilkat = require('@chilkat/ck-node21-mac-m1');
    } else {
        var chilkat = require('@chilkat/ck-node21-macosx');
    }
}

function chilkatExample() {

    // This example program loads a file (japanese.csv)
    // that contains this content:
    // 
    // year,color,country,food
    // 2001,red,France,cheese
    // 2005,blue,"United States",hamburger
    // 2008,green,Italy,pasta
    // 1998,orange,Japan,sushi
    // 2010,silver,"",""
    // 

    var csv = new chilkat.Csv();
    csv.HasColumnNames = true;
    var success = csv.LoadFile2("qa_data/csv/test.csv","utf-8");
    if (success !== true) {
        console.log(csv.LastErrorText);
        return;
    }

    // To save the CSV using utf-8 with a BOM/preamble, 
    // add "EMIT_BOM" to the UncommonOptions.
    // (This feature was added in Chilkat v9.5.0.93)

    csv.UncommonOptions = "EMIT_BOM";
    success = csv.SaveFile2("qa_output/test.csv","utf-8");
    if (success !== true) {
        console.log(csv.LastErrorText);
        return;
    }

    console.log("OK, try to load the CSV in Excel to see if the non-English chars are correct.");

}

chilkatExample();