If you want to import a text file to a specific range of a sheet with a delimiter or without delimiter as you need, you can try the Insert File at Cursor utility of Kutools for Excel to solve this task. In the Insert File at Cursor dialog, click Browse to show Select a file to be inserted at the cell cursor position dialog, select Text Files from the drop down list next to File name , choose one file you need, and click Open.
Click OK , then the text file has been inserted into the placed cell without delimiter. Then check the options as you need in Type and Split by sections. Click Ok to select a cell to place the texts. Click OK to finish.
Note: The other languages of the website are Google-translated. Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.
About Us Our team. How to quickly convert a text file to excel file with delimiter? Convert text file to sheet with delimiter by Open Import a text file to a sheet with or without delimiter Convert text file to sheet with delimiter by Open To convert a text file to a sheet, you can use the Open utility in Excel.
See screenshot: 2. See screenshot: 3. This button looks like a blank sheet icon with a tiny text document in front of it. You can find it on the Data toolbar. This will open your file navigator, and allow you to select the text file you want to import.
Select the text file you want to import. Click on the text file you want to convert to Excel, and click the Get Data or Open button in the file navigator pop-up. This will open the Text Import Wizard in a new pop-up window. Select Delimited in the Text Import window. You can find it at the top of the Text Wizard pop-up. Most text files contain delimited data. This means your data entries are separated by tabs, commas, or a different character, rather than fixed-width spaces with columns.
If the data in your text file is separated into columns with fixed-width spaces in between, you can select Fixed width here. You can see a preview of your text import at the bottom of the import window. Click Next in the Text Import window. This will take you to the next step. Click Next in the Text Import. This will take you to the final step.
Click Finish. This will import all the text in your text file to the spreadsheet. If you're prompted to select a column for your import, select the cell where you want your imported text to start on the spreadsheet, and click OK.
Click the File tab. This button is in the upper-left corner of your screen. It will open a drop-down menu. Click Save As on the "File" menu. This will allow you to save your imported text as an Excel spreadsheet file.
Select a location to save your file. Click a folder in the "Save As" window to save your new spreadsheet file. Click Save. This will save your imported text to the selected folder as an Excel file. Include your email address to get a message when this question is answered. Submit a Tip All tip submissions are carefully reviewed before being published.
You Might Also Like How to. How to. About This Article. Co-authored by:. Co-authors: 2. Updated: June 17, Categories: Microsoft Excel. Article Summary X 1. Thanks to all authors for creating a page that has been read 13, times. Is this article up to date? Cookies make wikiHow better. By continuing to use our site, you agree to our cookie policy. Featured Articles How to. Trending Articles How to.
New Pages How to. Watch Articles How to. By signing up you are agreeing to receive emails according to our privacy policy.
0コメント