Excel Test Data Workbook Practice — ToscaAutomation.com

Why this is here

Most data-driven frameworks read test data from a spreadsheet instead of hardcoding it. Download the master workbook below — it's a real multi-sheet .xlsx file built for the scenarios on this site (login users, laptop configs, addresses, and an expected-results oracle sheet). Then upload it back (or any .xlsx with the same shape) to practice the other half of the loop: parsing a workbook client-side, switching between sheets, and pulling a single row's values out to use as test input.

1. Download the master workbook

Six sheets: Users, Products, LaptopConfigs, Addresses, Passengers, ExpectedResults.

2. Upload a workbook and read it back

Buffered row

This is the JSON a data-driven test would hold in memory after reading that row — copy a field from it into any other practice scenario.

3. Bulk-upload an order into Vegetable Ordering

The full round trip: download a template, fill in SKU/quantity rows, upload it back — each matched row is added straight to your Vegetable Ordering cart via the same vault the scenario itself uses. Requires being logged in, since a cart belongs to an account.