Repeat a form-filling automation once for every row of an Excel workbook, one customer per row.
Follow the tutorial ↗APP GUIDE · EXCEL AND CSV FILES
Automate Excel and CSV files with AIVane
AIVane can read the rows of an Excel workbook, update rows by a key column and save rows as a CSV or Excel file. Use it to run an automation once for every row of a spreadsheet, or to save what an automation collected from a website as a table you open in Excel.
Where it runs and what you need
| AIVane Cloud, from your browser | Yes. In AIVane Cloud an automation can save its rows as a CSV file that you download from Run history. Reading or updating a workbook runs in the desktop app, which opens files on your computer. |
|---|---|
| Desktop app, on your computer | Yes, in the AIVane desktop app for Windows. Your computer has to be on while the automation runs. |
What you need
- For cloud runs, AIVane Cloud time: paid plans include it; Free has one 10-minute trial
- For runs on your computer, the AIVane desktop app
Connect Excel and CSV files
In your browser (AIVane Cloud runs)
- There is nothing to connect. When a run in AIVane Cloud saves its rows as a CSV file, open the run in Run history and download the file there.
In the desktop app (runs on your computer)
- There is nothing to connect. A spreadsheet step names its file by its path on your computer.
- An automation that asks for an Excel file when it runs lets you choose the file in the run dialog, for example with Use example Excel in the tutorial.
- To run an automation for every row, ask its AI assistant, for example: Run this for every row of an Excel file, one customer per row. It shows the change first; check it and choose Apply.
What AIVane can do with Excel and CSV files
- Read the rows of an Excel worksheetIn the editor: Read spreadsheet table · Runs in: desktop app
- Save rows as a CSV or Excel file, replacing it or adding rowsIn the editor: Write spreadsheet table · Runs in: AIVane Cloud and desktop app
- Update rows of an Excel worksheet by a key column and add the new onesIn the editor: Upsert spreadsheet table rows · Runs in: desktop app
- Make sure a workbook has a worksheet with the columns you needIn the editor: Ensure spreadsheet table · Runs in: desktop app
These are spreadsheet steps in the Flow editor (Read spreadsheet table and the others above). The AI assistant can add them when you describe what the automation should do with the rows; check the change before you apply it.
IDEAS
Automations you could build
Ideas, not ready-made automations, unless a link says so. Each uses only the steps above and browser or spreadsheet steps.
Collect a list spread over several web pages into a CSV file you open in Excel.
Try the verified use case ↗Keep a price list workbook on your computer current: read a supplier's page each week and update the rows by product code, adding new products at the end.
Limits
- Reading, updating and preparing worksheets work with .xlsx workbooks, and CSV files are for saving rows. Save an .xls workbook as .xlsx first.
- Adding rows to an existing file fails when its header row differs from the columns being written, so a run can't mix up columns.
- Reading or updating a workbook runs in the desktop app, which opens files on your computer.
- New steps can use the Excel and CSV files actions listed on this page.
Excel and CSV files questions
Can AIVane run an automation for every row of my spreadsheet?
Yes, in the desktop app. Ask the automation's AI assistant to run it for every row of an Excel file; the tutorial shows each step with an example workbook.
Why do accented characters look wrong when I open the CSV file in Excel?
Excel needs a marker at the start of the file to detect its encoding. Turn on csvBom in the step that saves the file; AIVane then writes that marker when it creates a new CSV file.
Will a run overwrite my file?
Only if the step is set to replace it. The default replaces the file (for a workbook, the worksheet); the append mode adds rows after the existing ones instead.
Which runs can use my Excel file?
Runs in the desktop app, which open files on your computer. Runs in AIVane Cloud save new CSV files that you download from Run history; for data that cloud runs read and update, use Google Sheets.
Last checked November 18, 2026 against the current AIVane release. Something different in your app? Contact support.
YOUR OWN TASK
Want help automating your own task?
Our first users can ask for hands-on help: one website task, one sheet, and a week of watching it run.
Get help automating a task ↗