How To Save CSV File Into Excel Without Changing Format?

By Saha Alam

How To Save CSV File Into Excel

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:

  1. Open blank workbook, and then click Data > New Query > From File > From CSV.
  1. In the Import data box, select your CSV file, and then click Import or double-click on your CSV file.
  1. In the menu bar, click ‘Close & Load’.
  1. The data from your CSV file will appear in the Excel workbook.
  1. 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.

Reference

Contributors

Leave a Comment