Downloading a csv file from a site and saving as excel file

Hello Dale Dharmaraja,

I realize that you've encountered a problem with Saving CSV as Excel File. I truly understand your confusion. Let me assist you further.

For me to provide the most accurate solution, would you please let me know few information about the situation you're experiencing:

1. Have you tried suggestion from Q&A assist? And what exactly happens when you open the CSV file in Excel (for example: all data in one column, blank file, or error)?
2. Does the data appear correctly in separate columns, or is everything combined into a single column?
3. Do you see any error message when you try to save the file as an Excel workbook (.xlsx)?
4. How are you opening the file, by double‑clicking it, or through Excel using Data > From Text/CSV?
5. After downloading, what is the exact file extension (for example: .csv, .txt, or something else)?

Once I have this information, I will be able to assist you better. I am looking forward for your respond.

Use Excel’s built-in CSV support to download and convert the file to an .xlsx workbook.

1. Download the CSV file from the government site and save it to the computer.
2. Open Excel.
3. In Excel, do one of the following to open the CSV:
   • Option A (simple open):
     1. Select File > Open.
     2. Browse to the folder where the .csv file was saved.
     3. In the file type dropdown, choose Text Files or All Files, select the .csv file, and click Open.
        • If it is a .csv file, Excel will automatically open it in a new workbook.
   • Option B (Power Query, useful for encoding/delimiter issues):
     1. Go to the Data tab.
     2. Select Get Data > From File > From Text/CSV.
     3. Browse to the .csv file and select it.
     4. In the import dialog, confirm Delimiter is set correctly (usually Comma) and adjust File Origin if needed (for example, 65001 UTF for UTF‑8 files), then select Load.
4. After the CSV data is visible in Excel, save it as an Excel workbook:
   1. Select File > Save As.
   2. Click Browse and choose the folder where the Excel file should be saved.
   3. In Save as type, choose Excel Workbook (*.xlsx).
   4. Click Save.

This creates a normal Excel file from the downloaded CSV.

References:

• Import or export text (.txt or .csv) files
• Downloads hub overview