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

See more

Add Holiday Hours to Entities via Spreadsheet Upload

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 use the File Upload tool to add holiday hours for your business. If you prefer to do this by selecting location entities directly in the Knowledge Graph, see Add Holiday Hours to an Entity.

Upload Holiday Hours

  1. Click Knowledge Graph in the navigation bar and click Entities.
  2. Click Add Data at the top of the Entities table.
  3. In the modal that appears, select the Entity Upload option under Data File Uploads.
  4. Click Choose File to upload your spreadsheet. See the attachment below for an upload template.
  5. If you have a previously saved file upload configuration you'd like to use, click Select Configuration and choose it from the list. Otherwise, choose No, this is a new spreadsheet.
  6. Click Continue.
  7. Match the columns from your file to the relevant Holiday Hour fields by selecting the desired field from each dropdown. 
  8. If you want to update any data cleansing rules, click Edit to the right of each column and select your preferred option.
  9. If any columns contain split time intervals (e.g., "9 am-12 pm, 1 pm-5 pm") uncheck the Comma checkbox. This prevents the upload tool from treating the comma as a delimiter and allows both time intervals to be applied correctly to the same day.

    Add_holiday_hours_through_spreadsheet_upload_screenshot.png
  1. Click Continue.
  2. Follow the steps in the upload flow until your upload has been completed. For more information, see Add and Edit Entities via Spreadsheet Upload.

Set Up 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.

Ensure you include the following fields in your upload file:

  • Entity ID
  • Date
    • Enter the date you would like to specify hours for in MM/DD/YY format.
  • Times
    • Specify your holiday hours in the form of a time range (e.g., "9 am-5 pm").
    • Acceptable time formats: 3:00 PM, 3:00 pm, 1500, 15:00
    • If there are multiple intervals in the same day, separate intervals in the same cell with commas. For example, if the location is open from 9am-12pm and 1pm-5pm, input "09:00-12:00,13:00-17:00"
    • For 24-hour service, input "12:00 AM to 12:00 AM".
    • If the location is closed entirely on a certain day, input "closed" or "x".

 

Attachment