Show HN: Transform a CSV into a JSON and vice versa

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • jsonmatic

    ⚗️ Transform a CSV (spreadsheet) into a JSON.

  • Author here; some clarification. I use fingerprint to get the number of visits (instead of using something invasive like Google Analytics):

    https://github.com/erikmartinjordan/jsonmatic/blob/master/sr...

    I get the fingerprint as a UID (which is like a random number for me). I don't harvest any user's data. Code is open-source, you can verify what I'm saying if you wish.

  • csv2json

    Simple tool for converting CSVs to JSON

  • I wrote my own converter a few years ago, then ended up needing it again last week. It’s one of those things you don’t always need but it’s handy to have when you do. https://github.com/baltimore-sun-data/csv2json

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
  • miller

    Miller is like awk, sed, cut, join, and sort for name-indexed data such as CSV, TSV, and tabular JSON

  • ndjson.github.io

    Info Website for NDJSON

  • flatten-tool

    Tools for generating CSV and other flat versions of the structured data

  • json-toolkit

    "the best opensource converter I've found across the Internet" -- dene14

  • jq

    Discontinued Command-line JSON processor [Moved to: https://github.com/jqlang/jq] (by stedolan)

  • I don't consider myself much of a jq power user, but I am a huge admirer of its capabilities.

    [0] https://github.com/stedolan/jq/wiki/Cookbook#convert-a-csv-f...

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo
  • ndjson

    Streaming line delimited json parser + serializer

  • ndjson appears to be a fork of jsonlines with the addition of a spec (see https://github.com/ndjson/ndjson.github.io/issues/1)

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts