Home » Questions » Computers [ Ask a new question ]

CSV to Excel sheet again

CSV to Excel sheet again

I have a problem.

Asked by: Guest | Views: 166
Total answers/comments: 2
Guest [Entry]

"My understanding of this question is that you have a Spreadsheet (XLS) that you want to save as a CSV to export the data to another system.

Choose File > Save As...

In the Type drop-down list, select Microsoft Excel Workbook (XLS)

However, on reading it again it appears you may want to open a CSV file, and then save it as an XLS.
choose Data > Import External Data > Import Data
choose Text file in the drop-down list."
Guest [Entry]

Usually, Excel is able to open CSV files and, on the process, to give you a chance to define the formats for the columns.