# google-sheet-parser-web

> Parses a Google sheets spreadsheet if it follows a basic format of equally structured rows that start with a heading row

Latest version **1.3.1** (published 2020-01-21) · ISC license · 0 weekly downloads

## Install

```sh
npm install google-sheet-parser-web
pnpm add google-sheet-parser-web
yarn add google-sheet-parser-web
bun add google-sheet-parser-web
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.3.1 |
| Published | 2020-01-21 |
| First published | 2020-01-14 |
| Weekly downloads | 0 |
| License | ISC |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 5 |
| Unpacked size | 7.9 KB |
| Known vulnerabilities | 0 (+25 in 1 direct dependencies) |
| Install scripts | no |
| Maintainers | arcadegandalf |

## Links

- npm: https://www.npmjs.com/package/google-sheet-parser-web
- npm.io page: https://npm.io/package/google-sheet-parser-web

## Dependencies (5)

- [axios](https://npm.io/package/axios.md) ^0.19.1
- [@babel/cli](https://npm.io/package/@babel/cli.md) ^7.8.3
- [@babel/core](https://npm.io/package/@babel/core.md) ^7.8.3
- [@babel/preset-env](https://npm.io/package/@babel/preset-env.md) ^7.8.3
- [@babel/plugin-proposal-class-properties](https://npm.io/package/@babel/plugin-proposal-class-properties.md) ^7.8.3

## Recent versions

- 1.3.1 (latest) — 2020-01-21
- 1.3.0 — 2020-01-20
- 1.2.1 — 2020-01-15
- 1.2.0 — 2020-01-15
- 1.1.1 — 2020-01-14
- 1.1.0 — 2020-01-14

## README

# google-sheets-parser-web

Parses a Google sheets spreadsheet if it follows a basic format of equally structured rows that start with a heading row

e.g. A spreadsheet with the following structure

| User | dateStarted | Role       |
| ---- | ----------- | ---------- |
| John | 22-01-1999  | Manager    |
| Bob  | 17-08-2005  | Supervisor |
| Joe  | 03-12-2008  | Clerk      |

will be parsed into the following JSON

```JSON
[
  {
    "user": "John",
    "dateStarted": "22-01-1999",
    "role": "Manager"
  },
  {
    "user": "Bob",
    "dateStarted": "17-08-2005",
    "role": "Supervisor"
  },
  {
    "user": "Joe",
    "dateStarted": "03-12-2008",
    "role": "Clerk"
  }
]
```

## Usage

```
import parseGoogleSheet from 'google-sheet-parser-web';

const parsedData = await parseGoogleSheet(mySheetUrl);
```

---
_Source: https://npm.io/package/google-sheet-parser-web · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._