The Minerals Import application uses a wizard to step you through the import process. Before detailing each step, please ensure that the data is in a Microsoft Excel format (xls or xlsx). In addition, please verify that the columns are properly named and that the well production tab is named “MCF” and that the well interest tab is named “DOI”.
Introductory wizard instructions:
While using the Minerals Import Wizard to import a spreadsheet, on the wizard page after selecting the operator, the Lookup Table Values screen (as seen in the image below) will display the values expected for each category listed within the spreadsheet. Click “Manage Lookup Table Values” to edit the values.
You need to make sure the the values in the lookup tables match the spreadsheet values. The fields on the left are editable. Simply click and type in the value that are on the spreadsheet. When you are done editing the values you need click the check box circled in the image below.
Now that you have matched the Lookup Table values with the spreadsheet values you proceed with the importing process.
Please Note: The Interest Type “BL” is always treated as a Royalty Interest. There is no need to add it in the Lookup Table Values or change it in the spreadsheet.
Some errors, such as those that indicate that a spreadsheet is missing required columns, are a straightforward fix. However, due to the complexity of formatting that can occur behind-the-scenes within Microsoft Excel files, some errors are more tricky to resolve.
For instance, if you receive a technical-looking error mentioning that it could not find certain fields (not the required fields message), then the most likely culprit is the “Name Manager” section. These name manager entries prevent the MineralsImport application from being able to read and import the Excel data.
To resolve this error, simply load the spreadsheet in Excel, click the “Formulas” tab and then click on “Name Manager”. Highlight all of the entries and then click “Delete”. Save and close the Excel file and retry the import.
Another common issue is that you cannot import an Excel file that is currently open in Microsoft Excel, so always make sure that the spreadsheet is not open in Microsoft Excel during the import process.