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

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.