Excel via SFTP
Overview
Excel via SFTP enables secure, automated access to .xlsx files stored on a remote SFTP server. This integration allows you to connect to protected directories, retrieve spreadsheet data, and display it inside your Tadabase app without requiring manual downloads or uploads.
Use Cases
Here are 3 examples of how someone might use the Databridge integration between Tadabase and Excel via SFTP:
- Secure Spreadsheet Synchronization:
Automatically retrieve updated Excel files from an SFTP server to power dashboards, logs, or summaries in Tadabase. - Multi-Sheet Data Handling:
Extract data from specific sheets, such as reports, attendance logs, or financial trackers, and load them into app views. - Backend File Access for Teams:
Enable users to work with backend-generated Excel files in a visual, no-code frontend without direct SFTP access.
Available APIs
| Name of API | Description | List View | Detail View |
| Sheets | Lists all worksheet names found in the connected Excel file. | Yes | No |
| Excel Fields | Retrieves all field names (columns) from the selected sheet. | Yes | No |
| Excel Records | Retrieves all rows (records) from the selected Excel sheet. | Yes | No |
We'd love to hear your feedback.