ZKutools Anywhere for Excel

Work faster in Excel with AI and practical productivity tools.

ZKutools Anywhere for Excel combines an intelligent AI assistant with a comprehensive collection of everyday spreadsheet tools. Create formulas, analyze data, organize large workbooks, clean and transform content, and automate repetitive tasks—all without leaving Excel.

Describe what you need in plain language, review the generated result, and apply it directly to your workbook. For tasks that do not require AI, use the built-in navigation, text, conversion, data management, and insertion tools to complete common Excel operations more efficiently.

Key benefits:

• Ask AI and generate Excel formulas: Get help with spreadsheet questions and turn plain-language requirements into ready-to-use Excel formulas. Generate simple formulas, formulas with error handling, Microsoft 365 dynamic array formulas, or compatibility-focused alternatives.
• Create smarter tables and data analysis: Generate table structures, create conditional formatting rules, build advanced filters, configure multi-level sorting, and add data validation rules based on natural-language instructions.
• Build PivotTables with AI: Analyze selected data, receive recommended PivotTable schemes, configure row, column, filter, and value fields, and apply the selected analysis directly to a new worksheet.
• Process entire ranges in bulk: Clean, rewrite, translate, format, and extract information from selected cell ranges. Extract names, addresses, companies, entities, events, and other structured information from unorganized text.
• Navigate large workbooks more easily: Quickly search, switch, and bookmark worksheets. Find columns, move directly to them, and show or hide columns without repeatedly scrolling through large spreadsheets.
• Match and update data between tables: Match records using key columns and update selected fields in a main table with corresponding values from a lookup table.
• Split large datasets: Divide a selected range into multiple worksheets based on column values or a specified number of rows, with original formatting, row heights, and column widths preserved.
• Clean and transform text in bulk: Change text case, add text at different positions, remove unwanted spaces or characters, delete content by position, reverse text, extract specific content, and perform rule-based replacements across selected cells.
• Convert and restructure spreadsheet data: Round numbers using different methods, correct or change number signs, spell out numeric values, convert between Roman and Arabic numerals, recognize date text, convert currencies, and transform ranges between different layouts with a live preview before applying.
• Merge and combine cells flexibly: Merge selected cells or combine the contents of rows, columns, or ranges into a single cell using your own separator, with a preview of the result and support for undo.
• Insert and generate worksheet content: Create QR codes and barcodes from cell values, batch insert local or online pictures, match pictures by file name, generate sequence numbers, and fill ranges with random numbers, dates, times, text, or custom list items.
• Find number combinations: Identify combinations of values from a list that add up to a specified target. This is useful for reconciliation, order matching, expense checking, and other financial or operational tasks.
• Repeat and recover operations: Undo supported ZKutools operations or quickly repeat the most recently used command.

Works directly inside Excel:

After installation, open the ZKUTOOLS tab in the Excel ribbon, choose the tool you need, and start working with your worksheet or selected cell range.

Designed for everyday Excel work:

ZKutools Anywhere for Excel is useful for professionals working with reports, customer records, product lists, financial data, operational spreadsheets, survey results, imported data, and other workbooks that require frequent cleanup, transformation, organization, or analysis.

Use AI when a task benefits from natural-language understanding, and use the built-in spreadsheet tools when a faster, predictable operation is more appropriate.

Important: AI-generated formulas, analysis, formatting rules, and content should be reviewed before use in important or business-critical workbooks.

AI Features

Use the built-in Kutools AI service and receive a free token allowance to get started. After the free tokens are used, a paid subscription is required only to continue using Kutools AI.

You can also connect your own AI service instead. Supported providers include OpenAI (ChatGPT), GoogleAI (Gemini), AzureAI, DeepSeek, Alibaba Cloud DashScope (Qwen), Zhipu AI (GLM), Baidu (ERNIE), and SenseNova, as well as any custom, OpenAI-compatible endpoint. Usage limits and charges for these services are determined by the corresponding AI provider.

Free Non-AI Tools

All non-AI tools are completely free to use, including workbook navigation, column management, text processing, data matching and splitting, format conversion, insertion tools, and more.

Support: For product assistance, documentation, or technical support, visit https://www.extendoffice.com/support.html.