# Export custom field values

Custom field values can be exported in Excel (XLSX) format ready to open in your favorite spreadsheet program. This is done by clicking the Export button above the selected scope's field definitions:

<figure><img src="https://3940270179-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbIlmOfNwpXqPZMStJkgh%2Fuploads%2F5Nkhqwy42e1u8ueGlUQk%2Fimport_export_actions.png?alt=media&#x26;token=f585f021-df63-42b8-b41e-732342d5d752" alt=""><figcaption></figcaption></figure>

Once the export is complete, the file can then be modified and imported into the same store for doing bulk updates or imported into another store for migration data

{% hint style="info" %}
An export of custom field values contains **only values** for the custom fields, **not** the field definitions themselves. These need to be set up beforehand in the store you are importing to, either by copying & pasting them or by linking your stores and performing a synchronization of the definitions
{% endhint %}

### What's in the file?

The first row in the Excel file is a **required header** line with columns A and B "\_id" and "\_info" followed by one or more custom field names (including their namespaces).\
\
The actual values for an **\_id column** on rows 2 and onward depend on the exported object type and the options chosen when setting up the export. These are the defaults:

* **Handles** are used for products, collections, pages, blogs, articles&#x20;
* **SKUs** are used for variants
* **Email addresses** for customers&#x20;
* **Order numbers** for orders.

The **\_info column** contains information associated with the **\_id** - like the product title or the customer's name. This is for information only and changing this value won't have any effect on any later import.\
\
The third column (C) and onward contain the custom field values associated with the object instance.

### Exporting subsets of data

ACF also allows for the export of a subset of either products', customers' or orders' custom field values from within the Shopify admin. From the relevant object list (such as product list, customer list, etc.), perform a Search or Filter and then bulk select the objects for which you'd like to export the custom field values. Then select the "Actions" menu and click "Export Custom Fields". \
\
Export of subsets is currently limited by Shopify for selections of 50 objects or less

{% hint style="info" %}
Exports run in the background. While an export job is active, the icon next to "Export values" will change to a spinning "gear" icon. Due to Shopify limits, you are encouraged not to start any additional exports until the current job has finished
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://help.accentuate.io/bulk-import-and-export/export-custom-field-values.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.