xlsx2csv

KO | EN

gitlite — search

#python #react #ai #llm #go #machine-learning #deep-learning #linux #macos #nodejs #java #windows #awesome-list #security

(★ 17)

Excel XLSX to CSV file converter. Node.js library and command line utility. Lightweight.

xlsx2csv Latest Version Download

Download Latest Version (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

## Introduction

Excel XLSX to CSV file converter. Node.js library and command line utility. Lightweight.

## Getting Started

Install the package:
```bash
git clone https://github.com/papnkukn/xlsx2csv && cd xlsx2csv
npm install -g .
```

Convert the document:
```bash
xlsx2csv --verbose --sheet Sample path/to/sample.xlsx sample.csv
```

## Command Line

```
Usage:
  xlsx2csv [options] <input.xlsx> <output.csv>

Options:
  --force             Force overwrite file
  --data [type]       Data type to export: formula, value or display
  --sheet [name]      Sheet name to export
  --range [A1:C3]     Range to export
  --separator [char]  CSV column separator, e.g. '\t'
  --line-end [char]   End of line char(s), e.g. '\r\n'
  --help              Print this message
  --verbose           Enable detailed logging
  --version           Print version number

Examples:
  xlsx2csv --version
  xlsx2csv --verbose --range A1:M30 --separator , file.xlsx
  xlsx2csv --data formula --sheet Sample file.xlsx file.csv
```

## Using as library

```javascript
var xlsx2csv = require('node-xlsx2csv');
var options = { verbose: true, sheet: "Sample" };
xlsx2csv('path/to/sample.xlsx', options, function(error, result) {
  if (error) return console.error(error);
  console.log(result);
});
```

### Options

| Name      | Type   | Description |
|-----------|--------|-------------|
| verbose   | bool   | Detailed output while processing |
| data      | string | Type of data to export: "formula" to export cell formula, "value" to prefer cell value, or "display" for formatted value |
| sheet     | string | required, worksheet name to export, e.g. "Sample" |
| range     | string | optional, capture cell range, e.g. "A1:M30" |
| separator | string | CSV column separator, e.g. "," or ";" or "\t", default: "," |
| lineEnd   | string | end of line char(s), e.g. "\r\n" or "\r" or "\n", default: "\n" |

<!--
## Example of output

```csv
xlsx2csv,,
1234,,
1,,"a, b, and c"
10,,"a \"quoted\" string"
99%,,
0.5625,,
```
-->

xlsx2csv

xlsx2csv Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

xlsx2csv

xlsx2csv Latest Version Download

Today's picks

Was this content helpful?

Recent Feedback

Download README