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
