How to Automate Excel

March 10th 2025

Tutorial: Power Automate

Merge CSV Files with Power Automate
Learn how to merge multiple CSV files into a single CSV file using the Encodian Flowr connector in Power Automate. This step-by-step guide covers creating a flow, merging rows from two CSV files, and sending the output via email.

James Sales

July 30th 2024

Tutorial: Power Automate

Populate Business Data in Excel Files using Power Automate
For this post, let’s explore how you can add business data (or any data) to Excel files using Encodian Flowr’s ‘Excel – Populate‘ action. This action works very similar to the ‘Word – Populate‘ and ‘PowerPoint – Populate‘ actions, using the same syntax tags.

Sophie Charlwood

Filter by:

May 28th 2021

Tutorial: Power Automate

Delete data from a CSV file using Power Automate
Deleting data from a CSV file can be a pain. This is especially true if the data is being used by a program or application that isn’t designed for easy editing.

Jay Goodison

September 14th 2020

Tutorial: Power Automate

Convert Excel and CSV Files in Power Automate
We recently released a new action, ‘Convert – Excel‘, which provides the capability to convert a multitude of different spreadsheet file formats to the following file formats a PDF, XLSX, HTML, CSV or TXT.

Jay Goodison