Spreadsheets Anywhere

Spreadsheets anywhere allows you to read data from spreadsheets (CSVs, Excel, JSON) from cloud or local storage.

Data source settings

Files

Files takes JSON objects inside an Array to describe one or more target files.

Example

[{
  "path":"https://meltano.com/files",
  "name":"gitflixusers",
  "pattern":"GitFlixUsers.csv",
  "start_date":"2021-01-01T00:00:00Z",
  "key_properties":["id"],
  "format":"csv"
}]

Note no trailing / on the path, or prefixed / on the pattern.

Spreadsheets Anywhere will build the URL back up correctly, so in this case it will look for a file at https://meltano.com/files/GitFlixUsers.csv

Passing the above array containing JSON to our files field will sync the data of the file GitFlixUsers.csv into your datastore under the table name gitflixusers.

Learn more

Matatika Data Source Documentation

Meltano Hub Documentation

Table of contents

• Extractor