---
sourceDocument: Yokohama Build or modify applications
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/application-development

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Build or modify applications

ft:clusterId :

    - cadev

bundleId :

    - cadev

workflow :

    - Development, Data, and Analytics


---

# Upload a spreadsheet in Guided Application Creator

# Upload a spreadsheet in Guided Application Creator {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read

Turn your spreadsheet into a custom table in Guided Application Creator to store data for
your custom application.

## Before you begin

Complete:

1. [Create an application record in Guided Application Creator](https://servicenow-prod.fluidtopics.net/WDjf6BYwfBKh9E~0a2h_Zg "Create an application record in Guided Application Creator to identify a custom application.")
2. [Define roles in Guided Application Creator](https://servicenow-prod.fluidtopics.net/2F9MA2pRT7DkyLFPPB5oxw "Create or select roles in Guided Application Creator for the members of your organization who use your custom application.")
3. [Select user experiences in Guided Application Creator](https://servicenow-prod.fluidtopics.net/tK2mzWPwA4ZAzgUDIJcgXA "Let users access your application via the ServiceNow Agent mobile app or lists and forms.")
4. [Designate data tables in Guided Application Creator](https://servicenow-prod.fluidtopics.net/PVqgw9Q50sa~krY18bzTQg "Select an existing table or create a custom table in Guided Application Creator to store data for your custom business application.")
{#gac-upload-spreadsheet__ol_kpp_kkb_5hb}

Review the [spreadsheet
guidelines](https://servicenow-prod.fluidtopics.net/ZYwAs4sjcNpgW7rz6Xwjzg#spreadsheet-guidelines "One way to create a new data table in Guided Application Creator is to upload an external spreadsheet. Prepare your spreadsheet beforehand so that you can transfer your data seamlessly and build custom applications faster.") to ensure that your data uploads as expected.

Role required: sn_g_app_creator.app_creator or admin

## Procedure

1. To select a table creation method, on the screen, select Upload spreadsheet and then select Continue.  
2. Upload your spreadsheet.  
   You can drag and drop the spreadsheet file or browse your system to select
   the spreadsheet file.
3. In Enter a row for the table header, enter the number of the header row on your spreadsheet.  
   For example, if your spreadsheet has two columns in which the headers are in
   the second row (such as in the following image), you would enter
   <kbd class="ph userinput">2</kbd>.
4. Select the Import spreadsheet data option.
5. Select Continue.  
   Your spreadsheet content is parsed into fields for your custom table.
6. On the form, fill in the fields.  
   {#gac-upload-spreadsheet__table_dd3_stw_5hb__entry__2}

   | Field | Description |
   |-|-|
   | Field Label | Unique label for the field. |
   | Field Name | Name of the field in the database. |
   | Field Type | Type of field. For more information on the different field types, see [Field types](https://www.servicenow.com/docs/access?context=r_FieldTypes&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US). By default, there are only 18 field types to choose from. You can add a property to include more field types in Guided Application Creator. For more information, see [Add field types in Guided Application Creator](https://servicenow-prod.fluidtopics.net/WZlD~yeoERkNjAIRGEkhuA "When you add fields to a custom table in Guided Application Creator, there are only 18 field types available by default. You can add a property to include more field types."). |
   | Display | When used as a reference field, the field is used as the display value for the table. Only one field can be defined as the display value for a table. |
   | Mandatory | Requires that the field must contain a value before the record can be saved. |
   [ ]

   {#gac-upload-spreadsheet__table_dd3_stw_5hb}
7. Select Continue to define properties and permissions for your custom table.
8. On the form, fill in the fields.  
   {#gac-upload-spreadsheet__table_b2v_pcw_5hb__entry__2}

   | Field | Description |
   |-|-|
   | Table label | Unique label for the table (such as Laptops or Thin clients). The label appears on list and form views for the table. See Field Labels in [Data dictionary tables](https://www.servicenow.com/docs/access?context=c_DataDictionaryTables&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US). |
   | Table name | Name of the table in the database. The table name is automatically populated based on the table label and the application scope that you defined earlier. |
   | Make extensible | Option to enable other tables to extend this table. For more information on table extension, see [Table extension and classes](https://www.servicenow.com/docs/access?context=table-extension-and-classes&version=yokohama&pubname=yokohama-platform-administration&ft:locale=en-US). |
   | Auto-number | Option to add a number field to the table and automatically increment the ID numbers as they get added. |
   | Manage access | User permissions for your application. For each role that you selected earlier, you can select to give your different levels of access. Create :   Enables users to insert new records (rows) into a table. Read :   Enables users to display records from a table. Write :   Enables users to update records in a table. Delete :   Enables users to remove records from a table or drop a table. |
   [ ]

   {#gac-upload-spreadsheet__table_b2v_pcw_5hb}
9. Select Continue.
10. On the confirmation screen, select Continue.
11. To add more tables to your application, follow the steps in [Designate data tables in Guided Application Creator](https://servicenow-prod.fluidtopics.net/PVqgw9Q50sa~krY18bzTQg "Select an existing table or create a custom table in Guided Application Creator to store data for your custom business application.").
12. To finish designating tables, select Done with tables.

## What to do next

Continue building your application by following the steps in [Customize user experiences in Guided Application Creator](https://servicenow-prod.fluidtopics.net/~xcqboVI6ZzPASZicytZXw#gac-customize-ux "Customize how the application appears in each user experience that you select."). If you exit Guided Application Creator,
the tables that you configured are not saved to the system.