SOURCE: Vacation Tracker TITLE: Move off spreadsheets in one go URL: https://vacationtracker.io/ai-prompt-library/import-sheet/ LANG: en PUBLISHED: 2026-11-19 UPDATED: 2026-11-19 SUMMARY: Move your old leave tracker into Vacation Tracker with your AI. It matches every name, flags what it can't match and loads quotas and past leave. # Move off spreadsheets in one go Leave spreadsheet + Vacation Tracker · Policies Moving from your old leave tracker? Your AI matches every row to a person in Vacation Tracker, flags names it can't match, and loads quotas and past leave once you confirm. ## What you ask ``` Here's our old leave tracker: your leave spreadsheet. Match each row to a person in Vacation Tracker, set their 2026 vacation quota from the allowance column, and log the leave they've already taken this year. List anyone you can't match before you change anything. ``` Attach the file in your AI tool before you send. It stays in your AI conversation. ## Before you start - Who it's for: People Ops - Plan: Core or Complete - Safety: People must already be in Vacation Tracker. Nothing changes until you confirm. - Works in: Claude (https://vacationtracker.io/integrations/mcp/claude/), ChatGPT (https://vacationtracker.io/integrations/mcp/chatgpt/), Gemini (https://vacationtracker.io/integrations/mcp/gemini/), Copilot (https://vacationtracker.io/integrations/mcp/copilot-studio/), Grok (https://vacationtracker.io/integrations/mcp/grok/), Perplexity (https://vacationtracker.io/integrations/mcp/perplexity/), Cursor (https://vacationtracker.io/integrations/mcp/cursor/), Windsurf (https://vacationtracker.io/integrations/mcp/windsurf/), Cline (https://vacationtracker.io/integrations/mcp/cline/) ## What your AI does - Reads messy spreadsheets, merged cells and all - Matches nicknames and typos to real people - Flags rows it can't match ## What it touches in Vacation Tracker - Reads: Finds each person - Changes: Sets their quota - Changes: Logs leave already taken ## What you get back (Sample workspace. People and numbers are made up.) AI: Matched 46 of 48 rows. Couldn't match “J. Smith” (two Jennifer Smiths) or “Ollie” (no one by that name). Ready to set 46 quotas and log 212 days of past leave. Go ahead? ## Try these policy prompts next - Make Vacation Tracker match your handbook (https://vacationtracker.io/ai-prompt-library/handbook-sync/): Finds every gap between your handbook and your settings, then fixes them. - Check your policies against local law (https://vacationtracker.io/ai-prompt-library/law-check/): Checks each location against its legal minimums and cites the source. - Open a new office, fully set up (https://vacationtracker.io/ai-prompt-library/new-office/): Researches local law and holidays, then sets up the location once you approve.