---
title: "Batch Create & Edit Prompts - Prompt Import Source Format"
slug: "batch-create-edit-prompts-prompt-import-source-format"
updated: 2026-04-07T22:08:27Z
published: 2026-04-07T22:08:27Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://knowledge.technolutions.net/llms.txt
> Use this file to discover all available pages before exploring further.

# Batch Create & Edit Prompts - Prompt Import Source Format

While it can often be most efficient to manage prompts individually, Slate also allows for the batch management of prompts. This functionality can be especially useful when working with longer prompt lists like "Academic Interest."

Use the prompt management batch process to:

- **Insert new prompts**
- **Edit existing prompts**

> [!CAUTION]
> 🔔 Important!
> 
> We **strongly** recommend uploading prompts in batch to a test environment first. Since minor errors can be compounded when working in batch, it is important to double check your work before committing to an import. **Note**: Index values in the import cannot exceed 64 characters.

## Activating the prompt import format

First, activate the prompt import source format. Adding this format will allow you to use the Upload Dataset module to batch manage your prompts.

1. Go to **Database** → **Source Format Library**.
2. Next to **Prompt Import**with *Excel*in the Format column, select **Add**. The Add Source Format from Library popup appears.
3. Select **Add**.
4. Select **OK**. The Prompt Import page appears.

## Adding new prompts

You can add new prompts via an Excel document. For example, if you need to add additional prompts to your academic interest list, you can add new rows to your existing Excel document (that includes existing prompts) and provide configuration settings:

[![new_prompts.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/new_prompts.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/new_prompts.png)

#### What columns must be included?

To add a new prompt, provide a value for the following columns: Key, Value, and Active (Active = 1, Inactive = 0). You may include values for other columns as well. Leave the ID column blank when adding new prompt values to your spreadsheet. This lets Slate know which new prompt values to add from the spreadsheet. The length of the Key value must not exceed 32 characters.

## Downloading existing prompts

Download current prompts into the required Excel format using the standard query library.

1. Go to **Database**→ **Standard Query Library**.
2. Select **Current Prompt List**. All prompts (including precise configurations) currently stored in Slate are listed on the page.
3. Select **Download to Excel**. Each column of the Excel file corresponds with a prompt configuration setting.

[![DownloadToExcel](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/downloadprompts3.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/downloadprompts3.png)

## Editing existing prompts

You can edit existing prompt values in the Excel document. For example, if you need to add Export values to all the prompts with the key of `academic_interest`, you can add that data to your Excel document:

[![existing_prompts.png](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/existing_prompts.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/existing_prompts.png)

> [!WARNING]
> 📝 Note: Don’t edit the ID
> 
> When you upload your edits, Slate uses the ID column to match your data with the existing prompt. You may edit any other columns.

## Uploading changes

Upload the Excel file using the Upload Dataset module (Be sure to save the edits you made to the Excel file before uploading it back into Slate).

1. Go to **Database** → **Sources / Upload Dataset.**
2. Select **Upload Dataset**.
3. Configure the following settings:
  - **File Format**: Select the **Prompt Import (Excel)** format. (This is the format you activated from the source format library.)
  - **Folder**: If using folders (recommended), select the desired folder for the import, or select **Other** and enter a new folder name.
  - **Add Files**: Add your Excel file to this area by clicking **Add Files** or by dragging your file from your Windows File Explorer and dropping it into the "Drag files here" area.

[![UploadFilesDialog](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/uploadchanges3.png)](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/uploadchanges3.png)
4. When all desired files have been added, click **Upload**.

Slate will import the data, batch update the prompts that have been edited, and create new prompts for any new data rows added.

## Just need to add new prompts?

Use the blank Excel file below to add your new prompts (remember to leave the ID column blank) and then upload your file through Upload Dataset.

[Prompt_Dataset_Template.xlsx](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/prompt_dataset_template(1).xlsx)

Once the import has completed, the Status will update to "Completed." This source format is special and does not update person or dataset records, therefore, the Rows Imported value will appear as "0."

Rest assured that if the import's status appears as "Completed," the data was updated, so be sure to check the prompts to confirm the changes.

## Attachments

- [prompt_dataset_template.xlsx](https://cdn.us.document360.io/cd8ea7a6-07f3-4846-a554-627ac016d3e3/Images/Documentation/prompt_dataset_template.xlsx)