"What do you mean by 'correctly open?' Why can I just open it like any other file?"
I'll answer the first question by answering the second: because Excel likes to auto-format things.
So, my original meaning could be read as: "open the file in such a way that Excel doesn't perform any automatic formatting on the data," though that is certainly a less succinct way of stating it.
For various reasons, some of our clients will want to open and edit their State/Known data files before importing them into Illuminate (perhaps because the test Vendor doesn't provide SSIDs in the file, and the client needs to add them). Whatever the reason, opening the file and editing it before importing isn't inherently problematic–as long as it's done correctly. A few simple steps, outlined below, show how to properly perform this operation.
1. Begin by opening a blank excel sheet
2. Data > Get External Data > Import Text File
3. Choose your file > Get Data
4. Choose your file type. In this example, we have a CSV, so we're choosing "Delimited."
5. Choose the delimiter type. In the example below, I have a CSV, so I'm choosing "Comma" as the delimiter.
6. While holding the SHIFT key, move the cursor in the "Data preview" window all the way to the right, then LEFT CLICK the last column. Then, select "Text" under the "Column data format" and click "Finish."
You now have a delimited text file that has been opened in Excel, and none of the original data from that file has been auto-formatted or otherwise altered in the process.
Please sign in to leave a comment.