VIDEO: Convert Txt to CSV

You create a txt file like this

Of course, before you can convert a txt file to CSV, you must first create the txt file. You can either do this in Word or do it in the editor.

1. If you are working with Word 2003, write your text in the document as normal and then save it as a Txt file.
2. To do this, either go to "Save as" via the menu in the file or use the shortcut F12 to save your file.
3. Then select “txt” in the “File type” field and confirm your selection with “ok”.

You do a similar thing in Word 2010. Here, however, you save your file using the button "Office"," Save as "or also with the shortcut" F1 ". If you have created your file in the editor, you can save it regularly, since the editor only saves Txt formats anyway.

Convert text file to CSV

You now have your txt file, which you now need in CSV format. The conversion is very easy.

1. Open Excel 2003 and go to the “File” menu and then “Open”.
instagram viewer
2. Find your file there and open it.
3. Don't forget to select “All files” or “Text files” in the “File type” field. Otherwise you will not see your file. Excel will now ask you for your personal settings. In the preview you can see which settings are optimal.
4. If you click on "Next", you will be asked for the separator with which you would like to save your data in the CSV file. Here, too, you can see in the preview which settings are optimal for you.
5. Confirm your selection and your data will appear in the worksheet.
6. Now go back to the “File” menu, then “Save as” and save this file as a “CSV file”. You will find the selection in the "File type" field.

Import txt file into Excel

1. Another option is to import external data into Excel. To do this, open Excel as normal and go to "Data" in the menu.
2. Then select "From Text" and open your text file here. Again, Excel asks you for your settings and for the column in which you want to import your data.
3. After you have made your selections, Excel will import your data into the spreadsheet.
4. All you have to do now is save it in CSV format.

Here's how you can convert Txt files to CSV.