Salesforce Lightning Object Creator: Turn Spreadsheets into Objects

Share this article...

The Lightning Object Creator is a simple tool designed to take a spreadsheet, and turn it into a brand-new object, including fields, with just a few clicks!

This tool will make an admin’s life easier. There are so many use cases for this tool that I could probably write pages on it. So, how about we introduce the tool with a simple example?

What is the Lightning Object Creator?

The Lightning Object Creator takes a spreadsheet and turns it into a brand-new object. This is the better alternative to the usual route (creating the object, creating the fields, and loading the data).

You’re the Salesforce Admin, and your colleague in Sales Ops would like to create a new object related to contacts, with several new fields. He already has all of the data and structure set up in an Excel file. Let’s take a shortcut by using the new Lightning Object Creator tool.

Create Salesforce Object from a Spreadsheet

1. In Lightning, go to Setup → Object Manager → Create

2. You will see that the Create button now features a drop-down arrow. We want to click on the “Create Object from Spreadsheet” option.

3. Choose the instance type: This is where you’ll be creating the object. Since I am in a developer org, it’s safe enough to do this in the fake production org.

4. Select Spreadsheet Location: As you can see you have 3 options – from desktop, which will accept .csv or .xlsx, from Google Sheets, or from OneDrive (Office365). In this example, I’m going to upload from my desktop.

5. Define Object Screen: This screen is the meaty part, so let’s break it down:

  1. This allows you to select whether you want the field names to be the names from the column headers, or if you want to manually configure the field names.
  2. Use this to tell the creator which row contains the column headers.
  3. This selection allows you to decide whether to import the data simultaneously or to wait and handle that later.
  4. This drop-down allows you to either let Salesforce decide the record name or you can use one of the column headers as the record name.
  5. If you have a lot of rows and some of them do not get mapped (see the green checkmark on the far-left side of the table), then you can use the “Hide mapped fields” checkbox to just show the rows that are not mapped.
  6. This allows you to toggle the view you are in. In the screenshot above, I am in the list view – in the screenshot below, you can see what it looks like in the data view.
  7. This is the actual table of the mappings of your columns to their respective names and data types – make sure you review this before proceeding.

6. Configure the Object Name: Click on the Next button in the right-hand corner. This will take you to the next screen which allows you to configure the name of the object.

7. Advanced Settings: Check out the advanced settings options for things like reporting and activity creation.

8. Finishing Touches: When you click Finish, the Lightning Object Creator will then go through the process of creating everything for you.

To check out your newly created object go to Setup → Object Manager and search for your object.

That’s it, you are done! So fast, and so easy.


Salesforce Lightning Object Creator takes the best of both worlds from spreadsheets and tidy data sets. Admins are going to save so much time with this app – creating Salesforce objects with fields and data altogether has become a walk in the park.

15 thoughts on “Salesforce Lightning Object Creator: Turn Spreadsheets into Objects

  1. I tried to import a sheet that had a picklist and got an error that it could not import the data. I assume it’s the picklist that is the problem, though there is a date field as well. Any ideas?

    1. Hi Neal, It’s my understanding from the documentation and from using this that it is only for creating NEW objects, not editing existing ones. The structure of the wizard does not lend itself to updating. Hope that helps.

  2. Are you also able to define the Field Descriptions using this method upon creation? Object description is great, but I also insist on clean field descriptions for builds.

    1. Hi Brent,

      There is no field description option to populate in the wizard, but you could go back in and update those after the fact to keep your system tidy.

  3. Is there a template of how to format the spreadsheet or google sheet? I have not been able to find out how to best format the sheet yet.

    1. Hi Steven,

      I would think about the data the way it is exported from a report. You want to keep the data in the columns consistent in type so that the wizard can easily identify the type. So far I have the wizard pretty responsive to just about any excel file that I have (I have tried about 4).

  4. How do I log out of a sandbox to connect this feature to a different org. When I switch orgs, the object-creator doesn’t give me the ability to sign into another org.

    1. Hey Brian

      To log out of a sandbox and connect to a different org, follow these steps:

      1. Go to the login page for your sandbox (e.g.
      2. Click on the dropdown arrow next to your name in the top right corner
      3. Select “Log Out” from the dropdown menu
      4. Enter the login credentials for your desired org
      5. Once you’re logged in, you should be able to access the object creator and connect it to your new org.

      If you’re still having trouble after logging out and logging into a different org, try clearing your browser’s cache and cookies. If that doesn’t work, try using a different web browser to log in to your new org.

  5. Great article, Yelena! The Salesforce Lightning Object Creator is a game-changer for businesses looking to streamline their operations. I can imagine how much easier it will make managing data, especially for those who are used to working with spreadsheets. Thanks for sharing your insights!

Add Comment