Data Import & Export

Automatically Import Daily CSV Data into an Excel SharePoint Workbook

Algirdas JasaitisAlgirdas Jasaitis Nov 22, 2026 868 views

Question details

Import a daily CSV file into a SharePoint-hosted Excel workbook automatically while applying consistent formatting and data restrictions.

Automatically Import Daily CSV Data into an Excel SharePoint Workbook
Product
Microsoft Excel, SharePoint, and Power Automate
Device & OS
not provided
Scenario
A new CSV file arrives each day, and its contents need to update a master worksheet stored on SharePoint.
Observed behavior
Synchronizing the SharePoint workbook locally does not automatically import the daily CSV data.
Before you start

Confirm where the daily CSV files arrive, whether each file should replace or append to the existing data, and whether you have access to the SharePoint site and Power Automate. Check that the CSV columns are consistent and identify any quoted fields or commas within field values.

Solution 1Recommended

Use Power Automate to import each daily CSV into an Excel table

Use a cloud flow when CSV files arrive in SharePoint and the master workbook needs unattended updates.

The Excel Online (Business) connector writes rows to an Excel table; it does not automatically parse a CSV file into columns. Use a CSV-capable connector or custom parsing solution that handles the file's delimiters, quotes, and line breaks.

Excel data validation should not be treated as a reliable way to reject invalid values written by an automation. Validate and filter the parsed data in the flow before writing it to the workbook.

1
Prepare the master table

Open the SharePoint workbook in Excel, select the master data range, and choose Insert > Table. Give the table stable column headers that match the fields you want to import.

2
Set up worksheet rules

Select the relevant table columns and use Home > Conditional Formatting and Data > Data Validation to set the desired formatting and entry restrictions. Test whether the rules extend to rows added by the flow.

3
Create a flow

In Power Automate, choose Create > Automated cloud flow and select the SharePoint trigger When a file is created (properties only). Point it to the site and library or folder where the daily CSV arrives.

4
Read and parse the CSV

Add SharePoint's Get file content action, using the file identifier from the trigger. Pass the content to a CSV-capable parser, then add conditions to check required fields and allowed values before import.

5
Write the rows

Add an Apply to each action for the parsed records. Inside it, add Excel Online (Business) > Add a row into a table, select the SharePoint workbook and table, and map each CSV field to its corresponding column.

6
Test the daily update

Upload a representative CSV to the monitored SharePoint location, inspect the flow run history, and open the workbook to verify values, formatting, and validation rules. If each file is a replacement rather than an addition, configure and test a separate removal or replacement process before enabling the daily flow.

Use Power Automate to import each daily CSV into an Excel table
Prevent duplicate imports: The example flow appends rows. Track processed files or otherwise handle repeat uploads so the same CSV is not imported twice.
Free Microsoft Office alternative

Review CSV and Excel data with WPS Spreadsheets

WPS Office is a free, lightweight alternative with a familiar interface for working with CSV data and Excel workbooks. Its format compatibility makes it easier to move existing files, though it does not configure or fix a Microsoft Power Automate flow.

Open CSV files and review daily data in a spreadsheet.Work with Microsoft Excel XLSX and XLS files.Use a familiar spreadsheet interface to format and inspect data.Move existing supported spreadsheet files without starting from scratch.
QA img-9

Frequently Asked Questions

Does syncing a SharePoint workbook import a new CSV automatically?

No. Syncing makes the workbook available locally, but a separate import or automation is needed to read the CSV and update the workbook.

Can the flow replace the previous day's data instead of appending?

Yes, but the flow needs a tested process to remove or replace the old rows before writing the new ones. The Excel Online (Business) Add a row into a table action alone appends data.

Will Excel data validation block every invalid value added by a flow?

Do not rely on it for automated writes. Add conditions in Power Automate to check required fields and allowed values before using Add a row into a table.

How can I keep leading zeros in imported CSV values?

For a manual import, choose Data > From Text/CSV > Transform Data and set the affected column's type to Text. For an automated import, ensure the parser and field mapping preserve the value as text.

Why shouldn't I always split CSV lines on commas?

CSV fields can contain commas or line breaks inside quoted values. Use a parser that supports the CSV format used by the source file instead of relying on a simple comma split.