English (US) Čeština Deutsch Español (España) Français (France) Italiano 日本語

See more

Upload Holiday Hours to Entities

Who does this article apply to?

  • Enterprise, Partner, and Small Business accounts.
  • Accounts in all regions.

Holiday Hours allow you to specify your business hours on days when your business has an irregular schedule.

This article covers how to upload holiday hours to entities using Entity Upload or the Upload Holiday Hours tool. To add holiday hours to entities individually, see Add Holiday Hours to an Entity.

Before you start

There are three methods to upload holiday hours to entities:

See below for steps to upload holiday hours with Entity Upload or the Upload Holiday Hours tool.

Add holiday hours with Entity Upload

First, format your spreadsheet. Then, upload your holiday hours to the Knowledge Graph with Entity Upload.

Format your spreadsheet

You should only include holiday hours for days where you want the hours to differ from the location's normal business hours.

If a location is operating under normal business hours on a certain date, that date does not need to be included in the upload. Entity Upload will not accept blank cells.

Format dates in MM/DD/YY format. Format times in ranges separated by a hyphen (e.g., "9am - 5pm.)

Acceptable formats for times include:

  • 3:00 PM, 3:00 pm, 1500, 15:00
  • For 24-hour service, input "12:00 AM - 12:00 AM".
  • If a location is closed on a certain day, input "closed" or "x". 
  • If there are multiple intervals in the same day, separate intervals in the same cell with commas. For example, if a location is open from 9am-12pm and 1pm-5pm on the same day, input "09:00-12:00,13:00-17:00"

Include the following columns in your upload file:

  • Entity ID
  • Repeat these two columns depending on how many individual days you want to upload holiday hours for:
    • Hours > Holiday Hours > Date
    • Hours > Holiday Hours > Time

A sample spreadsheet for Entity Upload is attached at the bottom of this article.

 

Start the Entity Upload flow

  1. Navigate to Entity Search (Knowledge Graph > Entities) and click Add Data.

    add-data.png
  2. Choose Entity Upload from the the Add Data modal.

    choose-entity-upload.png

  3. 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.

      entity-upload-upload-file.png
  4. On the Configure File step, map the columns in your spreadsheet to the relevant Holiday Hours fields.
    • To map a column to a field manually, click the Map this Column dropdown menu, type the name of the field to map to, and select it from the menu.
  5. If any columns contain multiple time intervals (e.g., "9 am-12 pm,1 pm-5 pm") click on the mapped field and uncheck the Comma checkbox.
    • This prevents the upload tool from treating the comma as a delimiter and allows both time intervals to be applied to the same day.

      upload-holiday-hours-remove-comma.png
  1. Apply any other data cleansing rules or additional actions and click Continue.
  2. Follow the rest of the Entity Upload process. For detailed steps, see Upload Entities to Yext.

Add holiday hours with the Upload Holiday Hours tool

You can also use the Upload Holiday Hours tool to upload a spreadsheet of holiday hour data to entities.

Format your spreadsheet

The Upload Holiday Hours tool has different formatting requirements from Entity Upload.

  • The file must be in .CSV format. The Upload Holiday Hours tool does not accept .XLS/.XLSX files.
  • Each location can only have one set of holiday hours for a given day. Multiple time intervals for a given day (e.g., "9am-12pm, 1pm-5pm") are not supported.
  • All dates must be in the future. Any cells containing dates in the past will be ignored.
  • If a cell is blank, the holiday hours will be set to the current hours for the day of the week the holiday is on.
  • If a location is closed on a certain day, input "closed". The Upload Holiday Hours tool will not accept "x".
  • Format dates in MM/DD/YY format.

  • Acceptable formats for times include: 3:00 PM, 3:00 pm, 1500, 15:00

Your hours spreadsheet can be in one of two formats:

  • Days in columns: Each row represents multiple holiday hours for a single location. There will be multiple date, opening time, and closing columns.
  • Days in rows: Each row represents holiday hours for a single location on a specific day. There will be a single date, opening time, and closing time column.

You can download templates for each option during the upload process.

Use the Upload Holiday Hours tool

  1. Navigate to Entity Search (Knowledge Graph > Entities). Click the More Actions dropdown at the top of the Entities table and select Upload Holiday Hours.

    upload-holiday-hours-tool.png
  2. Review the formatting requirements, choose your file format, and upload your file.
    • Select Days in columns or Days in rows to see a preview of each format.
    • Click Download template next to each format example to download an example spreadsheet.
    • Click Choose File to upload your file.

      upload-holiday-hours-format.png

  3. Click Continue.
  4. Review and apply your changes.
    • There are no other formatting, mapping, or data cleansing options.
    • If a date is in the past, or if an Entity ID does not match an entity already in the Knowledge Graph, that update will be skipped.

      holiday-hours-review-changes.png

  5. Click Apply at the bottom of the screen. A modal will display your updates.

    holiday-hours-updated.png

 

 

Attachment

This template is for adding holiday hours with Entity Upload. If you want to add hours using the Upload Holiday Hours tool, use the templates linked in the platform.