Make Selenium Easy

Create a Map From Excel Data in Java – Selenium – API Automation

In this post, we will learn to create a Map from Excel data to use in scripts such as Selenium and Rest Assured tests.


When we write a code, it may require some data to act on. For an example :- If we want to register a user on an application, we require some user data like name, age , address , contact details etc. It is always a good practice to keep logic and data separated.

We use “Excel” extensively to store test data. We are aware that excel stores data as rows and cells and each cell can be uniquely identified using index. I have already covered reading an excel file using Apche POI here.

In this post, we will see a common problem and how can we resolve it.

Problem Statement

Consider below excel data :-

I have stored data as a key value pair. If I need value of “FirstName“, I can pass row as 1st and cell as 1st i.e. (1,1). Similarly if I need value of “Company“, I can pass row as 4th and cell as 1st i.e. (4,1). In short, I am hard coding rows and cells. If I add a new field in between , all indexes will be changed. This way is not recommended.


Think if I could get all these key-value pair from excel in to Java data structure – Map, so that I could get the value just by passing field name. You can raise a concern what if I do not know the exact field name? It is genuine and I believe accessing data must be easier. I can use a type preferably Enum to define fields. We should always avoid hard coded things in code which could be passed from outside.

Let’s implement the same.

Output :-

This strategy will be helpful in handling dynamic flow. For example :- To register a user you may need multiple fields but do not required all. Some field may ask for some extra details. You can pass all these data setup in excel and let code work on passed data. No need to open excel and get index manually.

You can download/clone above sample project from here.

If you have any doubt, feel free to comment below.
If you like my posts, please like, comment, share and subscribe.

You can find all Selenium related post here.
You can find all API manual and automation related posts here.
You can find frequently asked Java Programs here.

Author: Amod Mahajan

A software Tester who is paid to judge products developed by others. Currently getting paid in American Dollars. Writing technical posts and creating YouTube videos are my hobbies.

2 thoughts on “Create a Map From Excel Data in Java – Selenium – API Automation

Leave a Reply

Please wait...

Subscribe to new posts to become automation expert

Want to be notified when my new post is published? Get my posts in your inbox.