Scans of Well Logs Available--Wells with Wireline Logs

Directions: The link below contains the data you requested in a comma-delimited, ASCII file that should be readable by normal spreadsheet or database software. Files are deleted after 24 hours. Clicking on the link only opens a text file. Instead,

Right Click the link and select "Save Link As" or "Save Link to Disk" from the pop-up menu.
Save the file to your computer, keeping the extension as .txt
Open Excel or your Database
Select "Open File" and navigate to where you saved your file. Note - in Excel, to find your text (.txt) file, look to the right of the File-Name box for File-Type. Change the type from "All Excel Files" to "All" or "Text." Then you can select and open your file.
Using the Text Import Wizard:

choose "Delimited", then click on "Next."
choose by "Comma" - you’ll see the example data adjusted to columns, then click on "Next."
only if your data includes 2 separate columns for "Lease" & "Well,"" navigate to the "Well" column and change the format to Text; otherwise skip step 3.

Click on "Finish", and your file will open

Please Note--The file format is designed to make the data easier to manipulate in Excel. For files of wells and tops that are more suited to GIS and mapping use, please use the Master List of Oil and Gas Wells.

KGS ID	Unique ID for the well assigned by the Survey. Not necessarily permanent.
API_NUMBER	API number assigned by the Kansas Corp. Commission, or from historical records.
API_NUM_NODASH	API number, formatted without dashes.
LEASE_AND_WELL	Lease name and Well number.
FIELD	Oil and gas field name
LATITUDE	NAD 1927, generated from the legal location.
LONGITUDE	Some new wells have GPS longitude and latitude.
TOWNSHIP	Public Land Survey System township number, 1-35 in Kansas.
TWN_DIR	Township direction. S (south) or N (north), Always south in Kansas
RANGE	Public Land Survey System range number, 1-43 in west and 1-25 in east.
RANGE_DIR	Range direction. E (east) or W (west).
SECTION	The PLSS section the site is located in: 1-36
SPOT	The legal quarter description qualifiers list as NE, NW, SE, and SW, etc..
FOOTAGES	Distance in feet north-south and east-west from the reference location.
OPERATOR	Operator of the well at drilling completion. Not usually updated except at workover.
LOG_OPERATOR	Operator of the well as listed on the log itself.
ELEVATION	The elevation the well, in feet.
ELEV_REF	KB is Kelly bushing, DF is derrick floor, GL is ground level, TOPO is estimate based on digital model.
DEPTH	Total depth of well, not plugged back.
FORM_AT_DEPTH	Formation at total depth.
SPUD	Date of drilling start.
COMPLETION	Date of drilling finish.
PLUGGING	Date well plugged.
STATUS	Well status--type of well. Abbreviation list
LOGGER	Name of the company that created the well log.
TOOL	Name of the logging tool.
LOG_TOP	Feet below the surface of the top of the log. Note small zones such as an evaporite layer may be plotted on the log but not shown here.
LOG_BOTTOM	Feet below the surface of the deepest part of the log.
LOG_DATE	Date when the log was measured.
BHT	Temperature at the bottom of the hole.
LOG_COLOR	Color of the original log.
SCAN_COLOR	Color of the scan.
SCAN_URL	URL of the scans made of the log.
UPDATE_DATE	Date this scan was (probably) created or last updated.

		Wells with Wireline Logs Data Saved to File