All docs pages (49)
Object Data Dictionary
Pick one or more objects and get every field's type, length, required flag, picklist values, formula and help text as a table, an Excel file or a CSV.
Updated 2026-11-09
Object Data Dictionary lists the fields of the objects you pick, one row per field, and exports that list to Excel or CSV. Use it to document a schema or to answer "what fields does this object have?" without opening each field in Setup. Open Metadata → Object Data Dictionary.
This page is about fields. For who can see and edit each field, use the Permission Matrix.
How to use it
- Under Select Objects, tick the objects you want. Use Search objects... to find them by label or API name. Each object is tagged Custom or Standard.
- Click Generate Metadata. The page shows "Fetching metadata..." while it reads the objects.
- Review the table under Field Metadata. Use Search fields... to filter it, and the column menu to show or hide columns.
- Click Download Excel or Download CSV.
- Click Clear All to start over.
What you see
The heading says how many fields were found across how many objects, for example "312 fields from 4 objects". Each row is one field. The columns are:
- Object Name and Object API
- Field Name and Field API
- Data Type: the field type Salesforce reports, such as
string,doubleorpicklist. Relationship fields show Lookup or Master-Detail instead ofreference. - Length
- Required: Yes when Salesforce says the field can't be blank
- Custom, External ID, Encrypted, Unique and Auto Number: Yes or No
- Picklist Values: the values' labels, separated by semicolons
- Formula: the formula text, for formula fields
- Help Text
- Reference To: the object or objects a relationship field points to
- Relationship Name
The table hides Object API, Unique, Auto Number, Picklist Values, Formula, Help Text and Relationship Name at first. On Account, fields that only exist when Person Accounts are on carry a PA badge.
The search box matches field name, field API name, object name, object API name, data type, reference target and help text.
What it reads and writes
It only reads. The object list comes from a Tooling API query on EntityDefinition (queryable objects, sorted by label). Generate Metadata runs the REST describe call for each selected object, all at once. Nothing is written to your org.
Lookup and Master-Detail are told apart without using the required flag. If the parent object is among the objects you selected, the parent's child relationship decides: cascade delete means Master-Detail. Otherwise the field's relationship order decides: a value means Master-Detail, none means Lookup.
The exports use the same 17 columns in the same order, whatever columns you hid in the table, and they include every row, not just the rows your search shows. The Excel file has one sheet, Field Metadata. Files are named with the date, such as Object_Metadata_2026-11-09.xlsx. Values that a spreadsheet could run as a formula are neutralized in the CSV.
Limits
- Required means the field can't be blank. Checkbox fields always show Yes, because a checkbox is never blank. So do fields that Salesforce fills in itself, such as Id and Created Date.
- Encrypted is Yes only for Classic Encrypted Text fields. Shield Platform Encryption does not show here.
- The object picker lists at most 2,000 objects.
- The Custom tag in the picker is based on the
__csuffix. Custom metadata types, platform events and other custom types with a different suffix are tagged Standard. - If Salesforce can't describe an object you selected, that object is left out of the results and no error is shown. Compare the object count in the heading with the number you selected.
- The progress count jumps from 0 to the total in one step, because all describes are sent together.
Related
- Permission Matrix: field-level security for each field, by permission set and profile
- Where Used: what references a custom field
- Field Creator: add new custom fields to an object