How to Convert Outlook CSV Attachments to Excel Files in SharePoint
Question details
The user needs to convert CSV email attachments saved to SharePoint via Power Automate into standard Excel workbooks (.xlsx) without incurring premium license fees.
- Product
- Power Automate, SharePoint, Microsoft Excel
- Device & OS
- not provided
- Scenario
- Automating the extraction of CSV attachments from Outlook emails and saving them as fully functional Excel files in a SharePoint document library.
- Observed behavior
- Power Automate successfully saves the CSV attachments to SharePoint, but opening or interacting with them does not automatically generate a new XLSX file without manual conversion or premium connectors.
Ensure you have adequate permissions to read and write files in the target SharePoint document library and that your account has access to Excel for the web.
Convert the CSV to an Excel Workbook via Excel for the Web
The easiest non-premium method is to manually convert the CSV file by switching to Editing mode in Excel for the web.
When a CSV is accessed directly from SharePoint, it opens in a simplified viewing mode. Changing this mode forces Excel to interpret the data and allows you to save the file in the modern workbook format.
Open your SharePoint document library and locate the CSV file that Power Automate saved from the Outlook email.
Click on the CSV file to open it. By default, it will open in 'Viewing' mode within Excel for the web.
In the upper-right corner of the Excel interface, click the 'Viewing' drop-down menu and select 'Editing'.
Once in Editing mode, Excel will prompt you to convert the file. Save or download the document as a standard Excel workbook (.xlsx) to complete the conversion.
Automate Conversion Using Office Scripts
If manual conversion isn't viable, use Office Scripts in conjunction with standard Power Automate connectors to fully automate the process.
Manage CSV and Excel Files Effortlessly with WPS Office
While Microsoft Power Automate is excellent for enterprise workflows, handling and converting CSV files on your desktop doesn't have to be complicated. WPS Office provides a free, lightweight, and incredibly fast alternative to Microsoft Office, ensuring seamless compatibility with all your data formats without expensive subscriptions.
- 1. Open CSV File: Launch WPS Spreadsheet and select 'Open' to browse for your locally downloaded CSV file.
- 2. Review Data: Ensure your columns and delimiters are properly formatted within the workspace.
- 3. Save as XLSX: Click 'Menu', select 'Save As', choose 'Microsoft Excel Workbook (*.xlsx)' from the format drop-down, and click 'Save'.
Frequently Asked Questions
Can I automatically convert CSV to XLSX in Power Automate without premium connectors?
Yes, you can avoid premium connectors by utilizing Office Scripts triggered by the standard Excel Online (Business) connector, or by using a non-premium Power Automate Desktop flow to process the files locally.
Why does my CSV file open in Viewing mode in SharePoint?
SharePoint opens plain text formats like CSV in a restricted Viewing mode by default to prevent accidental data corruption. You must explicitly switch to Editing mode to make structural changes or save it as an Excel workbook.
Does opening a CSV in Excel immediately change its file extension?
No, simply opening a CSV file in Excel does not change its file format. You must perform a 'Save As' action to convert the plain text CSV data into an official .xlsx workbook format.
