{"id":2688,"date":"2013-01-21T17:30:13","date_gmt":"2013-01-22T01:30:13","guid":{"rendered":""},"modified":"2025-02-14T07:22:43","modified_gmt":"2025-02-14T15:22:43","slug":"2688","status":"publish","type":"post","link":"https:\/\/www.vernier.com\/til\/2688","title":{"rendered":"How do I transfer LabQuest App data to a spreadsheet?"},"content":{"rendered":"<p>This document details a method for transferring data collected with LabQuest App to a computer so the data can be opened in a spreadsheet app such as Excel, OpenOffice, Numbers, or Google Sheets.<\/p>\n<p><strong>Method 1<\/strong> \u2014 Using an SD card (original LabQuest and LabQuest 2 only) or USB Flash Drive:<br \/>1. Insert an SD card or connect a USB Flash drive to your LabQuest.<br \/>2. In LabQuest App, choose Export from the File menu.<br \/>3. Select your media (SD card or Flash Drive), name the file, then tap OK.<br \/>4. Transfer the SD card or Flash Drive to your computer.<br \/>5. Open a spreadsheet program, and select to open a file.<br \/>6. Adjust the file filter to look for all files (*.*). (<strong>Note:<\/strong> The exported file is a .TXT file.)<br \/>7. Navigate to your saved file and choose Open. <\/p>\n<p><strong>Note: <\/strong>The exported .TXT file may not open directly in your spreadsheet program. If that is the case, open the file in a text editor (e.g. NotePad), then copy and paste the data into your spreadsheet.<\/p>\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p><strong>Method 2<\/strong> \u2014 Using LabQuest 2 and LabQuest 3 to transfer the file using email.<br \/>1. Set up your LabQuest 2 or LabQuest 3 to support sending emails. See, <a href=\"\/til\/11409\/\">How do I set up LabQuest 2 or LabQuest 3 to email data with labquest@vernier.com instead of my own email account?<\/a><br \/>2. In LabQuest App, choose Email \u25b6 Text File&#8230; from the File menu.<br \/>3. Enter the email address of the desired recipient(s), then tap Send.<br \/>4. On the device that received the email, open the email and save the file in your desired location.<br \/>5. Open a spreadsheet program, and select to open a file.<br \/>6. Adjust the file filter to look for all files (*.*). (<strong>Note:<\/strong> The emailed file is a .TXT file.)<br \/>7. Navigate to your saved file and choose Open. <\/p>\n<p><strong>Note: <\/strong>The emailed .TXT file may not open directly in your spreadsheet program. If that is the case, open the file in a text editor (e.g. NotePad), then copy and paste the data into your spreadsheet.<\/p>\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n<p><strong>Related Articles<\/strong><br \/><a href=\"\/til\/2903\/\">How do I transfer data from Vernier Data Share web app to Google Drive?<\/a><br \/><a href=\"\/til\/2492\/\">How do I export data from Vernier's data-collection apps to a spreadsheet program such as Excel or Google Sheets?<\/a><\/p>","protected":false},"excerpt":{"rendered":"<p>This document details a method for transferring data collected with LabQuest App to a computer so the data can be opened in a spreadsheet app&#8230;<\/p>\n","protected":false},"author":33,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[],"tags":[4064,4488,4491,4489,4490],"class_list":["post-2688","post","type-post","status-publish","format-standard","hentry","tag-chromebooks","tag-google-docs-google-drive","tag-google-spreadsheet","tag-labq-labq2-labquest-2","tag-vdsh-vernier-data-share"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.vernier.com\/til\/wp-json\/wp\/v2\/posts\/2688","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.vernier.com\/til\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.vernier.com\/til\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.vernier.com\/til\/wp-json\/wp\/v2\/users\/33"}],"replies":[{"embeddable":true,"href":"https:\/\/www.vernier.com\/til\/wp-json\/wp\/v2\/comments?post=2688"}],"version-history":[{"count":0,"href":"https:\/\/www.vernier.com\/til\/wp-json\/wp\/v2\/posts\/2688\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.vernier.com\/til\/wp-json\/wp\/v2\/media?parent=2688"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.vernier.com\/til\/wp-json\/wp\/v2\/categories?post=2688"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.vernier.com\/til\/wp-json\/wp\/v2\/tags?post=2688"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}