SheetFlash Add-in

SheetFlash is a revolutionary no-code add-in for Excel that enables users to effortlessly automate workflows and

perform advanced data transformations and analyses. Perfect for both professionals and beginners, SheetFlash offers a

suite of powerful features without requiring any programming skills.

Key Features

Automation: Automate almost every workflow within Excel, saving significant time and costs.

Workflow Recording: Easily track and document complex data transformations, making it useful for
repetitive tasks and handovers.

Advanced Functionality: Perform advanced functions that are not possible in standard Excel,
enabling complex tasks to be completed without any coding experience.

High Speed: Handle large datasets swiftly, processing tasks that typically take an hour in Excel
within minutes, greatly expanding Excel's capabilities.

Simple Interface: Intuitive design makes setting up and managing action cards straightforward.

Seamless Integration: Works directly within your existing Excel environment, ensuring a smooth
and familiar user experience.

Available Functions

File Processing

Merge Files: The Merge Files function is a feature that allows you to combine two or more files
into a single file. You can select the merge pattern [One Sheet / Separated Sheets] and choose the merge direction
[Vertical / Horizontal]. The output can be receiced as either csv, xlsx or array that can be shown on the opening
file.

Split File: The Split File function is a feature that allows you to split a file into multiple
files. You can specify how to split by[Number of Files / Number of Rows]. The output can be receiced as either csv
or xlsx.

Sheet Processing

Merge Sheets: The Merge Sheets function is a feature that allows you to combine data from
multiple sheets within a single workbook into one sheet. You can select the merge direction [Vertical / Horizontal].

Add Sheets: The Add Sheets function is a feature that enables you to efficiently create multiple
new sheets in bulk within a workbook, based on names you specify.

Delete Sheets: The Delete Sheets function is a feature that deletes the sheets in bulk using the
radio buttons.

Basic

Copy and Paste: The Copy and Paste function is a feature that enables you to duplicate content
from one location and insert it into another.

Native Functions: The Native Functions is a feature that enables you to input a function at the
beginning of the targeted data range and then apply it to the entire selected range using autofill, streamlining the
process of performing operations or calculations across multiple cells or rows.

Text Processing

Add Letters: The Add Letters function is a feature that enables you to automatically append
letters or text to specific data within your cells, enhancing data consistency and readability.

Join Texts: The Join Letters function is a feature that allows you to concatenate text from
multiple cells into one cell, using a specified delimiter.

Replace Words: The Replace Words function is a feature that enables you to systematically search
for and replace specified text across your workbook. It offers the capability to set up multiple replacement rules,
allowing you to execute several search-and-replace actions in one go.

Replace by Regex: The Replace by Regex function is a feature that leverages regular expressions
(regex) to perform sophisticated search and replace operations across your workbook. It offers the capability to set
up multiple replacement rules, allowing you to execute several search-and-replace actions in one go.

Sort Letters: The Sort Letters function is a feature that allows you to alphabetically sort the
characters within a cell.

Trim: The Trim function is a feature that removes extra spaces from text within your cells,
except for single spaces between words.

Text Extraction

Extract Segmented Strings: The Extract Segmented Strings function is a feature that enables you
to selectively extract parts of strings based on specified delimiters within your cells.

Extract Words: The Extract Words function is a feature that allows you to identify and extract
specific words or phrases from a selected range of cells.

Extract by Regex: The Extract by Regex function is a feature that allows you to use regular
expressions (regex) for advanced text extraction.

Data Analysis

Countifs: The Countifs function is a feature that allows you to count the number of cells that
meet multiple criteria across different ranges.

Sumifs: The Sumifs function is a feature that allows you to sum the values in a range based on
one or more criteria.

Table Manipulation

Deduplicate: The Deduplicate function is a feature designed to remove duplicate rows from your
selected data range.

Expand: The Expand function is designed to separate and distribute data from a single column into
multiple rows or columns based on a delimiter you specify.

Fill Empty: The Fill Empty function is a feature that automates the process of filling empty
cells within a specified data range, offering several options to customize how these blanks are addressed.

Filter: The Filter function is a feature that allows you to refine and display data from a
specified range based on criteria you define.

Group: The Group function is a feature that allows you to aggregate and summarize data based on
specified criteria, enabling you to organize large datasets into meaningful groups for analysis.

Sort: The Sort function is a feature that allows you to use the native sort functionality in
Excel.

Join / Lookup

Join Tables: The Join Tables function is a feature that allows you to combine data from two or
more tables based on a related column between them. Typically, joining multiple tables is an advanced table
manipulation technique performed by executing query statements on a database. However, this function enables you to
perform such operations directly within Excel, without the need to write any query code.

Lookup: The Lookup function is a feature that allows you to search for a specific value within a
data range and return a corresponding value from a different column within the same range. This function serves as
an advanced alternative to Excel's VLOOKUP, offering enhanced flexibility. Unlike VLOOKUP, which can only return the
first match it finds, this Lookup function provides options to retrieve all matching entries, the first matching
entry, or the last matching entry.

AI

Generative AI: The Generative AI function is a feature that allows you to apply
ChatGPT/Claude/Gemini to each cell in an Excel spreadsheet, generating text, insights, or suggestions based on the
data in that cell.

Date and Time

Convert Number to Date: The Convert Number to Date function is a feature designed to transform
numerical values representing dates in Excel into actual date formats. This feature addresses a common problem faced
by many Excel users, where dates are displayed based on numeric values, making it challenging to handle dates
directly as text.

Subscription Pricing

Free

$0 per month

Access to all features

Unlimited executions

Save up to 1 project

Up to 5MB per action

Standard

$4.99 per month

Access to all features

Unlimited executions

Save up to 5 projects

Up to 100MB per action

Premium

$8.99 per month

Access to all features

Unlimited executions

Save up to 10 projects

Up to 500MB per action

Potential Incompatibilities

If your Excel meets any of the following conditions, SheetFlash may not function:

If you are using a version of Microsoft 365 earlier than 16.0.11629 on Windows 10, especially when using Internet
Explorer 11 (Trident) or an older version

If you are using a version of Microsoft 365 version 16.0.11629 or later on Windows 10 without Chromium-based Edge
WebView2 installed

Contact Us

For more information, visit our website or contact our support team.

SheetFlash

作成者: SheetFlash