--- title: How to import rates to Anytime from Excel description: With our rates uploader, we have the facility to upload your unit's daily pricing using an Excel spreadsheet --- [Skip to content](https://knowledgebase.anytimebooking.co.uk/knowledge/upload-rates-with-a-excel#main-content) English Show submenu for translations [![email-signature-anytime-logo-1.png\]](https://knowledgebase.anytimebooking.co.uk/hs-fs/hubfs/email-signature-anytime-logo-1.png?height=42&name=email-signature-anytime-logo-1.png)](https://knowledgebase.anytimebooking.co.uk/knowledge?hsLang=en) Open main navigation Close main navigation - English Show submenu for translations - [Contact Support](https://knowledgebase.anytimebooking.co.uk/knowledge/request-support) [Contact Support](https://knowledgebase.anytimebooking.co.uk/knowledge/request-support?hsLang=en) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://knowledgebase.anytimebooking.co.uk/knowledge?hsLang=en) 2. [Configuration and Settings](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en) 3. [Rates](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#rates) # How to import rates to Anytime from Excel ## With our rates uploader, we have the facility to upload your unit's daily pricing with an Excel spreadsheet. If you would like to upload your pricing in one batch into your Anytime Booking account, please contact us and we will send you an excel workbook sample to work from. [![excel](https://knowledgebase.anytimebooking.co.uk/hs-fs/hubfs/excel.png?width=688&name=excel.png)](https://downloads.intercomcdn.com/i/o/265541686/e516f71d08640ada3331782f/Screenshot+2020-11-12+at+09.12.40.png) What the Excel file is importing are the fields you would usually see on our rates page inside your Anytime account. Where you see tick boxes, in the file 0 = off and 1 = on. If you have a Friday change over, for example, for column I, then it would look like 0000010. [![rates excel](https://knowledgebase.anytimebooking.co.uk/hs-fs/hubfs/rates%20excel.png?width=688&name=rates%20excel.png)](https://downloads.intercomcdn.com/i/o/265542704/90ad404624bfaec0b9925d2a/Screenshot+2020-11-12+at+09.16.11.png) The most important column is having the unit ID. Without this, the rates will not know where to insert. ![excel show](https://knowledgebase.anytimebooking.co.uk/hs-fs/hubfs/excel%20show.png?width=688&name=excel%20show.png) To find your unit ID, head to Configuration \> Units \> Name. ![Screenshot 2021-08-25 at 10.27.30](https://knowledgebase.anytimebooking.co.uk/hs-fs/hubfs/Screenshot%202021-08-25%20at%2010.27.30.png?width=688&name=Screenshot%202021-08-25%20at%2010.27.30.png) And just leave the final column called 'Uploaded' blank. That's for us to note the date of the upload. It's absolutely fine to have lots of tabs for each property to create one bigger upload process. Make sure you label each tab with the property name as you go along. When you are ready, let us know and we'll send you the link to upload.  If you make a mistake, that's OK. We can re-upload. But we will need to remove any pricing beforehand and reapply the rates. Please note: online travel agents only read bookings and block-offs. Therefore if you are wanting to stop availability for certain periods ensure you have a rate band in place, and then block off the period. If you have any further questions please contact the support team (support@anytimebooking.co.uk)   - [Support and Help](https://knowledgebase.anytimebooking.co.uk/knowledge/support-and-help?hsLang=en) - [Change Log](https://knowledgebase.anytimebooking.co.uk/knowledge/change-log?hsLang=en) - [Bookings](https://knowledgebase.anytimebooking.co.uk/knowledge/bookings?hsLang=en#main-content) - [New Booking](https://knowledgebase.anytimebooking.co.uk/knowledge/bookings?hsLang=en#new-booking) - [Manage Bookings](https://knowledgebase.anytimebooking.co.uk/knowledge/bookings?hsLang=en#manage-bookings) - [Diary](https://knowledgebase.anytimebooking.co.uk/knowledge/diary?hsLang=en) - [Reports](https://knowledgebase.anytimebooking.co.uk/knowledge/reports?hsLang=en#main-content) - [Owners Reports](https://knowledgebase.anytimebooking.co.uk/knowledge/reports?hsLang=en#owners-reports) - [Emails](https://knowledgebase.anytimebooking.co.uk/knowledge/emails?hsLang=en) - [Connections](https://knowledgebase.anytimebooking.co.uk/knowledge/connections?hsLang=en#main-content) - [Airbnb](https://knowledgebase.anytimebooking.co.uk/knowledge/connections?hsLang=en#airbnb) - [Campsites.co.uk/GlampingPods.com](https://knowledgebase.anytimebooking.co.uk/knowledge/connections?hsLang=en#campsites-co-uk-glampingpods-com) - [Connecting with OTAs using API](https://knowledgebase.anytimebooking.co.uk/knowledge/connections?hsLang=en#connecting-with-otas-using-api) - [Connecting with OTAs using iCals](https://knowledgebase.anytimebooking.co.uk/knowledge/connections?hsLang=en#connecting-with-otas-using-icals) - [Payment Providers](https://knowledgebase.anytimebooking.co.uk/knowledge/connections?hsLang=en#payment-providers) - [Pitchup.com](https://knowledgebase.anytimebooking.co.uk/knowledge/connections?hsLang=en#pitchup-com) - [Connections - Other Service Integrations](https://knowledgebase.anytimebooking.co.uk/knowledge/connections?hsLang=en#connections-other-service-integrations) - [Guests](https://knowledgebase.anytimebooking.co.uk/knowledge/guests?hsLang=en) - [Your Account](https://knowledgebase.anytimebooking.co.uk/knowledge/your-account?hsLang=en#main-content) - [Going Live](https://knowledgebase.anytimebooking.co.uk/knowledge/your-account?hsLang=en#going-live) - [Annual Account Update](https://knowledgebase.anytimebooking.co.uk/knowledge/your-account?hsLang=en#annual-account-update) - [Configuration and Settings](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#main-content) - [Configuration - Glossary](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#configuration-glossary) - [Categories](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#categories) - [Units](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#units) - [Party Members](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#party-members) - [Party Details](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#party-details) - [Extras](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#extras) - [Booking Form Configuration](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#booking-form-configuration) - [Rates](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#rates) - [Deposits](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#deposits) - [Discounts and Special Offers](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#discounts-and-special-offers) - [Refresh Availability](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#refresh-availability) - [Emails](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#emails) - [Booking Summary](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#booking-summary) - [Terms and Conditions](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#terms-and-conditions) - [Referrals](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#referrals) - [Users and Access Control](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#users-and-access-control) - [Agencies](https://knowledgebase.anytimebooking.co.uk/knowledge/configuration-and-settings?hsLang=en#agencies) - [Joining Anytime Booking](https://knowledgebase.anytimebooking.co.uk/knowledge/joining-anytime-booking?hsLang=en#main-content) - [Motorhome Hire](https://knowledgebase.anytimebooking.co.uk/knowledge/joining-anytime-booking?hsLang=en#motorhome-hire) - [Touring, Camping, Glamping](https://knowledgebase.anytimebooking.co.uk/knowledge/joining-anytime-booking?hsLang=en#touring-camping-glamping) - [Website Integration](https://knowledgebase.anytimebooking.co.uk/knowledge/website-integration?hsLang=en#main-content) - [Calendars](https://knowledgebase.anytimebooking.co.uk/knowledge/website-integration?hsLang=en#calendars) - [Anytime Website](https://knowledgebase.anytimebooking.co.uk/knowledge/anytime-website?hsLang=en#main-content) - [Prepare for your website build](https://knowledgebase.anytimebooking.co.uk/knowledge/anytime-website?hsLang=en#prepare-for-your-website-build) - [Site Settings](https://knowledgebase.anytimebooking.co.uk/knowledge/anytime-website?hsLang=en#site-settings) - [Domains](https://knowledgebase.anytimebooking.co.uk/knowledge/anytime-website?hsLang=en#domains) - [Dashboard & Home Screen](https://knowledgebase.anytimebooking.co.uk/knowledge/dashboard-home-screen?hsLang=en) - [FAQs](https://knowledgebase.anytimebooking.co.uk/knowledge/faqs?hsLang=en) - [Holiday Let Agencies](https://knowledgebase.anytimebooking.co.uk/knowledge/holiday-let-agencies?hsLang=en) - [For Motorhome Hire](https://knowledgebase.anytimebooking.co.uk/knowledge/for-motorhome-hire?hsLang=en) - [System updates (roadmap)](https://knowledgebase.anytimebooking.co.uk/knowledge/system-updates-roadmap?hsLang=en) - [Pricing](https://knowledgebase.anytimebooking.co.uk/knowledge/pricing?hsLang=en) - [Contact Support](https://knowledgebase.anytimebooking.co.uk/knowledge/request-support) [![Chill listening crop-3](https://knowledgebase.anytimebooking.co.uk/hs-fs/hubfs/email-signature-anytime-logo-1.png?width=267&height=60&name=email-signature-anytime-logo-1.png "Chill listening crop-3")](http://anytimebooking.co.uk) The base of all knowledge Copyright © 2026, Anytime Booking