XLSX to CSV

A simple script to convert .xlsx file to .csv file, with the ability to filter / rename columns.

Introduction

A simple script to convert .xlsx file to .csv file, with the ability to filter / rename columns.

Install

To install, run the following command in your terminal:

npm install xlsx-to-csv-ts
Copy

Usage

Import

To use xlsx-to-csv-ts in your Node.js project, you need to import it as follows:

import { convertXlsxToCsv } from "xlsx-to-csv-ts";
Copy

Example

const result = await convertXlsxToCsv({
  inputFile: "./public/sample.xlsx",
  outputFilename: "sample-filtered",
  outputDir: "./public/",
  filter: { Segment: "segment", Country: "country" },	// Format: { "original column": "renamed column", ... }
});

console.log(result.outputPath)
Copy