{"id":260,"date":"2024-10-09T11:46:56","date_gmt":"2024-10-09T10:46:56","guid":{"rendered":"https:\/\/wp.coventry.domains\/copilotcookbook\/?page_id=260"},"modified":"2025-03-26T14:20:04","modified_gmt":"2025-03-26T14:20:04","slug":"work-with-a-spreadsheet","status":"publish","type":"page","link":"https:\/\/wp.coventry.domains\/copilotcookbook\/work-with-a-spreadsheet\/","title":{"rendered":"Work with a spreadsheet"},"content":{"rendered":"\n<p class=\"is-style-info wp-block-paragraph\">You can tell Copilot to <strong>&#8216;Create a<\/strong> <strong>spreadsheet<\/strong>&#8216;<strong> <\/strong>and it should give you a download link to a .xlsx Excel file. However, this can be a bit buggy. See &#8216;Can Copilot create spreadsheets?&#8217; in the <a href=\"https:\/\/wp.coventry.domains\/copilotcookbook\/faq\/\">FAQ<\/a> for more guidance.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Description<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What?<\/strong>&nbsp;Upload a spreadsheet and ask Copilot to do something with the data in it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Why?<\/strong>&nbsp;If you&#8217;re not confident with Excel formulas, it can take time to pull out specific values from a spreadsheet. You can upload a spreadsheet to Copilot and tell it what you want it to do, and it can quickly extract relevant data.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>What do I need to know? <\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Any data you upload to Copilot will be stored in your OneDrive,<\/strong> in a folder called &#8216;Microsoft Copilot Chat Files&#8217;. Be careful that you are not uploading and storing data in a way that will contravene data retention and GDPR rules. You can delete files from this folder once you&#8217;ve finished your Copilot chat.<\/li>\n\n\n\n<li><strong>Be specific about the columns \/ rows you want Copilot to work with<\/strong>. Due to the weaknesses of large-language models when working with numerical data, Copilot will often generate Python code and run this in the background to analyse the spreadsheet. This Python code requires precise values about which cells to analyse. You&#8217;ll know that Copilot is generating code when it displays the message &#8216;Executing task&#8217;.<\/li>\n\n\n\n<li><strong>This recipe works best with simple spreadsheets. <\/strong>Copilot seems to have a &#8216;token limit&#8217; (a limit to have much data it will process) but frustratingly, it is not very transparent about this. If you upload large spreadsheets or documents, it will only analyse part of them, but it will not state how much it has looked. Other tools (ChatGPT, Claude) are currently better at working with large data sets. Check any information Copilot gives you carefully as it can generate plausible-seeming information that isn&#8217;t actually in the spreadsheet. If accuracy is crucial, it&#8217;s probably better to <a href=\"https:\/\/wp.coventry.domains\/copilotcookbook\/create-an-excel-formula\/\" data-type=\"page\" data-id=\"270\">ask Copilot for an Excel formula<\/a> that will do what you want, rather than asking it to analyse data directly.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Example<\/strong> <strong>Video<\/strong><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\ud83d\udcf9 <a href=\"https:\/\/media.coventry.ac.uk\/View.aspx?id=43466~5k~cDWuC4GXUr&amp;code=KJ~LLfrjbPirgPMyKEQ8gJs8CRNUKvBhZNwjKg2fkjirPcTozp787pmNCLgSgihNNb6NJSpwNDE&amp;ax=7E~msEJPJ6d94vQqp\" data-type=\"link\" data-id=\"https:\/\/media.coventry.ac.uk\/View.aspx?id=43466~5k~cDWuC4GXUr&amp;code=KJ~LLfrjbPirgPMyKEQ8gJs8CRNUKvBhZNwjKg2fkjirPcTozp787pmNCLgSgihNNb6NJSpwNDE&amp;ax=7E~msEJPJ6d94vQqp\" target=\"_blank\" rel=\"noreferrer noopener\">Video \u2013 Work with spreadsheets example (media.coventry.ac.uk)<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Instructions<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 1:&nbsp;<\/strong>Find a spreadsheet that has some data you want to work with.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 2:&nbsp;<\/strong>Go to&nbsp;<a href=\"https:\/\/www.office.com\/chat\" target=\"_blank\" rel=\"noreferrer noopener\">Copilot (office.com\/chat)<\/a>&nbsp;and sign in with your Coventry account. If you\u2019re already using Copilot, just select the \u2018New chat\u2019 button at the top right.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 3:&nbsp;<\/strong>Select \u2018Add a file\u2019 (the paperclip&nbsp;\ud83d\udcce icon) at the bottom right of the text box, and then in the file browser select the spreadsheet on your computer. Don\u2019t press submit yet!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 4:&nbsp;<\/strong>Copy and paste the following prompt into the Copilot message box, then select the \u2018Submit\u2019 button (the arrow at the bottom-right):<\/p>\n\n\n\n<div class=\"wp-block-coblocks-accordion\">\n<div class=\"wp-block-coblocks-accordion-item has-custom-font\" style=\"font-family:Inconsolata\"><details><summary class=\"wp-block-coblocks-accordion-item__title\">\u00a0\ud83e\udd16 Prompt (click to expand, then copy and paste into Copilot)<\/summary><div class=\"wp-block-coblocks-accordion-item__content\">\n<p class=\"wp-block-paragraph\">I\u2019m going to give you a spreadsheet. First, create a table with a copy of the data from the spreadsheet. Then ask me what I want you to do with the table \u2013 for example, do I want you to extract or remove certain data, analyse the existing data, update specific cells, or create a new column with certain values? Wait for my response. Then update the table according to my instructions<\/p>\n<\/div><\/details><\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 5: <\/strong>Copilot should ask you what you want to do with the data in the spreadsheet. Type your instructions in the text box, e.g. &#8216;Combine the values in the first and second column into a single column. Create a new table with this new data&#8217;. Then select &#8216;Submit&#8217;.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 6:<\/strong> Copilot should follow your instructions and create a new table with the relevant data. If it doesn&#8217;t, just repeat your instruction to &#8216;Create a table with the information I requested&#8217;. If you want to download the table, tell Copilot \u2018Create a spreadsheet with the table\u2019. It should produce a link to a .xlsx Excel file. Sometimes this can be a bit buggy \u2013 see \u2018Can Copilot create spreadsheets?\u2019 in the&nbsp;<a href=\"https:\/\/wp.coventry.domains\/copilotcookbook\/faq\/\">FAQ<\/a>&nbsp;for further guidance.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Step 7:<\/strong> Check the Copilot-generated table \/ spreadsheet carefully against the original spreadsheet to see if it has generated any false information.<\/p>\n\n\n\n<p class=\"is-style-warning wp-block-paragraph\"><strong>Important:&nbsp;<\/strong>Always check Copilot\u2019s output. Generative AI tools can hallucinate (create plausible but incorrect information)<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can tell Copilot to &#8216;Create a spreadsheet&#8216; and it should give you a download link to a .xlsx Excel file. However, this can be a bit buggy. See &#8216;Can Copilot create spreadsheets?&#8217; in the FAQ for more guidance. Description What?&nbsp;Upload a spreadsheet and ask Copilot to do something with the data in it. Why?&nbsp;If [&hellip;]<\/p>\n","protected":false},"author":3323,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_coblocks_attr":"Inconsolata","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"class_list":["post-260","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/wp.coventry.domains\/copilotcookbook\/wp-json\/wp\/v2\/pages\/260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.coventry.domains\/copilotcookbook\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/wp.coventry.domains\/copilotcookbook\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/wp.coventry.domains\/copilotcookbook\/wp-json\/wp\/v2\/users\/3323"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.coventry.domains\/copilotcookbook\/wp-json\/wp\/v2\/comments?post=260"}],"version-history":[{"count":23,"href":"https:\/\/wp.coventry.domains\/copilotcookbook\/wp-json\/wp\/v2\/pages\/260\/revisions"}],"predecessor-version":[{"id":506,"href":"https:\/\/wp.coventry.domains\/copilotcookbook\/wp-json\/wp\/v2\/pages\/260\/revisions\/506"}],"wp:attachment":[{"href":"https:\/\/wp.coventry.domains\/copilotcookbook\/wp-json\/wp\/v2\/media?parent=260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}