DEV Community

Bobo
Bobo

Posted on

How to Convert Excel Files to CSV and JSON Programmatically

#javascript #node #csv #excel

How to Convert Excel Files to CSV and JSON Programmatically

Converting between formats is a common task. Here's the CLI way.

Excel to CSV 

csv-toolkit-pro convert sales.xlsx --to csv -o sales.csv
csv-toolkit-pro convert *.xlsx --to csv --output-dir ./csv/
Enter fullscreen mode Exit fullscreen mode

Excel to JSON 

csv-toolkit-pro convert inventory.xlsx --to json -o inventory.json
Enter fullscreen mode Exit fullscreen mode

CSV to JSON 

csv-toolkit-pro convert data.csv --to json --pretty -o data.json
Enter fullscreen mode Exit fullscreen mode

Batch Conversion 

# Convert all Excel files in directory
csv-toolkit-pro convert ./reports/ --to csv --output-dir ./clean/
Enter fullscreen mode Exit fullscreen mode 
npm install -g csv-toolkit-pro
Enter fullscreen mode Exit fullscreen mode

Visit us | Get free DigitalOcean credit | CLI Toolkit Pro $9.99

Top comments (0)