How to Convert CSV to JSON: Spreadsheet to Code

From Spreadsheets to Web APIs

To convert CSV to JSON, map the first spreadsheet row to object keys and each following row to a JSON object. You can do this online in your browser or with JavaScript for an API, import, or application workflow. CSV formats are fantastic for quick manual entry in Excel, while JSON is easier to use in modern web browsers and backend services.

---

Step-by-Step Conversion Logic

To parse CSV strings accurately, simple splitting on commas (e.g., text.split(",")) is usually insufficient. Standard formats like RFC 4180 allow cells to contain internal commas if the cell is wrapped in quotes.

Step 1: Detect Headers

The very first row of your CSV spreadsheet is treated as the JSON object’s properties:

id,product,price

Step 2: Extract Data Rows

For every subsequent line, loop through the cells and assign them to their corresponding header keys:

101,Keyboard,49.99

JSON Output Mapping:

{
  "id": "101",
  "product": "Keyboard",
  "price": "49.99"
}

Step 3: Parse Types (Optional Cast)

A smart converter checks if string items can be cast into real JavaScript types. "49.99" becomes number 49.99, and "true" becomes boolean true.

---

Method 1: Using Online Parsing Utilities

If you need to process columns instantly with absolute privacy, use our offline-ready CSV to JSON Converter.

1. Paste your sheet values or raw CSV strings.
2. Toggle Parse Numbers & Booleans to enable automated type-casting.
3. Click Convert to JSON.

---

Method 2: Parsing CSV in JavaScript (Pure JS Engine)

Here is a simple state-machine chunk to loop lines without external dependencies:

function csvToJSON(csvText) {
  const lines = csvText.trim().split('\n');
  const headers = lines[0].split(',');
  
  return lines.slice(1).map(line => {
    const values = line.split(',');
    const obj = {};
    headers.forEach((header, index) => {
      obj[header.trim()] = values[index]?.trim() || null;
    });
    return obj;
  });
}

---

Frequently Asked Questions

Can CSV cells contain nested rows?

No, CSV lists are inherently flat. If you need nested object mappings, you must run custom transformations or mapping post-processors in JavaScript after the initial extraction.