Golang : Convert CSV data to JSON format and save to file
Need to load a CSV data file and save it to JSON encoded file or stream it out ... like to a http service ? This tutorial will cover just that :
The Golang code below will first read this data.csv data file :
Adam,36,CEO
Eve,34,CFO
Mike,38,COO
and output to data.json file
[
{"Name":"Adam","Age":36,"Job":"CEO"},
{"Name":"Eve","Age":34,"Job":"CFO"},
{"Name":"Mike","Age":38,"Job":"COO"}
]
csv2json.go
package main
import (
"encoding/csv"
"encoding/json"
"fmt"
"os"
"strconv"
)
type Employee struct {
Name string
Age int
Job string
}
func main() {
// read data from CSV file
csvFile, err := os.Open("./data.csv")
if err != nil {
fmt.Println(err)
}
defer csvFile.Close()
reader := csv.NewReader(csvFile)
reader.FieldsPerRecord = -1
csvData, err := reader.ReadAll()
if err != nil {
fmt.Println(err)
os.Exit(1)
}
var oneRecord Employee
var allRecords []Employee
for _, each := range csvData {
oneRecord.Name = each[0]
oneRecord.Age, _ = strconv.Atoi(each[1]) // need to cast integer to string
oneRecord.Job = each[2]
allRecords = append(allRecords, oneRecord)
}
jsondata, err := json.Marshal(allRecords) // convert to JSON
if err != nil {
fmt.Println(err)
os.Exit(1)
}
// sanity check
// NOTE : You can stream the JSON data to http service as well instead of saving to file
fmt.Println(string(jsondata))
// now write to JSON file
jsonFile, err := os.Create("./data.json")
if err != nil {
fmt.Println(err)
}
defer jsonFile.Close()
jsonFile.Write(jsondata)
jsonFile.Close()
}
Output :
[{"Name":"Adam","Age":36,"Job":"CEO"},{"Name":"Eve","Age":34,"Job":"CFO"},{"Name":"Mike","Age":38,"Job":"COO"}]
References :
https://www.socketloop.com/references/golang-encoding-json-marshal-function-example
See also : Convert JSON to CSV in Golang
By Adam Ng
IF you gain some knowledge or the information here solved your programming problem. Please consider donating to the less fortunate or some charities that you like. Apart from donation, planting trees, volunteering or reducing your carbon footprint will be great too.
Advertisement
Tutorials
+18.4k Golang : Convert(cast) bytes.Buffer or bytes.NewBuffer type to io.Reader
+11.1k Golang : Get month name from date example
+4.6k PHP : Convert CSV to JSON with YQL example
+14.8k Golang : Generate universally unique identifier(UUID) example
+7.5k PHP : How to parse ElasticSearch JSON ?
+16.6k Golang : Put UTF8 text on OpenCV video capture image frame
+13.5k Golang : Get URI segments by number and assign as variable example
+9k Golang : Simple Jawi(Yawi) to Rumi(Latin/Romanize) converter
+11.1k Golang : List running EC2 instances and descriptions
+6.4k Golang : Create zip/ePub file without compression(use Store algorithm)
+5.3k Golang : Detect face in uploaded photo like GPlus
+7k Golang : Load DSA public key from file example