Entering Data into Content Models

To enter data, click the Template spreadsheet and copy your records into the spreadsheet, field by field.

For example, assume that you have information about eight well boreholes. Your information includes the following:

  • An API number for each borehole
  • The owner and operator of the well associated with each borehole
  • The latitude/longitude coordinates for the well associated with each borehole

Data should then be entered into the corresponding column in the Template spreadsheet (Table 2). Data regarding individual fields can be found on the Field List tab.

APINo Operator Mineral Owner LeaseName LatDegree LongDegree
02-021-05000 Nichols, Hugh E. State State 33.33789906 -111.5474776
02-005-05019 Sinclair Oil & Gas Santa Fe Pacific RR Santa Fe 35.76820705 -112.3573439
02-001-05335 Kerr-McGee Hortenstine-Macie Macie Fee 35.08278252 -109.5836642
02-003-05038 Allen, Elmer R. W. J. Davis Davis 31.57815012 -109.7510095
02-017-05065 Texaco-Skelly-Sinclair Navajo Navajo 36.98885669 -110.3807293
02-021-05005 Western Oil Fields Federal Federal 32.94538466 -111.3689436
02-027-05011 Stewart, M. P. Federal Federal 32.52173669 -114.6501276
02-001-05198 Shell Oil Navajo Navajo 36.98311134 -109.2666708

Table 2: Sample entries from an existing template spreadsheet

It should be noted that your data may not correspond with the fields in a given content model on a one-for-one basis; if so, then a degree of schema mapping is required in order to transpose your data into the content model. See Step 2 of the data provider workflow for more information.

Continue the tutorial by clicking the links below.