That's because I have a comma that is not meant to be used as what's called a delimiter. And you can see the double quotes on either side of it. For that reason, the value is put in quotes. One thing to note is that because I have commas in my numerical values, for example here in the third row, and I'll highlight it so you can see it more easily, I have $4,951.
So order number one was placed on January 1, 2017, and you can see the rest of the information. And then below that, separated by commas, I have values that describe the order. Those are my headers for an Excel table or Excel data list. You can see that at the top row I have the order number, date of purchase, SKU or stock keeping unit quantity, and so on. I'll press Command + Tab to display the TextEdit program. But let me show you what the text file looks like first. I have that open right now, so I'm going to bring my text values into here. And my sample file, or at least the first one that I'll work with, is the ImportTarget dialog box. I'll demonstrate how to do that in this movie. If that's the case, they might save their data to a text file, you can bring that data into Excel using the Text Import Wizard. When you work with colleagues in other departments or other companies, they might not have access to Excel.
