How do I export data?

The Data Export Wizard allows you to customize the information included in an export and select the file format that best fits your workflow. Follow the steps below to create and access a completed export.

How to Export Data

After applying filters and generating a list of wells, click Export All to export every well in the list, or Export Selected to export only the wells selected using the checkboxes.

Note: If you do not see the well list shown above, your List panel may be hidden. See How do I toggle my Map, List, and Analytics panels? for instructions on restoring the List panel.

Data Export Wizard

The Data Export Wizard will open and guide you through the export process.

1. Template – Select a previously saved template or start a new export.

2. Settings – Choose the export file format.

3. Data Types – Select the types of data to include in your export.

4. Attributes – Choose the specific fields (columns) to include for each selected data type.

5. Review – Name your export, optionally save the settings as a template, and submit the export for processing.

1. Template

If this is your first export, select New. If you have previously created export templates, you can select a saved template or choose Last Used Settings to reuse your most recent export configuration.

If you select a saved template and no changes are needed, click the numbered Step 5: Review indicator at the top of the Data Export Wizard. This takes you directly to the final screen without clicking Next through the remaining steps.

2. Settings

The Settings step is used to select the export format.

In this example, we will select CSV. The same workflow can also be used for Excel exports. In most cases, WellDatabase recommends Excel XLSX rather than Excel XLS, as the newer XLSX format supports larger datasets and more rows.

For a complete list of supported export formats, see Which 3rd party software does WellDatabase export to?

Select the desired export format and click Next.

3. Data Types

The options shown in Step 3 depend on the export format selected in Step 2: Settings.

For customizable formats such as CSV and Excel, this step allows you to select the data types (record types) to include in your export.

In this example, we're selecting Well Headers, which contains general well information; Production, which contains monthly production history and related data; and Production Forecast Summary, which includes an EUR for each well. Because CSV creates a separate file for each selected data type, this export will generate three files.

1. Select the desired data type from Selectable Data Types and click Add to move it to Selected Data Types.
2. Repeat for any additional data types you want to include.
3. Click Next to continue.

Note: The options displayed in Step 3 depend on the selected export format. This example follows the CSV and Excel workflow. Other formats may display different settings.

4. Attributes

The Attributes step allows you to choose the specific fields (columns) included in your export.

This step must be completed separately for each data type selected in Step 3: Data Types. In this example, we selected Well Headers, Production, and Production Forecast Summary, so the Attributes step will appear three times.

1. Select the desired fields from Selectable Attributes and click Add to move them to Selected Attributes. To include all available fields, click Add All.

2. Click Next to continue to the next selected data type, after the final data type, Next advances to Review.

3. Repeat this process until you have configured the attributes for all three data types.

Note: Attributes are selected independently for each data type. For example, if you need API Number included in all three output files, you must select it for each data type.

5. Review

The final step allows you to name your export and optionally save your export settings for future use.

1. Enter a name for your export.

2. If you expect to run a similar export again, select Save Export Template. This saves your export settings, data types, and attributes so you can reuse them for future exports.

For instructions on saving and reusing templates, see How do I save a template for my export?.

3. Click Finish to submit your export for processing.

After clicking Finish, a confirmation window will appear indicating that your export has been submitted and is being processed in the background.

Accessing Your Export

Once an export has completed processing, it can be downloaded using any of the methods below.

1. Export Ready Notification

When processing is complete, WellDatabase will display an Export Ready notification. Click Download Now to immediately download the completed export.

2. Notification Center

You can also access completed exports through the notification center by clicking the bell icon in the upper-right corner of the application. Recent exports will appear in the notification list and can be downloaded directly.

3. My → Exports

Navigate to My → Exports to view export history, download completed exports, or reprocess previous exports using the original export settings.

4. My → Files

Completed exports are also available from My → Files. Use the gear icon next to the export name and select Download File.

Subscription Requirements

Exporting is available with Essential, Plus, Pro, and Enterprise accounts. It is not available with Lite accounts. During a trial, exports are limited to 10 unique wells.

Export row limits also apply based on your subscription level. If your export exceeds your account's limit, you will need to reduce the number of records before proceeding.

Frequently Asked Questions

Q: Why did my export create multiple files?
A: CSV, Excel XLSX, and other export formats may create multiple files when multiple data types are selected. In this example, selecting Well Headers, Production, and Production Forecast Summary creates three separate output files—one for each data type.

Q: What is the difference between Excel XLSX and Excel XLSX (Single Workbook)?
A: Excel XLSX creates a separate file for each selected data type. Excel XLSX (Single Workbook) combines all selected data types into a single workbook and places each data type on its own worksheet tab.

Q: Why do I need to select API Number for each data type?
A: Attributes are selected independently for each data type. Selecting API Number for Well Headers does not automatically include API Number in Production, Completions, or other selected data types. If you want a field such as API Number to appear in multiple data types, it must be selected during the Attributes step for each applicable data type.

Q: Why am I seeing the Attributes step more than once?
A: The Attributes step is completed separately for each selected data type. This allows you to choose different fields for each data type included in the export.

Q: Why am I stuck on Step 4: Attributes?
A: The Attributes step is completed separately for each data type selected in Step 3: Data Types. If you select Well Headers and Production, you will configure attributes for Well Headers first, then configure attributes for Production before advancing to the final Review step. If 15 data types are selected, you will complete the Attributes step 15 times—once for each selected data type. This allows you to choose different fields for each data type included in the export. If this is a recurring export, consider selecting Save Export Template during Step 5: Review. Saved templates allow you to reuse the same export settings, data types, and attributes without repeating the setup process each time.

Q: Can I save my export settings for future use?
A: Yes. During the Review step, select Save Export Template to create a template that can be selected during future exports. When a saved template is selected, the export settings, data types, and attributes are automatically populated using the saved configuration. If no changes are needed, you can navigate directly to the final Review step and submit the export without repeating each step of the wizard. This can significantly reduce the time required for exports that are run on a regular basis. For detailed instructions, see How do I save a template for my export?.

Q: Why am I receiving an "Unable to Start Export" error?
A: This error can occur when the number of records in your export exceeds your account's row limit. For example, if your account is limited to 1,000,000 rows per export and your search returns more than that amount, the export cannot proceed. Narrow your search criteria or divide the data into smaller exports to stay within your account's limit.

Q: Is there a limit to how many rows Excel can handle?
A: Microsoft Excel supports a maximum of 1,048,576 rows per worksheet. For larger datasets, CSV may be a better format because CSV files are not subject to Excel's worksheet row limit. However, WellDatabase subscription-based export limits still apply regardless of the file format selected. If you open a CSV file in Excel, Excel's worksheet row limit still applies.

Q: Can I export data with a Lite subscription?
A: No. Data exports are not available with Lite subscriptions.

Q: How many exports are included with my subscription?
A: Export allowances vary by subscription level. Refer to the Compare Plans page for current export limits and feature availability.

Explore additional articles by searching the topics on the left. If you have any questions, feel free to email support@welldatabase.com