Uploading your data to a dataset
For help on creating a file to upload, see Creating a .csv file below.
Once you have a file, you can upload it. First, click on the data tab. The data tab should look like this:
To upload a file:
- Select the file to upload. You can either type the file name directly in the text box, or you can click on the 'Browse' button to find the file.
- If there are titles in the first row, make sure that the 'First row contains column titles' box is checked.
- Click on the 'Upload File' button.
Creating a .csv file
To upload data, first you have to make a file. The data can be delimited by commas, semi-colons or tabs. Plot-O-Matic will automatically detect what delimiter you are using. If you want, you can put the datacolumn titles in the first row. Let's look at a quick example. To get a dataset that looks like this:
You need a file that looks like one of these:
-
comma delimited
- x,y,z
- 0,0,0
- 1,1,1
- 2,4,8
- 3,9,27
- 4,16,64
-
semi-colon delimited
- x;y;z
- 0;0;0
- 1;1;1
- 2;4;8
- 3;9;27
- 4;16;64
-
tab-delimited (note: those are tabs, not spaces, between the data entries)
- x y z
- 0 0 0
- 1 1 1
- 2 4 8
- 3 9 27
- 4 16 64
To make empty data points like this:
Your data file should look like this:
- x,y,z
- 0,0,0
- 1,1,1
- 2,4,8
- 3,9,27
- 4,16,
- 5,25,125
- 6,,216
- 7,49,
- 8,,512
Creating a .csv file In Excel
- Enter your data into Excel.
- Open the file menu and click on "Save As".
- In the "save as type" dropdown box, select "CSV (Comma delimited) (*.csv)".
- Click on "Save".
- Click on "OK" and then "Yes" if it asks you to confirm saving as a .csv file.
Creating a .csv file In Open Office or Neo-Office
- Enter your data.
- Open the file menu and click on "Save As".
- In the "File Type" dropdown box, select "Text CSV (.csv)".
- Click on "Save".
- Click on "Yes" if it asks you to confirm saving as a .csv file.