excel2json-go

Convert .xlsx or .csv to JSON

Credit

• Code originally from excel2json by FerdinaKusumah
• Adapted to my own preference instead:
  • Set up a proper project directory where the main executable packages are in the cmd folder and the helper functions are in pkg folder
  • Set file path and sheet name in command argument
  • Print array of map instead of map line-by-line
  • Removed remote URL functionality (I do not use it)

Usage

Suppose you have Excel table like this

and you need to convert it to this

[{
    "Profit": "-213.25",
    "ShippingCost": "35",
    "UnitPrice": "38.94"
}, {
    "Profit": "457.81",
    "ShippingCost": "68.02",
    "UnitPrice": "208.16"
}, {
    "Profit": "46.71",
    "ShippingCost": "2.99",
    "UnitPrice": "8.69"
}]

and you have an Excel .xlsx, you should do

go build ./cmd/xlsxlocal

./xlsxlocal <path to .xlsx file> <.xlsx sheet name, default is the first sheet>
eg.
./xlsxlocal ./samplefiles/iris_dataset.xlsx

and you have an Excel .csv, you should do

go build ./cmd/csvlocal

./csvlocal <path to .csv file>
eg.
./csvlocal ./samplefiles/iris_dataset.csv