Spreadsheets Anywhere is a software tool that allows users to create and edit spreadsheets on any device with internet access.

Spreadsheets Anywhere is a cloud-based software tool that enables users to create and edit spreadsheets on any device with internet access, including desktop computers, laptops, tablets, and smartphones. The tool offers a range of features, including the ability to import and export data, create charts and graphs, and collaborate with others in real-time. Users can also customize their spreadsheets with a variety of formatting options and formulas, and can access their files from anywhere with an internet connection. With Spreadsheets Anywhere, users can streamline their workflow and increase productivity by eliminating the need for multiple software programs or devices.

Prerequisites

To obtain the Tables required setting for connecting to Spreadsheets Anywhere, you need to have access to the spreadsheet that you want to connect to. Once you have access, you can identify the name of the table or tables that you want to connect to. The table name should be entered in the appropriate field when setting up the connection to Spreadsheets Anywhere.

Enable BATCH mode for large syncs (optional)

Instead of one record message per row, the tap can buffer rows and write them to Arrow IPC files, then emit batch messages that reference them - a compatible target loads these files directly instead of processing records one at a time. Set Batch Format, Batch Root Directory and Batch Size to enable it. Caveats: arrow is the only batch encoding this tap supports; only a target that advertises the batch capability processes batch messages, so leave these settings unset for any other target. Enabling BATCH mode does not otherwise change the schema seen downstream - add "arrow_native_timestamps": false to a table entry in Tables to keep its date-time columns as strings instead of native Arrow timestamps (the default), for a table with non-ISO-8601 date formatting.

Settings

Tables

A setting in Spreadsheets Anywhere that allows users to select which tables they want to connect to and use in their application.

Batch Format

Format of the batch files. This tap only supports Arrow.

Batch Size

Number of rows per BATCH message file. Defaults to 100,000 if not specified.