Loading...
Loading...
Enables Claude to create, edit, and analyze spreadsheets in Microsoft Excel Online via Playwright MCP
npx skill4agent add andrejones92/canifi-life-os microsoft-excelcurl -sSL https://canifi.com/skills/microsoft-excel/install.sh | bashcp -r skills/microsoft-excel ~/.canifi/skills/# First, ensure canifi-env is installed:
# curl -sSL https://canifi.com/install.sh | bash
canifi-env set MICROSOFT_EMAIL "your-email@outlook.com"canifi-env set SERVICE_EMAIL "your-email"
canifi-env set SERVICE_PASSWORD "your-password"User: "Create an expense tracker in Excel"
Claude: Creates new workbook "Expense Tracker", adds columns for
Date, Category, Description, Amount. Adds SUM formula for total.
Returns: "Created expense tracker: [link]"User: "Create a pivot table from my sales data"
Claude: Selects data range, inserts pivot table,
configures rows, columns, and values.
Confirms: "Pivot table created showing sales by region and product"User: "Make a line chart showing revenue trends"
Claude: Selects revenue data, inserts line chart,
adds titles and labels. Confirms: "Revenue trend chart created"User: "Add a formula to calculate profit margin in column E"
Claude: Enters formula =(D2-C2)/D2 for margin calculation,
applies to all rows. Confirms: "Profit margin formula applied"// New workbook
'[aria-label="New blank workbook"]'
// Workbook name
'[aria-label="Workbook name"]'
// Cell input
'.formulabar-input' or 'input[name="Cell"]'
// Active cell
'[aria-selected="true"]'
// Ribbon tabs
'[role="tablist"]'
// Insert tab
'[aria-label="Insert"]'
// Formulas tab
'[aria-label="Formulas"]'
// Data tab
'[aria-label="Data"]'
// Chart button
'[aria-label="Insert chart"]'
// Sort button
'[aria-label="Sort"]'
// Filter button
'[aria-label="Filter"]'=SUM(A1:A10) // Sum range
=AVERAGE(A1:A10) // Average
=VLOOKUP(key,range,col,0) // Vertical lookup
=IF(condition,true,false) // Conditional
=COUNTIF(range,criteria) // Count matching
=SUMIF(range,crit,sum) // Sum matching
=TEXT(A1,"format") // Format text
=TODAY() // Current date
=CONCATENATE(A1,B1) // Join text