I'm creating test data for search function in a mobile app. But the search function is little bit tricky.

Let me give an example. We have mobile app which we can buy dogs. in this mobile app we have categories of dogs.

  1. Guard dogs
  2. Senior dogs
  3. Service dogs

Each dog category has different search fields.

Assume I want to buy a service dog and I tap search function. then there will be a different screen with search fields. Breed, Age, Sex , Weight, Service etc. under breed we have 14 different species with check boxes. For Age we have radio buttons.

If I buy a Domestic doc it will have fields like breed,age and sex only.

So I want to create test data in an excel sheet.

How can I manage the data in a excel sheet for each category?

  • 1
    Since you only have a handful of categories, you may want to consider using different sheet for each category. This should be helpful for automating the search functionality as well.
    – Shamanth
    Jan 10, 2019 at 6:25

2 Answers 2


In my opinion ,create separate worksheet for each search fields with all possible values in it and provide hyperlink of those worksheet to all dog categories and even you can reuse those search field worksheet in case of common search fields.


As you have hirarchical test data, I would suggest to use xml/json to hold the data in a test object instead of Excel.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.