General discussion

Locked

Opening csv's in Excel

By Seadogs ·
I am downloading reports from the web in CSV format. If I try to open them by double clicking, no file is associated. So I go through the window and pick excel. Excel opens the file which is then still in the .csv format. Is there anyway to get excel to convert this format? Thanks for the help

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Opening csv's in Excel

by tchieng In reply to Opening csv's in Excel

If you haven't done so, you can associate the .CSV extension with Excel so that next time you double-click on it, it will launch Excel automatically.

There's no automatic way to conver these files. You have to open them up as a CSV file and do a"Save As" from the File menu, rename the file and select "Microsoft Excel Workbook" in the "Save as type" field.

Collapse -

Opening csv's in Excel

by Seadogs In reply to Opening csv's in Excel

Poster rated this answer

Collapse -

Opening csv's in Excel

by tchieng In reply to Opening csv's in Excel

In addition to the above. If you do this enough, you probably need to use Macros if you don't already use them. You can record an Excel Macro once and modify it to convert all CSVs within a directory to the Excel file format automatically. This is better than doing a "File | Save As" everytime you download the reports. It will require a little programming, but it can be done easily...

Collapse -

Opening csv's in Excel

by Seadogs In reply to Opening csv's in Excel

Poster rated this answer

Collapse -

Opening csv's in Excel

by kracquet7 In reply to Opening csv's in Excel

The best way to get Excel (or any other Office product) to covert a file type is save document to your computer or network instead of opening it from the web. Personally, I do not have any problems with Excel 2000 converting CSV files when I do thefollowing:

Instead of opening the file from the web, try right clicking the file and do a save as to your computer.

Then open the document from Excel instead of from the web or from Explorer.

Collapse -

Opening csv's in Excel

by Seadogs In reply to Opening csv's in Excel

Poster rated this answer

Collapse -

Opening csv's in Excel

by Glenn from Iowa In reply to Opening csv's in Excel

Have you tried opening Excel, then select Open from the File menu. In the "Files of type" box, change it to Text Files (*.prn; *.txt; *.csv). Then Excel should open the file and place the data values into the correct cells.

Collapse -

Opening csv's in Excel

by Seadogs In reply to Opening csv's in Excel

Poster rated this answer

Collapse -

Opening csv's in Excel

by Seadogs In reply to Opening csv's in Excel

This question was closed by the author

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums