Lightning Object Creator Featured Image

Turn Spreadsheets Into Objects with the Lightning Object Creator


We are excited to announce Lightning Object Creator is now generally available! As you may know, Lightning Object Creator is a new tool that turns spreadsheets into apps with just a few clicks.

With the Lightning Object Creator, it only takes a few steps to translate the columns of a spreadsheet into fields, define field types and import all the spreadsheet data. Take spreadsheets from Microsoft Excel, Google Sheets, or comma-separated value (CSV) files, and turn them into apps. Allowing your newly converted object to have all the same productivity tools our users love like reports, chatter, and global search.

NOTE: This is going live on a rolling basis, and most production orgs won’t see this appear in production until tomorrow, Thursday, August 8, 2019. You will be able to see it in your sandbox(es) today (August 7 2019) or if you go to this link:

How it works

Turning spreadsheets into custom objects is as easy as three simple steps. You can access the creator UI from the Create button on any page in Setup or from the Navigation Items tab inside a Lightning app. To start, upload an Excel or CSV file or choose a file using one of our integrations with Microsoft Office 365 and Google Cloud.

Object Creator Welcome Screen

Next, Salesforce will automatically detect the fields and and populate all its record data. You can customize the Salesforce field name and field type or leave them as suggested. Additionally, you can choose to add a particular field to a page layout directly within the mapping screen without going into the Page Layout editor.

Second step in wizard: Define the field types and preview the content

Finally, you have granular control of the object’s permissions including enabling chatter for the object, allowing search and reporting.

Third step in wizard: select object settings

That’s it! By clicking finish, you have now turned rows and columns of static data into an interactive data object with all the benefits of a cloud-hosted application.

Why Stop at Object Creation?

By creating custom objects, you now have unlocked the ability to plug data into a wide range of builder tools from process automation to mobile app development, including: Lightning Flow, Lighting App Builder, Lightning Schema Builder, Lightning Components from AppExchange.

Lightning Object Creator is available today in Lightning Experience and in Contact, Manager, Group, Professional, Enterprise, Performance, Unlimited, and Developer Editions. Get started by uploading a spreadsheet — and turning it into a custom object with data already filled in!

Cloudy standing under text that says "5 Data Management Labs Apps for Admins."

5 Data Management Labs Apps for Admins

Data management is crucial to keeping records organized and easily accessible, and to having the information needed to respond to your customers’ needs. In our connected world, it’s become more important than ever to provide personalized experiences for your customers—and having the right data is key. Luckily, AppExchange and Salesforce Labs are here to help. […]

Screenshot of lightning setup page

Take a Tour of Setup Home in Lightning Experience

Editor’s Note: This is one of our most popular posts, so we’ve updated it with the latest information and resources. You’ve probably been on a tour before at a museum, historical site, or even your best friend’s new home. Didn’t you learn a lot more than by stumbling through on your own? Well, consider this […]


Learn MOAR with Spring ’20 Release Highlights for Admins

Join us and discover the new Spring ’20 release features for Admins and Developers. We know each release brings with it lots of amazing new functionality and there can be a lot to digest. With Learn MOAR, we’re packaging the release and bringing it to you in manageable, bite-sized pieces. LEARN MOAR It’s easy to […]


Have an Idea for a Story?

We are all about the community and sharing ideas.
Do you have an interesting idea or useful tip that you want to share?