Import Your Excel Ticket Tracker and Get an Operational Dashboard
Move from Excel to a live operations dashboard without losing your existing data. Import your .xlsx or .xls tracker, map columns to fields, preview before committing, and get KPI views immediately.
The problem
Many delivery teams maintain their entire ticket tracker in Excel. It works until leadership asks for a revenue summary, a dashboard, or a view that separates one project from another — and the manual effort begins all over again.
Why switching tools is painful — and why import solves it
- —Most tools require manual re-entry of historical tickets — a multi-day exercise for any team with 6+ months of data.
- —CSV imports in generic tools lose field mappings, custom columns, and revenue data.
- —Getting leadership buy-in to switch tools is difficult when there is no existing data to demonstrate value.
How Ask VAI handles this
Ask VAI's import tool accepts your existing .xlsx or .xls file, lets you map your column headers to system fields, previews the result before committing, and gives you a full operations dashboard as soon as the import is complete.
- Upload .xlsx or .xls — no CSV conversion required.
- File validation: only genuine Excel files are accepted — malicious files are rejected at upload.
- Column mapping UI: match your header names to Ask VAI fields.
- Preview before commit: see how many rows will import, how many have warnings, and what data will be created.
- Revenue impact field support: import existing revenue values and get leakage views immediately.
- Row limit of 5,000 per sheet — suitable for large operational trackers.
How it works
- 1
Upload your Excel file
Drag and drop or browse to select your .xlsx or .xls file. The file is validated immediately to confirm it is a genuine Excel file.
- 2
Map columns to fields
The import UI shows your column headers and lets you map each to a Ask VAI field: description, status, severity, revenue impact, assignee, project, and more.
- 3
Preview the import
Before committing, see a summary: how many rows will be created as tickets, how many have mapping warnings, and what values have been normalized.
- 4
Commit and review
Confirm the import. Tickets are created in your organization with the data from your Excel file — including revenue impact values and project assignments.
- 5
Open the dashboard
The operations dashboard, revenue leakage view, and KPI summaries are available immediately — reflecting your imported data.
Who benefits and how
Org Admin
Upload and manage the import process. Map columns, review warnings, and commit the import when the preview is confirmed.
Manager
After import, access the team workload view, ageing analysis, and project-level summaries — using data from your existing tracker.
CxO
Open the executive dashboard immediately after import to see revenue at risk, leakage, and project health — without waiting for manual report preparation.
User
See your tickets from the imported data, with ageing, revenue impact, and project assignment already in place.
An example
An operations manager at an IT services firm has maintained a 500-row Excel tracker for 18 months. Leadership asks for a revenue leakage dashboard by end of week. Using Ask VAI, the manager uploads the existing file, maps the 12 column headers in under 10 minutes, reviews the preview — which shows 487 valid rows and 13 with missing project assignments — commits the import, and opens the revenue leakage dashboard. The whole process takes less than 30 minutes.
Frequently asked questions
What file formats are supported?
Ask VAI accepts .xlsx (Excel 2007 and later) and .xls (Excel 97-2003) formats. Files are validated at upload using file-signature checking — only genuine Excel files are accepted.
Is there a row limit for imports?
The import tool supports up to 5,000 rows per sheet and 10,000 rows total across all sheets in a single import file. For larger trackers, contact support to discuss options.
What happens if some rows have missing data?
The preview step shows warnings for rows with missing required fields or data that cannot be mapped. You can review these before committing — either accepting that some rows will be imported with partial data, or going back to update the source file.
Can I import revenue impact values from my Excel file?
Yes. Revenue impact is one of the supported import fields. If your Excel tracker has a column for revenue impact or financial value, map it during the import process. After the import, those values are available in the revenue leakage dashboard immediately.
Can I do multiple imports?
Yes. Multiple imports are supported. Each import creates a new batch of tickets with their own import log — so you can track which tickets came from which import. Duplicate detection is based on reference ID if that field is mapped.