Salesforce tools · API names

Copying field API names out of Object Manager one at a time is how afternoons disappear. Here are four free ways to get them all at once, from a Chrome extension that labels the page to a full Excel dump of every object.

4 methodsall free
2 extensionsTurboKit and Inspector Reloaded
1 workbookper object, with Field Dumper
0 installswith the SOQL option
On this page
  1. The four options
  2. 1 · Show Field API Names
  3. 2 · Show All Data
  4. 3 · Field Dumper
  5. 4 · Native query
  6. Tips
  7. Gotchas and FAQ
Watch on YouTube ↗
The problem

Object Manager, one field at a time.

You need API names for every column in the mapping, and copying them out of Setup field by field takes all afternoon. Here are four faster ways, all free.

MethodBest forInstall?
Show Field API NamesQuick lookups on one recordChrome extension
Show All DataEvery field on an object, searchableChrome extension
Field DumperExcel workbook of many objectsFree AppExchange app
Native SOQLWhen you can’t install anythingNo

Prefer to read? Everything in the video is written out below.

Method 1

Show Field API Names on the record.

Two free Chrome extensions put the API name next to every field on the page.

Install Salesforce TurboKit or Salesforce Inspector Reloaded from the Chrome Web Store. The TurboKit post covers setup.

Salesforce TurboKit and Salesforce Inspector Reloaded on the Chrome Web Store
Both free on the Chrome Web Store.
  1. Open any record of the object you’re mapping.
  2. TurboKit: lightning bolt → Objects → Show Fields API Names. Inspector: blue flyout → Objects → Show Fields API Names.
  3. Copy each API name into the mapping sheet.
Using TurboKit or Salesforce Inspector to show field API names on a Salesforce record
API names appear beside the labels.
Field API names shown on the record page and pasted into a data migration mapping sheet
Straight into the mapping sheet.
Method 2

Show All Data for every field.

Same extensions. Every field on the object, not just the ones on the layout.

From the record, open the extension and click Show All Data. You get label, API name, type and this record’s value for every field, including hidden ones, and you can search and sort all four columns.

Opening Show All Data from the TurboKit or Salesforce Inspector menu
Lightning bolt or blue flyout → Show All Data.
Show All Data view listing every field with its API name, label, type and value, filtered
Filter by label, API name, type or value.
Method 3

Field Dumper for an Excel workbook.

One tab per object, every field’s label, API name and type.

  1. Install Field Dumper – Extract Data Model to Excel from AppExchange (free).
  2. App Launcher → Field Dump.
  3. Pick your objects and click Add.
  4. Click Dump Objects to Excel and open the workbook.
Field Dumper - Extract Data Model to Excel, a free app on the Salesforce AppExchange
Field Dumper on AppExchange.
Adding objects to the Selected Objects list in Field Dumper
Add the objects you’re migrating.
Field Dumper Excel workbook with one tab per Salesforce object
One tab per object.
Method 4

No installs allowed? Query them.

Field metadata is queryable. Run this in the Developer Console query editor and export the results.

SELECT QualifiedApiName, Label, DataType
FROM FieldDefinition
WHERE EntityDefinition.QualifiedApiName = 'Account'
ORDER BY Label

Swap in your object’s API name. For a quick look without a query, Object Manager → Fields & Relationships lists every Field Label beside its Field Name, and you can copy straight off that page.

Tips

Pick one and stay consistent.

  • Extensions for lookups while you work, Field Dumper for the big multi-object export, the query where apps aren’t allowed
  • Permissions matter: you only see fields your profile can see
  • Put the API names in row 1 of the load file so Data Loader auto-matches them
  • Linking records between loads? Use External ID fields instead of VLOOKUPs
Gotchas

The questions people ask.

Why do I need API names?
Data Loader, formulas and integrations use them. Labels repeat and change, so mapping by label can put data in the wrong field.
Fastest way on a record page?
TurboKit or Salesforce Inspector Reloaded: Show Fields API Names.
Show Fields API Names vs Show All Data?
The first labels the fields on the page layout. The second lists every field on the object, hidden ones included, with type and value.
How do I get them into Excel?
Field Dumper, one tab per object.
I can’t install anything
Query FieldDefinition in the Developer Console, or copy from Object Manager → Fields & Relationships.
Data Migration Masterclass

API names are step one of the mapping.

The Masterclass walks through the whole migration, including the field mapping workbook these API names go into.

Know someone copying API names out of Setup one by one?

Share on LinkedIn
Doing this for a whole org, not just one object?

One CSV is a tutorial. Forty objects, 15 years of history and a go-live date is a project. That’s the part I do for a living.

See how I run migrations →