Using Google Sheets as a Unit Test Data Source

• Create the Google sheet

• Column headings

• Make it readable by anyone with the link

  • Security ?

e.g.

https://docs.google.com/spreadsheets/d/1DREayEscT7YyWCNQQLSkHjeVFi5bON1KODZxTIJQEnk/export?format=csv

Advanced Sheet Setup

Sample data sheet

Based on https://docs.google.com/spreadsheets/d/1DREayEscT7YyWCNQQLSkHjeVFi5bON1KODZxTIJQEnk/export?format=csv

ARRAYFORMULAS

Skip a row

RANDOM data