Convert a CSV File to Microsoft Excel - - Windows Tips and Tricks with Geek

Wednesday, January 5, 2022

Convert a CSV File to Microsoft Excel

 Microsoft Excel logo on a green background

Convert CSV to Excel With the “Save As” Option

“Save As” is a quick and easy way to convert most CSV files to Excel format without any issues.

To use this method, open your computer’s file manager and locate the CSV file you want to convert to Excel. On a Windows PC, use File Explorer to do that. On Mac, use Finder.

Locate the CSV file on the computer.

Right-click your CSV file and select Open With > Excel in the menu. This opens your file in the Excel app.

Right-click the CSV file and select Open With > Excel.

When Excel opens, you will see all your CSV file’s data in it. Review this data carefully and make any modifications to it before saving it in Excel format.

A CSV file in Excel.

If everything looks good, then save the file as an XLSX file. Do this by clicking “File” in Excel’s top-left corner.

Click "File" in Excel's top-left corner.

In the sidebar on the left, click “Save As.”

Click "Save As" in the left sidebar.

Select “Browse” in the pane on the right.

Click "Browse" on the right pane.

You will see a “Save As” window. In this window, choose a folder where you’d like to save your resulting XLSX file. Click the “File Name” field and type a name for your new file. Click the “Save as Type” drop-down menu and select “Excel Workbook (*.XLSX)” so your file is saved in Excel format.

Finally, at the bottom of the “Save As” window, click “Save” to save your file.

Save the CSV file in Excel format.

And that’s it. Your CSV file is now converted to Excel format and is available in your specified folder.

Convert CSV to Excel With the “From Text/CSV” Option

To review and modify the settings for your CSV data before importing it into Excel and then converting it to Excel format, use the app’s built-in “From Text/CSV” import feature.

This feature connects your workbook to your CSV file and imports your CSV data. Then, once you have the data in your workbook, you save the workbook as an Excel file.

To get started, first, open Microsoft Excel on your computer and create a new spreadsheet. In Excel’s ribbon at the top, click the “Data” tab.

Click the "Data" tab in Excel.

On the “Data” tab, in the “Get & Transform Data” section, click “From Text/CSV.” You will now connect your workbook to your CSV file.

Select "From Text/CSV" in the "Data" tab.

In the “Import Data” window that opens, access the folder that has your CSV file and double-click the file to add it to Excel.

Double-click the CSV file.

In Excel, a new window will open displaying your CSV file’s data. Here, Excel tries to keep your data as accurate as possible. However, if you see any issues, use the drop-down menus on this window to fix them.

For example, if your imported file uses a different encoding type, click the “File Origin” drop-down menu and choose an appropriate type. Similarly, to get Excel to analyze more rows in your data to define the data types, click the “Data Type Detection” drop-down menu and select an option.

When all looks good, and you want to import this on-screen data into Excel, click “Load” at the bottom of the window.

Preview the CSV data in Excel.

You now have your CSV file’s data in your Excel workbook.

CSV data in Excel.

By default, Excel uses the table format for your imported data. If you’d like to use normal ranges, then click any cell on the table and select Table > Convert to Range from the menu. Then select “OK” in the prompt.

Right-click a table cell and select Table > Convert to Range.

Your table is now gone, but its formatting remains. To get rid of this table-style formatting, select your entire table, click Excel’s “Home” tab, and choose Clear > Clear Formats.

Select the table and click Clear > Clear Formats.

You now have your CSV file’s data in plain text in your Excel spreadsheet.

A CSV file's data in plain text in Excel.

To save this data in Excel format, in Excel’s top-left corner, click “File.”

Click "File" in Excel's top-left corner.

From the left sidebar, select “Save.”

Choose "Save" from the left sidebar.

A “Save As” window will open. Here, type a name for your file and click “Save.”

Type a file name and click "Save" on the "Save As" window.

And that’s all. You now have your CSV file’s Excel format (XLSX) version available on your computer. Enjoy!

No comments:

Post a Comment