Guides for franchise teams
Learn how to avoid CSV problems when collecting reports from every location.
Why Franchise Sales Reports Don't Combine
Store IDs, periods, gross vs net, sales tax and duplicate reports, with the fix for each.
How to Collect Data When Clients Use Different Excel Spreadsheets
Every location has its own version of the template. Here's how to fix that.
How to Combine Multiple CSV Files
Merge reports from every location into one file.
How to Prevent Users From Adding or Deleting Columns in Excel
Keep every location's report in the same layout.
How to Enforce Dropdowns in Excel
Keep store names and IDs consistent.
How to Strip Currency Symbols from CSV Price Columns
Clean sales and cost figures before consolidating.
How to Handle Blank and Empty Cells in CSV
Stop incomplete location reports reaching head office.
NAP Consistency Guide
Keep every location's name, address and phone the same on every listing.
Google Business Profile Bulk Upload Errors
Fix store codes, names, phones, websites and categories in bulk uploads.
Google Business Profile Bulk Verification
Verify 10+ locations at once, and avoid the usual delays.
Collecting Location Details from Clients
One master list of every location, ready for every listing platform.
Ready to collect location data the right way?
These guides cover common CSV problems. Import Builder prevents them before they happen.