Flatsheet vs Sheetsu Comparison | StackShare

Overview

Flatsheet

Stacks1

Followers11

Votes0

Sheetsu

Stacks17

Followers91

Votes8

Flatsheet vs Sheetsu: What are the differences?

Developers describe Flatsheet as "Manage your content with custom fields with a friendly editor & a simple JSON API". Flatsheet is a tool for managing tabular data with a friendly editor and a simple JSON API. The editor allows the creation of rows and columns of data, similar to a spreadsheet. The JSON API exposes that data so it can be easily utilized by websites and applications. On the other hand, Sheetsu is detailed as "Turn a Google Spreadsheet into an API". Use spreadsheet as your database. Give data to your users the nice way, directly from the tool you know. Without bothering webdeveloper.

Flatsheet and Sheetsu can be categorized as "Spreadsheets as a Backend" tools.

Advice on Flatsheet, Sheetsu

DetStartups

Nov 11, 2019

Needs advice

I'm trying to set up an ideally "no- code" way to have a backend of 3 different tables and be able to find a value in table #3 (contains businesses & cities) by first finding a record in table #1 (7,000+ zip codes) that corresponds to a city (table #2 has the unique cities), and then finding which businesses are located in these cities ( in this specific, original zipcode lookup). And return the business and a description via an API to a front-end results page, which happens to be a WordPress page - but doesn't need to be. I've tried Airtable's API, AirPress (a finicky WordPress plugin for Airtable's API), and I've looked at Sheetsu and a similar spreadsheet as backend and a simple API. I run into the issue where they work fine when you just need to query 1 table, but when you need to use the result from that query in another query to a different table. I'm back in SQL land - where sure it could be done with SQLite - needing to probably create an intersection table or a JOIN and build an API off of that. Is there a way to accomplish what I want without going back to SQL queries and some API?

59.9k views59.9k

Comments

Detailed Comparison

Flatsheet	Sheetsu
Flatsheet is a tool for managing tabular data with a friendly editor and a simple JSON API. The editor allows the creation of rows and columns of data, similar to a spreadsheet. The JSON API exposes that data so it can be easily utilized by websites and applications.	Use spreadsheet as your database. Give data to your users the nice way, directly from the tool you know. Without bothering webdeveloper.
Statistics
Stacks 1	Stacks 17
Followers 11	Followers 91
Votes 0	Votes 8
Pros & Cons
No community feedback yet	Pros 8 Easy setup
Integrations
No integrations available	Ruby Python Google Sheets JavaScript HTML5

What are some alternatives to Flatsheet, Sheetsu?

Airtable

Working with Airtable is as fast and easy as editing a spreadsheet. But only Airtable is backed by the power of a full database, giving you rich features far beyond what a spreadsheet can offer.

Sheety

Power websites, apps, or whatever you like, all from a spreadsheet. Changes to your spreadsheet update your API in realtime.

Sheetlabs

Drag & drop your data, name your API and choose what data people can see - that's it. Documentation is created automatically.

sheet2api

Use any Google Sheets or Excel Online spreadsheet to power a fully-fledged API, no coding required.

Smartsheet

It is an intuitive online project management tool enabling teams to increase productivity using cloud, collaboration, & mobile technologies. It provides your organization with a powerful work platform that offers exceptional speed to business value

Glide

Pick a sheet, customize your app, share it with a link. Add your data to the sheet and share your custom app! Only pay for apps that need whitelabeling or store distribution.

Tables

It helps teams easily track & automate tasks, enabling them to save time and work smarter.

xlwings

Replace your VBA code with Python, a powerful yet easy-to-use programming language that is highly suited for numerical analysis. Supports Windows & Mac!

NocoDB

It is an open source Airtable alternative. It transforms your relational databases into a smart spreadsheet. Our app store allows you to connect to any cloud services like S3 for file storage and 3rd party apps like Slack, Twilio for business workflows.

Baserow.io

It is an open-source no-code database and Airtable alternative. Create your own database without technical experience. Our user friendly no-code tool gives you the powers of a developer without leaving your browser.