This article explains how to transform CSV (Comma-separated values) files into Excel (XLS/XLSX) spreadsheets. Converting CSV to Excel or Excel to CSV can be done easily using Excel or various free online third-party file converters. Refer to the steps below for more details. In case you need to recover deleted or lost files, MiniTool Power Data Recovery is recommended.

To convert CSV to Excel or Excel to CSV, explore the solutions and free tools provided below.

Tip: MiniTool Power Data Recovery – Allows you to recover any deleted or lost files (including Excel and CSV) from a Windows computer, memory card, USB, external hard drive, and more. It’s clean, safe, and very user-friendly.

How to Convert CSV to Excel or Excel to CSV in Excel

How to Open a CSV File in Excel

Opening a CSV file is straightforward with Excel. If the CSV file uses a Unicode character set such as UTF-8, simply double-click the file, and it should open in Excel if Microsoft Excel is installed on your computer. Alternatively, right-click the CSV file and select Excel to open it.

If you encounter issues opening the CSV file directly with Excel, follow the instructions below to import the CSV file into an Excel spreadsheet.

Step 1. Launch Excel.

Open Microsoft Excel. Alternatively, right-click the desktop and create a new Excel workbook.

Step 2. Select the CSV file to import.

• Next, click File -> Open -> Browse.
• In the pop-up file selection window, click the drop-down arrow next to "File Type" and choose All Files or Text Files.
• Navigate to the folder containing the CSV file, select it, and click Import to open and import the CSV file data into an Excel worksheet.

Alternatively, click the Data tab in Excel and select From Text, locate the .csv file, and click Import.

Step 3. Configure Text Import Wizard settings.

• In the Text Import Wizard window, select Delimited and click Next.
• If you're converting a CSV file, choose Tab and Comma delimiters.
• Select General and click Finish.
• Decide where to insert the CSV file: Existing worksheet or New Worksheet. For example, “=$A$1” means your data will start displaying from Row 1, Column A. Click OK to open the CSV file in Excel.

How to Convert CSV to Excel

Step 1. Follow the guide above to open the CSV file in Excel.

Step 2. Click File -> Save As -> Browse.

Step 3. Pick a folder to save the new file. Name the file and select Excel Workbook (*.xlsx) as the output format. Click Save to convert CSV to Excel.

How to Convert Excel to CSV

Step 1. To convert Excel to CSV, open the Excel file with Microsoft Excel.

Step 2. Click File -> Save As -> Browse.

Step 3. Choose a destination folder, enter a name, select CSV (Comma delimited) (*.csv), and click Save to convert the Excel file to CSV format.

Convert CSV to Excel or Excel to CSV – 5 Free Online Tools

Besides using Microsoft Excel, you can also utilize free online file converters to easily switch between CSV and Excel formats. Here are five free online tools:

Simply visit one of the websites listed below, upload your source CSV file, choose the target output format (Excel XLS), and click Convert, Convert Now, or a similar button to convert CSV to Excel (XLS) in seconds. Many of these tools also allow you to convert Excel (XLS/XLSX) to CSV online for free.

ZAMZAR

Website: http://ipnx.cn/link/f861aa27e08ead5195342b2412f525f4

http://ipnx.cn/link/41c8606b0574441a259b1e14538ec466

Cloudconvert

Website: http://ipnx.cn/link/7c09c2a7d351667d881c5341239f8d8f

http://ipnx.cn/link/9eb1a76b0030a39886609c0f99634cbc

Convertio

Website: http://ipnx.cn/link/7e53526fc58a32e5452294826783a54b

http://ipnx.cn/link/50bb9595eb8bc365ba5e12c0d6e47b60

Aconvert

Website: http://ipnx.cn/link/b164250f03b08804a9697111ba542f21

http://ipnx.cn/link/bcd85837d120277f190bc74c566ffd7a

Online-Convert

Website: http://ipnx.cn/link/74d3b2328adadbd5c9740b050d0a333c

Recover Deleted/Lost Excel, CSV or Other Files

If you accidentally delete a file on your computer, USB, or external hard drive, you can quickly retrieve it. MiniTool Power Data Recovery, a professional data recovery software for Windows, enables you to recover any deleted or lost files from your computer and external drives in just a few clicks.

Final Thoughts

Curious about how to convert CSV to Excel or Excel to CSV? We hope this guide proves helpful. For more free and practical tools, visit the MiniTool Software official website.

The above is the detailed content of How to Convert CSV to Excel or Excel to CSV – 6 Free Tools. For more information, please follow other related articles on the PHP Chinese website!