How to Fix Excel for the Web Cannot Import CSV Files
Question details
The user needs to open and view data from a downloaded CSV file using Excel for the web, but the platform lacks native support for direct CSV imports.
- Product
- Excel for the web
- Device & OS
- not provided
- Scenario
- Attempting to download a CSV data file from a website and open it directly within the web-based Microsoft 365 spreadsheet environment.
- Observed behavior
- Excel for the web cannot open or import the CSV file directly, and in some cases, the downloaded file incorrectly saves or opens as a PDF instead of a spreadsheet.
Verify that your downloaded file correctly ends with a .csv extension. If your browser saved it as a .pdf, you will need to re-download it using the 'Save link as' option and manually add the .csv extension.
Convert CSV to XLSX using Desktop Excel
Use a desktop version of Microsoft Excel to open the CSV file and save it in a supported format before uploading it to the web.
Excel for the web does not support direct CSV imports. However, all desktop versions of Excel (including Microsoft 365, Excel 2019, 2016, 2013, and 2010) natively support opening CSV files. By converting the file locally first, you can seamlessly continue your work online.
Launch your desktop version of Microsoft Excel. Go to 'File' > 'Open' and browse your computer for the downloaded CSV file. You may need to change the file type dropdown in the Open dialog to 'All Files (*.*)' or 'Text Files (*.prn;*.txt;*.csv)' to see it.
Once the file is open, click 'File' > 'Save As'. In the 'Save as type' dropdown menu, select 'Excel Workbook (*.xlsx)' and save the file to your computer.
Open your web browser, navigate to OneDrive or SharePoint, and upload the newly created .xlsx file. You can now click on the uploaded file to open and edit it in Excel for the web.
Use a Trusted Online File Converter
If you do not have access to any desktop version of Excel, use an online conversion tool to convert your CSV file into an XLSX format.
Instantly Open and Edit CSV Files with WPS Office
Bypass the limitations of web-only spreadsheet apps. WPS Office provides a free, fully-featured desktop suite that natively supports opening, editing, and saving CSV files without requiring complex conversions.
- 1. Download and Install: Download WPS Office for free from the official website and follow the simple installation instructions.
- 2. Open your CSV File: Right-click your downloaded CSV file, select 'Open with', and choose 'WPS Spreadsheets'.
- 3. Edit and Save Seamlessly: Edit your spreadsheet with advanced tools and save it back as a CSV or upgrade it to an XLSX format in seconds.
Frequently Asked Questions
Why does my downloaded CSV file open as a PDF?
This usually occurs due to an incorrect browser association or server-side configuration on the website. To fix this, right-click the download link on the website, select 'Save link as...' or 'Save target as...', and manually ensure the file name ends with '.csv' before clicking Save.
Which versions of Excel support importing CSV files directly?
Direct CSV import is supported in all desktop versions of Microsoft Excel. This includes Microsoft 365 desktop apps, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010, and Excel 2007.
Can I use Power Query to import CSV files in Excel for the web?
Currently, Excel for the web does not support getting data from text or CSV files using Power Query. You can refresh existing queries connected to cloud sources, but creating a new connection to a local CSV file requires the desktop version of Excel.
