How do I search by multiple API numbers?

Yes! Easily search by and map up to 1,000 API numbers at once.

API/UWI Filter

The API/UWI filter allows your to easily search by and map up to 1,000 API (or UWI) numbers at one time. 

Simply copy and paste the API (or UWI)'s from another list (Excel, CSV, etc) into the API/UWI field in the filters section using a separate line for each API number. 

Note: Copying from an Excel list will automatically give each API a new line when copied over. 

Tip: This method of searching works well for 1,000 or less API's to search for more than 1,000 API's use the Well Finder to search up to 4,000 API's 

 

If you search for more than 1,000 API numbers, only 1,000 will be returned using this method. 

Well Finder Filter

The well finder will let you search for up to 4,000 API's in a single search. 

Step One

In the first column of the well finder, select if you want to search by API, API10, API12, API14, UWI, SimpleId, or ID. In this example, we will search by API.  

Step Two 

Copy your API numbers from an Excel or CSV file and paste them into the first column. Once you have done that, proceed by clicking the "Find ## Values" button located at the bottom of the column.

Step Three

At the top of the second column, you will see the total number of wells that have been matched to your search criteria. In this instance, all 4,000 wells were successfully located. To proceed, click the "Add Matched" button located at the bottom of the column.

Step Four

Once you move the wells to the third column, click apply. 

Once you click "Apply" the results will be shown on your map, in your list, and analytics. 

 

Note: If you enter more than 4,000 wells, you will receive the error message shown below and not be able to search the wells.

 

If this is a grouping of wells that you work with often, you might consider either saving this search or creating a project. 


Explore other articles by searching the topics on the left or if you have any questions feel free to email support@welldatabase.com