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

PreviousUnit TestingNextDatetime & Timezone Tests

Last updated