This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
help:importing [2014/04/09 15:55] 127.0.0.1 external edit |
help:importing [2015/10/31 03:21] (current) admin |
||
|---|---|---|---|
| Line 33: | Line 33: | ||
| [[https://www.youtube.com/watch?v=bi59lO9JwWI |{{:help:play_button.gif|}}]] Another video is also available showing how to import data using SOFA Statistics: [[https://www.youtube.com/watch?v=bi59lO9JwWI]] | [[https://www.youtube.com/watch?v=bi59lO9JwWI |{{:help:play_button.gif|}}]] Another video is also available showing how to import data using SOFA Statistics: [[https://www.youtube.com/watch?v=bi59lO9JwWI]] | ||
| - | ===== Importing Google Docs Online Spreadsheets ===== | ||
| - | |||
| - | - Click on the “Import Data” button on the main SOFA form | ||
| - | - Click on the "Google spreadsheet" button\\ {{:help:import_gdata_option.jpg|}} | ||
| - | - Enter the correct email and password details to sign into your Google account\\ {{:help:download_google_spreadsheet.jpg|}}\\ The existing spreadsheets are listed and then you can select a worksheet. If there is only one spreadsheet and one worksheet there is no need to make a selection. | ||
| - | - Click on the "Download" button to download the data onto your local machine. | ||
| - | - The data is saved in a local SOFA folder as an ods format file. | ||
| - | - Change the SOFA Table Name and then click on the "Import" button.\\ {{:help:import_downloaded_google_file.jpg|}} | ||
| - | |||
| - | [[http://www.sofastatistics.com/videos.php#importing_google |{{:help:play_button.gif|}}]] A video is available showing how to import Google Docs data: [[http://www.sofastatistics.com/videos.php#importing_google | Importing Google Docs spreadsheets video]] | ||
| [[http://www.sofastatistics.com/userguide.php | Contents]] | [[http://www.sofastatistics.com/userguide.php | Contents]] | ||