jsoma/tabletopArchived
Tabletop
Tabletop is a JavaScript library and data parser designed to retrieve data from public Google Sheets and convert it into structured JSON objects. It functions as a client-side tool for fetching remote spreadsheet data and transforming rows into lists of objects or arrays for use in web applications.
The library enables the use of Google Sheets as a lightweight database, allowing for dynamic content management where application data can be updated by editing a spreadsheet. It supports selective worksheet retrieval to limit the amount of transferred data and provides programmatic interfaces for sorting and filtering data on the remote server before it reaches the client.
Additional capabilities include the ability to run custom transformation functions on retrieved rows to modify values or compute new attributes. The tool also supports proxy request routing to redirect data requests through custom endpoints for caching or to manage origin restrictions.
Features
- Spreadsheet-to-JSON Parsers - Converts rows from public spreadsheets into structured JSON objects for use within web applications.
- Spreadsheet-to-JSON Converters - Fetches remote spreadsheet data and transforms rows into lists of objects or arrays.
- Google Sheets Manipulations - Integrates public Google Sheets to serve as a lightweight database for websites and applications.
- Read-Only Spreadsheet Clients - Retrieves data from remote spreadsheets and converts it into a structured format for application use.
- Spreadsheet Data Clients - Provides a programmatic interface for retrieving and sorting data from Google Sheets via HTTP.
- Spreadsheet-to-JSON Parsers - Converts public Google Sheets spreadsheets into structured JSON objects for web applications.
- Spreadsheet-Driven Content Management - Enables updating application content in real time by editing a Google Sheet instead of modifying code.
- HTTP Content Retrievers - Fetches raw spreadsheet content from remote URLs via asynchronous HTTP requests to use as data sources.
- Header-Based Object Mappers - Converts tabular row data into JavaScript objects by treating the first row as the key set.
- Row-to-Object Parsers - Converts flat spreadsheet cell lists into structured JSON objects based on selected output modes.
- Remote Data Fetching - Acts as a client-side utility for retrieving and parsing data from remote spreadsheet resources.
- Data Format Transformations - Provides options to return spreadsheet data as either a list of named objects or numbered arrays.
- Query Parameterization - Applies sorting and filtering by appending specific query parameters to the request sent to the spreadsheet host.
- Row-wise Transformations - Executes custom logic on individual rows to rename columns, calculate attributes, or convert data types.
- Server-Side Data Transformations - Filters and sorts spreadsheet data on the server side before it is transmitted to the client.
- Server-Side Filtering & Sorting - Orders retrieved rows by a specific column in ascending or descending order on the remote server.
- Post-Fetch Data Transformers - Allows running custom functions on retrieved rows to rename columns or compute new attributes.
