How to open a delimited text data file safely in Microsoft Excel
If you are using Microsoft Excel to view or edit the content in a delimited text data file for use with DesignMerge, then you will prefer to open the file without automatically changing any of its content.
When Microsoft Excel automatically opens a plain delimited text file, Microsoft Excel will apply the General format to the data inside this file. Applying the General format may change the text in the file. For example, this format will remove leading zeros and will also remove zero decimal digits.
To prevent the text from being automatically changed when you open the file in Microsoft Excel, follow the steps below:
- Change the filename extension on the data file to the .TXT filename extension.
- Start Microsoft Excel, open the MS Excel File menu, choose Open, and select the .TXT data file. This will automatically start the MS Excel Text Import Wizard.
- On Step 1 of the Text Import Wizard, select Delimited for the Original Data Type, and click Next to continue to the next step.
- On Step 2 of the Text Import Wizard, select the appropriate Delimiter, uncheck Treat consecutive delimiters as one, and click Next to continue to the next step.
- On Step 3 of the Text Import Wizard, click on the First Column that is displayed in the Data Preview box. Then, scroll in the Data Preview box to the Last Column, press Shift and click on the Last Column. This selects all columns in the Data Preview box. With all columns selected in the Data Preview box, select Text for the Column data format. Confirm all columns are labeled as Text in the Data Preview box, and then click the Finish button.
- The data file will now be opened in MS Excel and all of the data in this open file will have been formatted as Text (no changes will have been made to the text).