Excel Guides

Correctly Saving Delimited Files in Excel

When it comes to delimited files, there are a few things you need to keep in mind in order to ensure that they are correctly saved in Excel. First and foremost, you need to make sure that the file is saved as a .txt file. This can be done by going to the "Save As" option in your file menu and selecting "Text (Tab Delimited) (*.txt)" from the drop-down menu. Once you have done this, you will need to open the file in Excel. You can do this by double-clicking on the file or opening it through the "Open" option in the "File" menu. When you have the file open in Excel, you will need to select the "Data" tab and then click on "Text to Columns".

This will bring up the "Convert Text to Columns Wizard". In this wizard, you will need to select "Delimited" as your data type and then click on the "Next" button. On the next page of the wizard, you will need to make sure that all of the options under the "Delimiters" section are checked off. Once you have done this, click on the "Finish" button and your delimited file will be correctly saved in Excel.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.