What is CSVMacro

Discover CSVMacro, an intuitive online tool designed to simplify the process of editing your CSV and Excel files. With its user-friendly interface, CSVMacro focuses on efficiently manipulating entire rows and columns, enabling you to transcend the tedious task of editing cell by cell.

Our objective

The primary objective of CSVMacro is to facilitate the creation of transformation processes for spreadsheets, ensuring their seamless reusability. By effortlessly establishing a desired transformation, you can effortlessly accomplish tasks such as removing unwanted lines, adding and transforming columns, reordering columns, performing search and replace operations (including support for regular expressions), and appending prefixes or suffixes to your data.

Once you have achieved your desired transformation, CSVMacro allows you to export the applied edit steps. This invaluable feature empowers you to effortlessly apply the same transformation to similar files, significantly reducing the time and effort required for repetitive spreadsheet tasks.

Experience the efficiency and convenience of CSVMacro - a tool that simplifies batch editing of CSV and Excel files, ultimately empowering you to save precious time and streamline your data processing workflow.

While it caters to various individuals, it particularly shines for those in the tech department who frequently handle diverse data exports in spreadsheet format. CSVMacro empowers these professionals to maximize their productivity by efficiently crafting sets of transformation steps for application across multiple files. However, it's worth noting that the tool may not suit everyone's needs, as its primary focus lies in facilitating the creation and reuse of transformation processes.

What is still missing?

As an evolving project, CSVMacro continues to expand its functionality. Presently, the tool supports the uploading of Excel files with multiple sheets, although only the first sheet is utilized. We acknowledge this limitation and appreciate your understanding.

In our quest to enhance CSVMacro, we aim to introduce custom transformation functions in Javascript. However, due to security concerns associated with executing untrusted Javascript code, this feature will only be implemented in the desktop application version of our online tool. Once available, this addition will grant users unparalleled control, enabling the implementation of desired changes through concise lines of code, including powerful math functions. Stay tuned for these advancements.