Import availability
You can import availability rules from a CSV or Excel file instead of entering them manually. Find Me Time always shows a preview before making changes.
Plan requirements
Free includes import from CSV or Excel and pasting a custom YAML recipe for one-off imports. Pro adds saved custom recipes you can reuse.
Live conflict checks use connected Google and Microsoft calendars. See Integrations.
What you can import
An import can add:
- recurring available hours, such as Monday to Friday from 09:00 to 17:00
- recurring unavailable times, such as lunch from 12:00 to 13:00
- exceptions for specific dates, such as holidays, travel, or temporary hours
- optional pattern details, when supported by the selected format
Recommended: Find Me Time Format
The easiest option is to use the Find Me Time Format template. It works with both CSV and Excel and does not require a custom mapping.
Required column headers
Weekday,Start Time,End Time,Free or Busy,Start Date,End Date,Name
Column names must remain in English, but the Name column may contain any language. Prefer UTF-8 CSV. Japanese Windows Excel CSV using Shift_JIS or CP932 is also accepted.
What each column means
Weekday
The weekday for a recurring rule, using Mon, Tue, Wed, Thu, Fri, Sat, or Sun. Leave it empty for rows that use specific dates.
Start Time
The beginning of the time range. Leave it empty to use the start of the day when the row type supports an all-day range.
End Time
The end of the time range. Leave it empty to use the end of the day when the row type supports an all-day range.
Free or Busy
Use Free for available time and Busy for unavailable time. An empty value is treated as Free in Find Me Time Format.
Start Date
The first date of a one-time exception. Leave it empty for recurring weekday rules.
End Date
The final date of an exception. For a single-day exception, use the same date or leave it empty if supported by the preview.
Name
An optional label such as Lunch, Holiday, Business trip, or Summer hours.
How rows are interpreted
No dates + Free
Creates recurring availability.
No dates + Busy
Creates recurring unavailability.
Dates + Busy
Creates an unavailable date exception. If no times are provided, it is treated as an all-day exception.
Dates + Free
Replaces the normal availability for those dates with the specified available hours.
Example
This example creates weekday availability, a repeating lunch break, one unavailable holiday, and one day with replacement hours.
Weekday,Start Time,End Time,Free or Busy,Start Date,End Date,Name
Mon,09:00,17:00,Free,,,Weekday hours
Tue,09:00,17:00,Free,,,Weekday hours
Wed,09:00,17:00,Free,,,Weekday hours
Thu,09:00,17:00,Free,,,Weekday hours
Fri,09:00,17:00,Free,,,Weekday hours
Mon,12:00,13:00,Busy,,,Lunch
Tue,12:00,13:00,Busy,,,Lunch
Wed,12:00,13:00,Busy,,,Lunch
Thu,12:00,13:00,Busy,,,Lunch
Fri,12:00,13:00,Busy,,,Lunch
,,,Busy,2026-08-11,2026-08-11,Holiday
,10:00,15:00,Free,2026-08-14,2026-08-14,Short day
Dates and times
Use a consistent format throughout the file. ISO dates such as 2026-08-14 are recommended because they are not ambiguous. Avoid values such as 03/04/2026 unless you clearly know whether they mean 3 April or March 4.
Use normal clock times such as 09:00 or 17:30. Check the preview carefully when importing spreadsheet-formatted dates or times.
Files with different column names
If your existing spreadsheet cannot be changed to match Find Me Time Format, choose Custom YAML recipe in the import wizard. A recipe describes how your columns correspond to Find Me Time fields.
A custom recipe can
- match different column names
- separate different row types in the same sheet
- convert supported weekday, date, and time formats
- map rows into recurring availability, recurring unavailability, or date exceptions
A custom recipe does not
- change the original CSV or Excel file
- apply changes automatically
- run scripts, formulas, macros, or other executable code
- import Google Calendar events or busy-time exports as availability rules
Using AI to create a custom recipe
You may ask an AI assistant to draft a custom YAML recipe. Give it the complete header row, two or three representative sample rows, and any details about date, time, weekday, or status formats.
Replace names, email addresses, notes, and other private values with anonymized examples before sharing spreadsheet samples.
An AI-generated recipe is only a draft. Find Me Time validates it and shows the resulting changes in the preview. Review the preview before selecting Apply.
Information to give the AI
File type: CSV or XLSX
Header row:
[paste the complete header row]
Sample rows:
[paste 2-3 representative rows]
Date format:
yyyy-mm-dd, dd/mm/yyyy, mm/dd/yyyy, or other
Time format:
for example 09:00, 9:00 AM, or Excel time values
Weekday format:
for example Mon, Monday, 月, or numeric values
Status meanings:
for example Available = free, Blocked = busy
Additional notes:
[explain blank values, multiple sheets, or unusual rows]
Google Calendar data
Do not import Google Calendar event lists or free/busy exports into an availability pattern. Calendar events describe existing commitments, while an availability pattern describes the hours you normally offer.
When Google or Microsoft Calendar is connected, Find Me Time checks calendar conflicts separately while calculating bookable times.
Preview before applying
Uploading a file or pasting a custom recipe does not immediately change the pattern. Find Me Time first parses the file and shows what will be added or changed.
Review the preview carefully:
- check the detected timezone and pattern details
- confirm recurring available and unavailable hours
- check every date exception and date range
- review warnings, skipped rows, and validation errors
- select Apply only when the preview matches your intention
Existing pattern data
The import wizard tells you whether imported data will be added, replaced, or merged. Review this carefully before applying, especially when importing into a pattern that already contains rules.
Common problems
The standard format is not detected
Check that the headers use the exact Find Me Time Format names and that the header row is the first configured row.
Dates are interpreted incorrectly
Use ISO dates such as 2026-08-14, or configure an explicit date format in a custom recipe.
Rows appear in the wrong section
Check the Free or Busy value and whether Start Date or End Date contains a value.
A row becomes all-day
Check whether Start Time and End Time are empty. Empty times may represent a full-day range.
Rows are skipped
Open the import warnings. A row may be missing a required weekday, date, status, or time value.