Opening the file as you would any other file will launch the Text Import Wizard, which helps you format the text for your worksheet. If you already have Excel open, just click the File menu and select Open to get to the Open screen now.
If you don’t see your text file, click the file format menu and select All Files or Text Files. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
If you don’t see your text file, click the file format menu and select All Files or Text Files. [2] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Delimited text uses commas, tabs, or other characters to separate each field. This is common if you’re importing things like contact lists, addresses, and data you’ve exported from databases. Fixed width contains text that’s aligned into columns with single spaces between each field. This is common if you’re working with a single-column list.
Tab is checked by default. If you are not using tabs to separate data, uncheck this box. Otherwise, the wizard will automatically detect the spaces in your text as tabs and separated it into columns. If you don’t see the character you need, select Other and type the character into the field. Select “Treat consecutive delimiters as one” if the delimiter consists of more than one character between data fields or if you have multiple delimiter characters. Optionally, you can select none of these options if you don’t want to separate any of the data entries into columns.
Tab is checked by default. If you are not using tabs to separate data, uncheck this box. Otherwise, the wizard will automatically detect the spaces in your text as tabs and separated it into columns. If you don’t see the character you need, select Other and type the character into the field. Select “Treat consecutive delimiters as one” if the delimiter consists of more than one character between data fields or if you have multiple delimiter characters. Optionally, you can select none of these options if you don’t want to separate any of the data entries into columns.
To add a break line, click at any location. Double-click a break line to delete it. Drag any of the lines to move it.
To add a break line, click at any location. Double-click a break line to delete it. Drag any of the lines to move it.
If you’re using Excel for macOS, the option may be called From Text (Legacy), depending on your version. [3] X Trustworthy Source Microsoft Support Technical support and product information from Microsoft. Go to source
Delimited text uses commas, tabs, or other characters to separate each field. Fixed width contains text that’s aligned into columns with single spaces between each field. 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.
Tab is checked by default. If you are not using tabs to separate data, uncheck this box. Otherwise, the wizard will automatically detect the spaces in your text as tabs and separated it into columns. If you don’t see the character you need, select Other and type the character into the field. Select “Treat consecutive delimiters as one” if the delimiter consists of more than one character between data fields or if you have multiple delimiter characters. Optionally, you can select none of these options if you don’t want to separate any of the data entries into columns.
Tab is checked by default. If you are not using tabs to separate data, uncheck this box. Otherwise, the wizard will automatically detect the spaces in your text as tabs and separated it into columns. If you don’t see the character you need, select Other and type the character into the field. Select “Treat consecutive delimiters as one” if the delimiter consists of more than one character between data fields or if you have multiple delimiter characters. Optionally, you can select none of these options if you don’t want to separate any of the data entries into columns.
To add a break line, click at any location. Double-click a break line to delete it. Drag any of the lines to move it.
To add a break line, click at any location. Double-click a break line to delete it. Drag any of the lines to move it.
