How to Create a Comma Delimited Text File

104 43

Things You'll Need

Instructions

1

Create a list separated by commas in Microsoft Word. (Note: If you already have a file that contains commas handy, open it.)
2

Select "File" then "Save As." If prompted, type in a name for your document and as the "Save As Type" select "Plain Text." (You may not be prompted to type in a name for your document if you have already saved it previously.)
3

Select the Text Encoding default by checking "Windows." Select "Insert Line Breaks," and CR and LF for "End With Lines." Name and save your document, if prompted. Close out of the document and the software.
4

Open Excel and in a blank spreadsheet select "Data," from the pull-down menu. Next, select "Import External Data," "Import Data."
5

Locate the saved file. At the Import Wizard dialog box, check the "Delimited" option and if desired, input the first row to import. Click "Next."
6

Check boxes "Comma" and "Treat Consecutive Delimiters as One," then click "Next."
7

Select "General" under the Comma Data Format section. Click "Finish."
8

Click on "Cell A1" to place the new data at the beginning of the spreadsheet and then press "OK." (You can place the curser in any cell where there are no conflicting space issues.)
9

Verify the data by spot checking visually to ensure that no commas are present.
Subscribe to our newsletter
Sign up here to get the latest news, updates and special offers delivered directly to your inbox.
You can unsubscribe at any time

Leave A Reply

Your email address will not be published.