sheet-convert

Converts a Google Sheet to a JSON array, or vice versa.

Table of contents

• sheet-convert
  • Table of contents
  • Installation
  • Importing
  • Usage
    • Generating JSON from a Sheet
    • Generating a Sheet from JSON
    • Output

Installation

To install the library, run:

$ npm install sheet-convert

or with JSDelivr:

<script src="https://cdn.jsdelivr.net/npm/sheet-convert@latest/file"></script>

Importing

With require:

const { Sheet, from } = require("sheet-convert");

With import:

import { Sheet, from } from "sheet-convert";

Usage

Generating JSON from a Sheet

import Parser from "sheet-convert";

const sheet = new Parser.Sheet([id]); // If getting the main spreadsheet page
const sheet = new Parser.Sheet([id], [subsheet]) // If getting a specific sheet

const info = await sheet.fetch() // Array of JSON objects

Generating a Sheet from JSON

import Parser from "sheet-convert";

const sheet = Parser.from([{a: 1, b: 2}, {b: 3, c: 4}]) // Full JSON
const sheet = Parser.from([{a: 1, b: 2}, {b: 3, c: 4}], ['c']) // JSON excluding "c"

Output

Full JSON

| a | b | c | | - | - | - | | 1 | 2 || || 3 | 4 |

Excluding "c"

| a | b | | - | - | | 1 | 2 | || 3 |