Upload Entities to Yext – Yext Help

This article covers how to add and edit entities in your account in bulk by uploading a spreadsheet with the Entity Upload flow.

To learn how to add entities one at a time, see Add a Single Entity.

Note: Entity Upload is one way of uploading spreadsheets of entity data to the Knowledge Graph. You can also upload entity data in .CSV, .XLSX, or JSON format using the Connectors framework, which is a separate process from Entity Upload. To learn how to create a file upload connector to upload data, see the Create a File Upload Connector guide on Hitchhikers.

Before you start

Make sure your spreadsheet is formatted correctly before starting your upload:

Ensure your file is in .XLS, .XLSX, or .CSV format.
Include columns for Entity ID and Country/Region, as well as any other required fields for the entity type you are uploading.
To see all required fields by entity type and download example upload templates, see Entity Upload Templates and Required Fields.

Upload entities

To add or edit entities through spreadsheet upload:

Navigate to Entity Search (Knowledge Graph > Entities) and click Add Data.
Choose Entity Upload from the the Add Data modal.
This will open the Upload File step of the Entity Upload flow. Set the following options:
- Click Choose File to select your spreadsheet.
- If you are using a saved upload configuration to upload data in a specified format, choose your saved upload configuration from the dropdown menu.
- If you are not using an upload configuration, leave the option selected for No, this is a new spreadsheet.
- If you are uploading data in a language other than your account's default language, select the language from the dropdown menu.
- Click Continue.
On the Configure File step, map the columns in your spreadsheet to fields in Yext. The system will map columns automatically whenever possible, but you may need to select the appropriate field mapping for some columns.
- To map a column to a field, click the Map this Column dropdown menu, type the name of the field to map to, and select it from the menu.
- If you do not wish to upload field values for any of the unmapped columns in your spreadsheet, click Ignore All Unmapped Columns to skip mapping these columns to fields.
- To change the field mapping for any columns that were automatically mapped, click the dropdown menu containing the mapped field name and select a different field.
By default, each mapped column will have the following data cleansing rules set:
- Trim Whitespace: Trims trailing or leading spaces from the beginning or end of the column's value
- Ignore Blank Values: Entity Upload will skip uploading any blank cells (so that existing field values in Yext are not removed).
To change any of the data cleansing rules, click Edit next to the column you want to edit.
- Depending on the type of field being edited, different data cleansing rules may be available to choose from.
- When you're finished, click Close.
Use the Additional Fields to set any additional field values that you have not included in your spreadsheet. To set an additional field value, click Add Field.
- Note that this setting will set the same field value for all entities (e.g., setting an additional field value for the "Accepts Reservations" field will set all entities to either "Yes" or "No").
- If you want to set different field values for different entities in your upload, you should upload a new file with that field included. To do this, revise your spreadsheet, and then click More Actions in the upper right. Select Upload Revised File.
If you're adding an additional field, choose the field you want to set from the Map This Column dropdown.
- Enter the desired field value for all entities in the Field Value text box.
- Apply any data cleansing rules, if desired.
- Choose the scope of entities to apply the field: any new entities, any entities that already exist in the Knowledge Graph, or all entities in the file.
- Click Save when finished. Repeat for any other additional fields you'd like to add.
Use the Additional Actions section to add the entities in your upload to a folder, apply labels, or apply an entity template.
- Click Add Action next to the action you'd like to perform.
- Under the Select Entity Type dropdown, choose the scope of your action: any new entities, any missing entities (entities already in your Knowledge Graph that are not part of this upload), all the entities in your file, or all the entities in your account (including this current upload).
- Depending on the action you chose, select the folder, label, or template you'd like to apply.
- For more information on these actions, see Create a Folder, Manage and Apply Entity Labels, or Create an Entity Template.
After mapping all your columns and setting any additional fields or actions, click Continue in the lower right.
On the Analyze File step, the system will process your upload.
- If there were no issues with your upload, you will be brought to the Review Changes step.
- If there were issues with your upload, you will be brought to the Fix Errors step.
On the Fix Errors step, review and resolve any issues with the data in your spreadsheet. The table will display the columns with errors and the number of rows affected by each error.
Choose one of the following ways to resolve errors:
- To download a spreadsheet of errors, fix them in your file, and reupload the file: click Download Errors.
- To edit all errors directly from in the Entity Upload flow, click Fix All Errors.
- To fix just one type of error at a time in the Entity Upload flow, click Fix Errors in Spreadsheet View next to the chosen error.
- To skip uploading any field values with errors, click the dropdown arrow on the chosen error and select Ignore These Values.
If you chose to Fix All Errors or to fix a single error in Spreadsheet View, you will see the rows with errors and an explanation of the error. Enter the corrected field value for each row in the New Value column.
On the Review Changes step, you will see a breakdown of all the entities in your upload by category: new entities, updated entities, unchanged entities (present in your upload, but no data was added or changed), and missing entities (entities in your account that were not present in your upload).
- Click each hero number for more detail on the individual entities in each category.
- Click Download Entire Summary to download the breakdown for all entity categories
- Click the individual Download buttons on each category to download the summary for each category.
Click through each category in the Review Changes step. Select the checkbox at the bottom to acknowledge the change (e.g., "I acknowledge that I am adding [x] entities"), and click Next in the bottom left to go to the next category.
- This needs to be done for each category, even if there are 0 entities in the category.
After confirming the last category, click Submit Changes to confirm all changes.
On the Summary step, the system will process and apply the changes in your upload. You can monitor these changes in the progress bar at the top of the screen.
- If you want to save this upload configuration to upload more data using the same formatting options in the future, enter a name for the configuration next to the Configuration Name option and click Save.
- Otherwise, click Done or Back to Uploads to exit the Entity Upload flow.

Note: If you upload a file that drastically differs from the content you have stored inside your account, the file may be manually reviewed and approved by Yext to ensure all updates are correct and intentional.

After uploading

To view past entity uploads and your saved upload configurations, navigate to Knowledge Graph > Configuration. Click the Upload Configurations or Data File Uploads tile.