This shows you the differences between two versions of the page.
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]] |