Moving from spreadsheets or paper to TrackOver
If your business lives in Excel or Google Sheets, download the sheet (Google Sheets: File, Download, CSV or Excel) and drop it in. Column names like Name, Phone, Address or Unit # are matched for you, and you can change any match before importing. On paper? Type your customer list into one sheet first, or add customers straight into TrackOver as their next job comes up.
Switching takes one afternoon: 3 files, 4 steps each. Do the rest whenever you like.
Start with customers, open jobs and your prices. Add the rest when you need it.
We'll move it for you, free
We'll move the data for you, free. Email your export files to support@trackover.io and we'll load them, check them with you, and tell you what came over.
Rather not do it yourself? Book the free setup call and we sit down with you and get it loaded.
Every paid plan starts with a 7-day free trial. The free plan needs no card and doesn't expire.
What comes over
- CustomersCustomers, with the address kept
- JobsJobs
- PricesYour price book
- LeadsLeads, all starting as New
- EquipmentEquipment, with hour meters and VINs
- CrewTeam members, switched off until you turn them on
What does not come over
- Photos and attachments. Take new ones on the job in the app and they stay with the job.
- Time entries and pay history. Crew clock in fresh from the day you switch.
- Payments. Invoices come in as history for reference only, not as money owed.
- Reminders, automations, templates and custom forms from your old tool. Set those up again in TrackOver.
- Logins. Team members come in switched off until you turn them on.
The steps, in order (3 lists to start)
- 1
Download your lists from a spreadsheet
Save each sheet as CSV or Excel. One file per list: customers in one, jobs in another.
- 2
Drop the file into TrackOver
Sign in as the owner or a manager, go to trackover.io/import, pick what the file holds (Customers, Jobs, Price book and so on), and drop it in.
- 3
Check the columns and the rows
We match the columns for you and show every row. Fix a match with one dropdown if it's wrong.
- 4
Import, and undo if you need to
Rows are saved in batches while you watch. If it isn't what you wanted, Undo takes the whole import back out for 24 hours.
Good to know
- A title line or a blank row above your headers is fine: we find the header row.
- Semicolon- and tab-separated files work too.
- Coming off paper, start with customers and open jobs. Old finished jobs can stay in the filing cabinet.
- CSV and Excel (.xlsx) files both work, up to 4 MB and 20,000 rows each. Split a bigger list into a few files.
- You see every row before anything is saved: what's ready, what's already in TrackOver, and what can't come in and why.
Safe by design
- See it before it's savedEvery row is checked first. Rows that can't come in say why, and you can download them to fix.
- No duplicates, nothing overwrittenAnything already in TrackOver is skipped, never changed. Same name but different phone and email? You decide.
- Undo for 24 hoursOne tap takes an import back out. Anything your team has worked on since stays.
- No automatic textsImported customers and leads aren't signed up for automatic texts like reminders and follow-ups until they've said yes.
- No surprise seatsImported team members come in switched off: no login, no invite, no charge until you turn them on.
- Owners and managers onlyOnly the office can import, and everything stays inside your company's account.
Common questions
What can I bring over from spreadsheets or paper?
Customers: Customers, with the address kept. Jobs: Jobs. Prices: Your price book. Leads: Leads, all starting as New. Equipment: Equipment, with hour meters and VINs. Crew: Team members, switched off until you turn them on.
How long does the import take?
Minutes per file. The longer part is deciding what to bring: start with customers, open jobs and your prices, then add the rest when you need it.
What if the import goes wrong?
Nothing is saved until you have seen every row. After it is saved, Undo takes the whole import back out for 24 hours, and anything your team has worked on since stays.
Will my imported customers get texts?
No. Imported customers and leads aren't signed up for automatic texts like reminders and follow-ups until they've said yes.
Is there a free trial?
Yes. The free plan needs no card and doesn't expire, and every paid plan starts with a 7-day free trial.
Can someone help me with the export?
Yes, and we'll do the move for you at no charge. Email your export files, or just where you are stuck, to support@trackover.io.
Every paid plan starts with a 7-day free trial. The free plan needs no card and doesn't expire.
Questions about an export? Email support@trackover.io.