Author sheets in. One clean master out.
SheetPilot merges author workbooks, refreshes your site list with new prices, moves removed sites to the end of the sheet, and finds any domain inside a Google Sheet. It runs on this website, so there is nothing to install.
Three steps, no manual work
Pick a tool, attach your workbooks and download the finished file. Matching, pricing and cleaning happen on their own.
Choose a tool
Consolidate for author sheets, Update master for your site list, or Find URLs to search a Google Sheet.
Attach your files
Drag the .xlsx workbooks into the box or use Browse. The master file is only needed when you update.
Run and download
Press the main button, check the summary, then download the finished workbook. Uploads are deleted right after the run.
Ready when you are
Pick a tool on the left and attach your workbooks to begin. Runs are private and are removed automatically.
What each tool does
Every tool keeps your column order and sheet structure. The site administrator can switch any tool off in SheetPilot → Settings.
Consolidate sheets
Merge every author workbook into one clean file. Each author keeps a tab and the main list groups sites by country.
- Duplicate domains merged
- Prices recalculated
- One file for author review
Update master
Compare the master with fresh author sheets. Prices update, new sites are added, and sites that vanished move to the end.
- New prices applied
- Green added and red removed blocks
- Country and category tabs rebuilt
Find URLs
Paste a Google Sheet link and a list of URLs. SheetPilot returns the full row from every tab where each domain appears.
- Searches every tab
- Shows matches and misses
- Download the results
How a written price is read
Symbols and words decide the currency. A number with no symbol uses the default from Settings, so “20” always becomes the same result.
Examples with the default rates
Your administrator can change every rate and add-on in Settings → Pricing rules.
A plain number above the threshold (400 by default) counts as PKR, so a large number is never multiplied by the dollar rate.
Quick answers
Where are my files stored?
Uploads and results sit in a private folder inside WordPress uploads that blocks direct web access. Uploads are deleted as soon as a run finishes, and the run folder expires after 10 minutes.
Which files can I upload?
Only .xlsx workbooks. If you have an old .xls file, open it in Excel or Google Sheets and save it as .xlsx first.
Do I need a Google account?
No. Only the site administrator connects Google once, and only for Find URLs. Consolidate and Update work without it.
Where are added and removed sites listed?
When you update the master, a green block lists the new sites and a red block lists the removed sites. Both sit at the end of the main sheet, after the country groups.
Can a tool be turned off?
Yes. The administrator can disable any tool in SheetPilot → Settings → Tools. It disappears from the workspace and its endpoint rejects runs even if someone calls it directly.
Ready to clean up your sheets?
Open the workspace, pick a tool and attach your workbooks. Nothing to install and nothing to sign up for.