CSV Files

Fanar can read CSV files and Excel spreadsheets from any accessible URL.

info

If the target Excel workbook contains multiple sheets, the first sheet will be used.

Both the CSV and Excel query runners use YAML syntax to write queries.

Your query should include a url key and optionally a user-agent key that will be sent with your request.

url: "https://www.example.com/path/to/file.xlsx"

user-agent: "Google Chrome";v="95", "Chromium";v="95", ";Not A Brand";v="99"

To query Excel or CSV files with SQL, you can use the QRDS in a separate query.