To save CSV file into excel, open a blank workbook, and then click Data > New Query. In the Import data box, select your CSV file, and then click Import or double-click on your CSV file.
In the menu bar, click ‘Close & Load’. The data from your CSV file will appear in the Excel workbook.
Now click File > Save As, and then select your desired file format. Your CSV file will now be saved as an Excel workbook.
Q: How To Convert CSV File To Excel?
Let’s explore in detail:
- Open blank workbook, and then click Data > New Query > From File > From CSV.
- In the Import data box, select your CSV file, and then click Import or double-click on your CSV file.
- In the menu bar, click ‘Close & Load’.
- The data from your CSV file will appear in the Excel workbook.
- Now click File > Save As to save your workbook as an Excel file.
I hope this quick tutorial helped you to save your CSV file as an Excel workbook without changing the format.
Contributors