---
schema_version: "1"
id: e9d5457c50537b36b95fd9c37f42d8604d51e4528d36c5c9ed4da7aa1ec74b52
title: Create a Custom Object from a Spreadsheet in Lightning Experience
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/platform/264-0-0/dev_objectcreate_task_lex_from_spreadsheet.md
canonical_url: https://help.salesforce.com/s/articleView?id=platform.dev_objectcreate_task_lex_from_spreadsheet.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 06137ab37b955b70f0287466ba7835ab585247968c7c32fa3b6561b071c0bcc7
description: Use custom objects to track and store data that’s unique to your organization. If you prefer not to create a custom object and its fields manually, you can use a spreadsheet to add the object and its fields and populate all its record data.
products:
  - Salesforce Platform
  - Security
release: "264"
---
# Create a Custom Object from a Spreadsheet in Lightning Experience

Use custom objects to track and store data that’s unique to your organization. If you prefer not to create a custom object and its fields manually, you can use a spreadsheet to add the object and its fields and populate all its record data.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Lightning Experience</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: <strong>Contact Manager</strong>, <strong>Group</strong>, <strong>Professional</strong>, <strong>Enterprise</strong>, <strong>Performance</strong>, <strong>Unlimited</strong>, and <strong>Developer</strong> Editions</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d137778e82">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d137778e82 ">To create and edit custom objects:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d137778e82 ">Customize Application</td>

          </tr>
        </tbody>
      </table>

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/images/icon_note.png)

Note Although it’s available in Professional Edition, this feature uses API. To use this feature, Professional Edition orgs must have the API add on enabled. To enable the API add on, contact your Account Executive.

You can create a custom object from a spreadsheet in two places: in Setup, or from the Navigation Items tab inside a Lightning app’s settings.

1. In Setup, go to Object Manager, then click **Create** | **Custom Object from Spreadsheet**.
2. Alternatively, navigate to the Navigation Items tab inside a Lightning app.
    1. In Setup, enter App in the Quick Find box, then select **App Manager**.
    2. Next to the app you want to add the custom object to, click ![List item dropdown menu icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-platform-extend_click-264-0-0-production-enus/5f7d9219-b7b1-4552-8891-f1aba9b289fc/extend_click/images/lex_icon_action_list_item_dropdown.png), and select **Edit**.
    3. Click **Navigation Items**.
    4. From the Available Items list, click **Create** | **Custom Object from Spreadsheet**.
3. Follow the wizard steps to import your custom object data from an .xlsx file, a .csv file, or a Google sheet.
    
    Salesforce detects object field labels from the spreadsheet row that you specify. All fields must be mapped to create the custom object. Skipping the import step creates an empty custom object that uses the fields in the spreadsheet as a template. When you finish creating the object, a custom tab is created for it. The object appears in the list of available items for your app. If you imported field data, your object is ready to go with fully populated records.
4. If you don’t want your users to see the new custom object right away, in the Object Manager in Setup, set its deployment status to In Development. This setting hides the object from users while you’re designing and testing it.
5. When you’re ready for your users to see the new custom object, add it to your app’s Selected Items list.

#### See Also

- [Fields Required for Creating Custom Objects](https://help.salesforce.com/s/articleView?id=platform.dev_objectcreate.htm&release=264.0.0&type=5 "When you create a custom object, several fields are required to define how you can access the object.")
- [Create a Custom Object in Lightning Experience](https://help.salesforce.com/s/articleView?id=platform.dev_objectcreate_task_lex.htm&release=264.0.0&type=5 "Track and store data that’s unique to your organization.")
- [Considerations for Creating Custom Objects](https://help.salesforce.com/s/articleView?id=platform.dev_objectcreate_notes.htm&release=264.0.0&type=5 "Before you create a custom object, make sure that you review these considerations.")
- [Create a Custom Object](https://help.salesforce.com/s/articleView?id=platform.dev_objectcreate_task_parent.htm&release=264.0.0&type=5 "Track and store data that’s unique to your organization. Follow different steps, depending on which Salesforce experience you’re using.")