Lightning object creator - The ultimate guide in 10 min

Kritik Garg

I hope you will find this blog post helpful.

If you need any support with Salesforce, please do not hesitate to Contact Me.

Salesforce's Lightning Object Creator allows you to quickly and easily create custom objects from Microsoft Excel, Google Sheets, and Comma Separated Value (CSV) files. This powerful new tool was released on August 7th, 2019, and will streamline your workflow!

How Lightning object creator Works

Lightning Object Creator is a game-changer for admins who want to quickly create objects. The simple, three-step process is much more efficient than the traditional 10-step process of creating objects and can save hours of time. With this valuable tool, admins can easily create the objects they need in minutes, rather than hours.

How To create object from spreadsheet

The steps below demonstrate how anyone can easily create a custom object from spreadsheets along with Data.

We will be creating a Student Sports details object to store data about students who participate in sports.

Total Time: 10 minutes

Prepare Spreadsheet

insert object data inti csv

The first row in the spreadsheet represents the fields for the object.
The rows below represent data related to the object.

Open Setup

setup menu 1

First, Go to the home page
Click on the setup menu

Go to Object Manager

object manager

In object, manager click on create dropdown button (Top-Right)
Click on the custom object from Spreadsheet

Authenticate Salesforce org


Click on login with Salesforce
Authenticate to Salesforce org with username & password
Click on allow access

Upload Spreadsheet File

upload Spreadsheet

Upload Spreadsheet File.
Here you can select option according to your file type.

Configure object, field & Type

define object field

Configure object data
Click on next

Fill Out Object Properties

Object properties

Fill in the object properties
Click on finish
It takes some time to create an object and related fields.

Object created

Lightning Object Creator

Object created successfully

Verify Object is created

Serach object

Go to Home Page
Click on the app launcher (the nine dots in the upper left corner of your screen)
Search recently created object called student sports detail
Click and open

Check Object Fields and Data

created object records

Here we can see the newly created object and its records similar to CSV file

Discussion and Forums

Creating custom Object using external source - Salesforce Stack Exchange

Unable to create custom object from spreadsheet - Salesforce Stack Exchange


Import Data to Create a Custom Object Unit | Salesforce Trailhead

Create a Custom Object from a Spreadsheet in Lightning Experience (

Kritik Garg

Kritik Garg

Freelance Salesforce Developer & Consultant

Kritik Garg is a highly skilled Salesforce developer and consultant with a proven track record of successfully completing projects of various sizes and complexities, from short-term assignments to long-term partnerships. He is the founder and CEO of Arrify, and is available to work on projects in the United States, United Kingdom, and Australia.
If you are looking for Salesforce Assistant, contact Kritik now.
Kritik has extensive experience working with various industries, including banking, healthcare, education, telecommunications, and manufacturing. He is an expert in Salesforce Sales, Service, and Marketing cloud, and is skilled in programming and developing various Salesforce features, such as APEX Programming, Lightning framework, VisualForce pages, Triggers, Workflows, Page Layouts, Roles, Profiles, Reports & Dashboards.

Need Salesforce Assistant

I provide salesforce assistance in North that can help you take your business to the next level. Our team of salesforce experts can help you implement and optimize your salesforce system, so you can get the most out of it.

Contact Now Starting from $25/h (No strings attached)