Documentation
Getting Started
1. Install CellPilot
Visit the Google Workspace Marketplace and search for "CellPilot". Click "Install" and grant the necessary permissions.
2. Open in Google Sheets
Open any Google Sheets document. You'll find CellPilot in the Extensions menu.
3. Start Using Features
Select your data range and choose from our powerful features in the sidebar.
Core Features
Remove Duplicates
Quickly identify and remove duplicate entries from your data.
- Select the range containing potential duplicates
- Click "Remove Duplicates" in the CellPilot sidebar
- Choose which columns to check for duplicates
- Review and confirm the removal
Clean Text Data
Standardize and clean text data with multiple options.
- Trim extra spaces
- Convert case (upper, lower, title)
- Remove special characters
- Fix encoding issues
Formula Builder
Generate complex formulas by describing what you need in plain language.
- Describe your calculation needs
- CellPilot generates the appropriate formula
- Preview the formula before applying
- Learn from generated examples
Email Automation
Set up automated email alerts based on your spreadsheet data.
- Configure trigger conditions
- Customize email templates
- Schedule regular reports
- Track email history
Advanced Features
Data Validation
Ensure data integrity with custom validation rules and automatic error detection.
Automatic Backups
Every operation is preceded by an automatic backup for easy undo.
Batch Operations
Apply operations to multiple sheets or ranges simultaneously.
Usage Analytics
Track your usage patterns and optimize your workflow.
Keyboard Shortcuts
Troubleshooting
CellPilot menu doesn't appear
Refresh your browser and ensure you've granted all necessary permissions. Try reinstalling the add-on if the issue persists.
Operations are running slowly
Large datasets may take time to process. Consider breaking your data into smaller chunks or upgrading to a paid plan for faster processing.
Formula builder returns errors
Ensure your description is clear and specific. Check that referenced cells and ranges exist in your sheet.