read-csv.js

const request = require('request'),
    fs = require('fs'),
    path = require('path'),
    pathRead = 'http://www.inmetro.gov.br/da/registro/LAMPADAS_LED_COM_DISPOSITIVO_INTEGRADO_A_BASE.csv',
    pathWrite = 'LAMPADAS_LED_COM_DISPOSITIVO_INTEGRADO_A_BASE.csv'


const downloadCsv = async (pathRead, pathWrite) => {
    await request(pathRead).on('end', (err, data) => {
        console.log('=> Download concluído')

        fs.readFile(pathWrite, {encoding: 'utf8'}, (err, data) => {
           readCsv(data, console.log)
        })
    }).pipe(fs.createWriteStream(pathWrite, {encoding: 'utf8'}))
}

const readCsv = (buffer, cb) => {
    const result = []
    const lines = buffer.split("\n")
    const firstLine = lines.shift()
    const header = firstLine.split(';')

    result.push(lines.map(item => {
        const fields = item.split(';')
        const line = {}
        const lineformated = header.map((item, a) =>{
            line[item] = fields[a]
            return line
        })
        return lineformated
    }))
    cb(result)
}

downloadCsv(pathRead, pathWrite)