Question

What kind of preprocessing do we need to be able to open a text file in Excel?

a. Converting to PDF
b. Saving as CSV
c. Compressing the file
d. Renaming the file extension

Answer 1

To open a text file in Excel, you need to save it as CSV.

Step-by-step explanation:

The correct preprocessing required to open a text file in Excel is saving the file as CSV. CSV stands for Comma Separated Values, and it is a file format that Excel can easily read. When you save a text file as CSV, it separates different data values using commas, allowing Excel to recognize and organize the data correctly.