answersLogoWhite

0

Click Open (or CTRL-O). Under file type, select text files. Select the file you want to convert. You will automatically get a "wizard" asking if the columns are delimited or fixed-width, as well as at which line to start conversion, what delimiter(s) to recognize, the format of each column, etc.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

How do you convert a ms Works database file to a Microsoft Excel file?

Export the MS Works database file in a comma-delimited format, save the file, then import the file into MS Excel.


How do you export data from a Dos ver 5 database to Excel?

A good way is to export from a database is to save as CSV format (or some sort of comma-delimited text format), then open Excel and import the file into Excel.


How do you rename for Excel file to text file?

If you renamed an Excel file it would still be an Excel file, but Excel may not recognise it as such. It would be far better to open the file and then go to the File... Save As menu, select the file type as either Text (Tab-delimited) or csv (Comma Separated Values) give it a filename and click Save. You would then be able to open it in any text editor. Note that you can only save one worksheet, so if you had several worksheets you would have to save each one as a separate file.


How do I convert PDF files to excel?

To convert PDF files to an Excel file, you can use this website, http://www.pdftoexcelonline.com/. This website can convert any PDF file to any Excel file for free.


How do you convert the autocad dwg to Excel file?

First Answer is you don't. however you can make an image file of your drawing and insert that into excel. Unless you mean an autocad table into excel, that you would select the table and right click, then select "export", that will save it as a comma delimited file (.cvs type), then you open that in excel.


How do you convert an xls file to xlt?

Open in Excel and save as an Excel Template.


When a delimited file is imported into Excel fields become?

Different fields will go into columns in the spreadsheet. Records would go into rows in the spreadsheet.


How do you convert blackberry back up file BBB to excel or csv file?

To convert blackberry back up file , and to excel scv file , you need an computer . You connect with your blackberry mobile phone and you can easily do that .


What do you call a file that contains data separated by a selected character?

A file that contains data separated by a selected character is known as a delimited file. The most common types of delimited files are CSV (Comma-Separated Values) files, where commas are used to separate data values, and TSV (Tab-Separated Values) files, where tabs are used for separation.


How do you convert Excel to csv in Microsoft Excel?

From within Excel, File Menu>Save As>Save As Type>CSV


How can I convert a PDF to a excel spreadsheet?

You can transfer a PDF file into an excel file but simply copy and pasting the information into the excel program to create your spreadsheet. If this does not work there is no option.


How do you convert an excel file to a csv file?

Use the Save As facility and pick the CSV option.