 While it's possible to enter data manually into Jmovi, it's an awkward process, and it's much better to save the data in a spreadsheet either from Google Sheets, Excel, or some other program, and then import it directly. And fortunately, that's easy to do in Jmovi. Here I have a blank window. And what I'm going to do is I'm going to show you how to import several different spreadsheets or other formats. So first, I want you to see the files themselves. What I have are four files with the same data in it, but they're in different formats. The first one is an xlsx file, it's Excel, or really, it's the Excel's open XML format. And you can see we've got an ID number, recorded date and response ID, then we have five questions q1 through five, and then a zip code at the end. And it's a very simple data set. Now I have the same information saved as a CSV file, which stands for comma separated values. This is the really most common version of a spreadsheet that basically anything can read. And we've got the same data. It's shown a little bit differently here on my Mac when I do a quick view. But it's the same data. You can also save it as a text file where you have tabs separating the values. And actually, I did this in Excel, just saved it as text. And you can see again, although it's arranged a little differently, it's the same data. And then finally, I have the same data in an SPSS dot SAV file. Now it may be depending on what you have on your computer, if you click on this, it'll give you variable definitions when you do a quick view. Right now it's not showing me anything. But here's an interesting thing. Jamovie can import most of these, but not all of them. Let me go back to Jamovie. What I do is I come over to the menu here with the three horizontal lines and I hit open. And you'll see that it's able to open several different kinds of files, of course, Jamovie files, and then CSV and text files. It's able to open SPSS files, state of files, SAS files and JASP, which is another program created by several of the same developers of Jamovie looks very similar but operates a little differently. And so these are the options. Now, let's come up here to browse and I'm going to go to my desktop, desktops right there. And what you see now is the XLSX is grayed out. I can't open a native Excel file. But that's okay, because if you're an Excel, you just save it a CSV and you're good to go. So let's start with the CSV file. This is the most common kind of file that you would be importing. All I got to do is double click on this. And then it opens up in Jamovie. And there we have our data. Let me move this one over a little bit. Perfect. It's formatted. And you can see that it even changed the data types to match pretty much what's in there. Now I'm going to show you how to do data definitions in later videos. So I'm not going to worry about that right now. But this is the CSV file. Now let me show you what it's like when we open the text file. Again, I'll come to open. And because I have this one folder open, it's my desktop, I can just hit import text. I double click on that. It takes just a moment. And here you see the data looks exactly the same. There's no difference. And then finally, we're going to do the SPSS file. And you'll see with this one, there is a small difference. I'm going to come here to import.sav. That's the SPSS data file. I click on that. And what's different here is that in SPSS, you have labels on your values. And so for instance, you see the variables Q1 through Q5. And the other ones, they were just the numbers one through five. Here they have labels on them. Although you should know that the numbers are underneath. I'm going to just double click on this. And when we open that up, you can see strongly disagree is a one disagree is a two. And in fact, to move, you can still treat these as numeric variables, the same way you would do an SPSS. If you had a variable with value labels, I'm going to close that. Now there is one other thing. SPSS really didn't like having the date and the time and the same thing. So they had to get split into two. But that's a trivial thing. And so you can see that if you have the data in a spreadsheet, you got it in SPSS, or SAS or some other format, it's a very quick and easy process to import that data into Jmovi. It reads the format, it reads the labels, and then you're good to go.