[et_pb_section fb_built=”1″ _builder_version=”4.20.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row _builder_version=”4.24.1″ _module_preset=”default” locked=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
This is a collection of awesome Chat GPT prompts to power-up your spreadsheet game<\/b>. We will look at general prompts for all spreadsheet apps, and then we will go into specific prompts for Google Sheets or Excel. Finally, we will explore how AI can help you bring regular expressions into your spreadsheets.<\/p>\n
We consider these prompts to be awesome because of their power, not necessarily because of their complexity. Matter of fact, most are pretty simple and straightforward.<\/p>\n
Let\u2019s get into it! Hopefully after trying out a few of these yourself you will get ideas to create prompts of your own.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”spreadsheets” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
These are awesome Chat GPT prompts that are useful for any spreadsheet software<\/b>. Whether you are using LibreOffice Calc or Google Sheets, these are great to keep handy.<\/p>\n
Almost, if not all, prompts will consist of two parts: instructions and context<\/b>. Usually for AI context is everything and this is no exception; without it Chat GPT won\u2019t be able to be of much help.<\/p>\n
As a rule of thumb almost every prompt will require sample data from your spreadsheet<\/b>. Just copy and paste the header and the first row from the spreadsheet into your prompt. This will allow ChatGPT to get a sense of what each column is and what kind of data it holds.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Chat GPT can churn out great formulas<\/b> to help analyze data and get work done. For this use case, specifying the purpose of the formula in detail is really important.<\/p>\n
It\u2019s also a good idea to double check the results of the suggested formula<\/b>. To do this, you can incorporate it into your spreadsheet and make sure the results are what you are looking for. If they aren\u2019t, feeding Chat GPT the expected result might be all it needs to fix the formula.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Generate a formula for [SPREADSHEET_SOFTWARE] based on the information provided below (don’t go over the process unless asked), then provide instructions on how to include it in my spreadsheet.<\/p>\n
PURPOSE ><\/p>\n
SAMPLE DATA ><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Formulas can be pretty daunting<\/b>, particularly if they are too long and include several functions. In cases like this, it\u2019s always a great idea to analyze each of its parts separately and then put them together.<\/p>\n
A little tip, when trying to dissect a formula your first impulse might be to read it from left to right. While sometimes that gets the job done, for formulas that are too long it is best to do the opposite. Starting from the inner parts of the formula and working your way out is usually a better idea.<\/p>\n
Otherwise, you might want to try this prompt. Its output will walk you through all the functions being used, while mapping ranges to actual concepts.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Break down the following formula into its constituent functions and operations. Explain each step in detail. If I provide sample data, refer to columns by their header name. The beginning of your analysis should include the formula with no preamble.<\/p>\n
FORMULA ><\/p>\n
SAMPLE DATA > <\/p>\n
[\/et_pb_text][et_pb_text module_id=”troubleshoot” _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
We\u2019ve all been there, you spent a lot of time on a formula but can\u2019t get it to work. Usually it\u2019s a great idea to step away and revisit your spreadsheet later, but often that’s a luxury we can\u2019t afford. When you are pressed for time, Chat GPT can be really helpful.<\/p>\n
This is an awesome Chat GPT prompt not only to get your formula to work but also to learn<\/b>. The suggested fix might include functions you don\u2019t know or solutions you hadn\u2019t considered.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Troubleshoot the following formula I created for [SOFTWARE].<\/p>\n
FORMULA ><\/p>\n
ERROR MESSAGE ><\/p>\n
SAMPLE DATA ><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Spreadsheets are really complex tools, and chances are you still have features to explore<\/b> (if you don\u2019t, we want to meet you!).<\/p>\n
Surely you can relate to the feeling of learning about a new function and thinking to yourself \u201cI should have known this ages ago\u201d.<\/p>\n
Get ahead of the game with this prompt <\/b>and find out new useful features for your projects. In this case, most of the context is completely optional, provide it only if you want a personalized answer.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Teach me how to use a [SPREADSHEET_SOFTWARE] function or feature that might come in handy for my work.<\/p>\n
FUNCTIONS I KNOW ><\/p>\n
PROJECT DESCRIPTION ><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Creating sample data is most useful when trying to showcase or learn certain spreadsheet features. It is often time consuming and results vary depending on your knowledge of the topics this data is built around.<\/p>\n
All you need to do is tell ChatGPT what the data should be about <\/b>and it will generate a spreadsheet for you in no time. By default this will generate 20 rows of data, change that according to your needs.\u00a0<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Generate a spreadsheet with real-looking information. The output should be in tsv format. Its content should look real and consistent. As appropriate, these real values should either be consistent (the cost and category of a specific item should be the same in a sales data sheet) or random (the date when these sales were made should reflect actual sales spread, more than one sale can be made in a single day). Unless otherwise specified generate 20 rows of sample data.<\/p>\n
<\/p>\n
When creating a new spreadsheet you will follow a series of steps. 1) Acknowledge this first prompt. 2) Give possible column headers for this spreadsheet, I will ask you to edit these as necessary. 3) Once the header is established you will proceed to generate the spreadsheet.<\/p>\n
<\/p>\n
SAMPLE DATA TOPIC ><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
If you want to generate exercises to learn new spreadsheet skills<\/b>, it saves a lot of time to have Chat GPT craft them. Use this prompt to avoid the hassle of generating sample data and to ask for tips if you get stuck.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Generate a training exercise for [FEATURE\/FUNCTION] on [SPREADSHEET_SOFTWARE]. Provide sample data to work with. Don’t provide the solution, I will request it if I can’t solve it myself.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”google_sheets” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Formulas might break in the process of transferring data <\/b>from Google Sheets to Excel. This is to be expected, as both tools don\u2019t have the exact same features or functions.<\/p>\n
It is really important to clarify what version of Excel you are using as Microsoft updates it often.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Adapt the following Excel [EXCEL_VERSION] formula to Google Sheets. If this can’t be resolved with another formula then provide a workaround, this workaround may include third party tools.<\/p>\n
FORMULA ><\/p>\n
SAMPLE DATA ><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
It is usually pretty challenging to design spreadsheets that will be easily understood <\/b>by everybody who will be using them. This is an awesome Chat GPT prompt to improve teamwork and avoid misunderstandings.<\/p>\n
Note: For this use case attach a csv or tsv file for Chat GPT to analyze<\/b>. This will provide better context and, in turn, you will get better suggestions.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Give me specific tips on how to improve the attached Google Sheets spreadsheet for the purpose of collaboration with my team. Only provide these personalized suggestions if you see room for improvement. Covered topics may include but are not limited to: header names, header order, better nomenclature for columns that hold category information, adding contextual information regarding how to use the spreadsheet. Don’t give me general suggestions and don’t worry about formatting.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
There are a lot of reasons to ditch your old spreadsheet software and migrate to Google Sheets. The main reasons are that it\u2019s free, it makes collaboration easy and it\u2019s cloud-based so your files are always available.<\/p>\n
Learning how to use new software is always a difficult process. Features you were used to might be slightly different or entirely missing. Also, you might miss out on features the new tool offers because you don\u2019t know of their existence.<\/p>\n
Context is not so important for this prompt because basic differences will be relevant regardless of the reasons for the change.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
I am an\u00a0 [USER_LEVEL] of [SPREADSHEET_SOFTWARE] and I will migrate to using Google Sheets. Give me a list of important things I should know to make this transition easy and so I can make the most of this new tool.<\/p>\n
MIGRATION REASON ><\/p>\n
DATA TO BE PROCESSED ><\/p>\n
[\/et_pb_text][et_pb_code _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_code][\/et_pb_column][\/et_pb_row][et_pb_row _builder_version=”4.24.1″ _module_preset=”default” locked=”off” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_text module_id=”excel” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Excel is a powerhouse of spreadsheet software, it offers great features for data analysis, visualization, and complex calculations. Understand how to use AI to enhance your Excel experience<\/b> to significantly improve productivity and data handling efficiency.<\/p>\nAdapt a Google Sheets formula for Excel<\/h3>\n
Google Sheets and Excel share many similarities in their formula syntax and functions. This makes it possible to adapt formulas from one platform to the other with minimal adjustments.<\/p>\n
However, there are instances where certain Google Sheets functions don’t have a direct counterpart in Excel or work differently. And in those cases having ChatGPT adapt formulas can save you a lot of headaches<\/b>.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Adapt the following Google Sheets formula to Excel [EXCEL_VERSION]. If this can’t be resolved with another formula then provide a workaround, this workaround may include third party tools.<\/p>\n
FORMULA ><\/p>\n
SAMPLE DATA ><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Excel boasts of some unique features especially when compared to Google Sheets. The biggest benefit of working with Excel is its data processing capabilities.<\/b> On the other hand, working with large spreadsheets on the cloud can really slow things to a halt.\u00a0<\/p>\n
Excel is the oldest of all spreadsheet programs<\/b>, over the years it has set the path for the competition to follow. This means that most of these alternatives are quite similar, but counterintuitively this might make it harder to change tools. You might lose time looking for features that you expect but don\u2019t exist.<\/p>\n
This prompt is a lifesaver if you are trying to learn Excel. Use it to learn what differences to look out for and which features to investigate.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
I am an\u00a0 [USER_LEVEL] of [SPREADSHEET_SOFTWARE] and I will migrate to using Excel [EXCEL_VERSION]. Give me a list of important things I should know to make this transition easy and so I can make the most of this new tool.<\/p>\n
MIGRATION REASON ><\/p>\n
DATA TO BE PROCESSED ><\/p>\n
[\/et_pb_text][et_pb_text module_id=”regular_expressions” _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Regular expressions, also known as regex, are sequences of characters used to define flexible search patterns.<\/b> They are a great complement to spreadsheets because they allow you to extract, match and replace values.<\/p>\n
Regular expressions remain an elusive topic even for a lot of people who\u2019ve studied them. However, these awesome Chat GPT prompts should bring this powerful tool out of obscurity<\/b> and into your day to day. What\u2019s best? You don\u2019t even have to understand the output to get it to work.<\/p>\n
It\u2019s important to keep in mind that regular expressions have a wide range of applications that extend far beyond spreadsheets. This means it\u2019s a good idea to let Chat GPT know where you\u2019ll be using the output. Additionally, it means all the following prompts can be used for projects that expand beyond spreadsheets<\/b>.<\/p>\nUnderstand a regular expression<\/h3>\n
Even if you have a lot of experience with regular expressions they are still hard to read. For this tedious task, a little help always comes in handy. This prompt will break down the expression <\/b>and it will even try to guess a possible application.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Break down the following regular expression. Separate it into different parts and mention what types of strings it might match. Venture a hypothesis of what this regular expression can be used for.<\/p>\n
REGULAR EXPRESSION ><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
With this prompt creating a regular expression is super easy.<\/b> All you need are two lists of strings: one you want to match and another you don\u2019t. This will provide the building blocks for Chat GPT to know what you are looking for.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Generate a regular expression for [SPREADSHEET_SOFTWARE]. I will provide a list of strings it should match and a list of strings it shouldn’t match.<\/p>\n
CONTEXT >\u00a0<\/p>\n
MUST MATCH ><\/p>\n
DON’T MATCH ><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
You will probably have to test the output against real data and check if there are any false positives (i.e. strings the expressions shouldn\u2019t have matched but did). Then iterate the regular expression until you are happy with the results.<\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
This is a really powerful prompt to improve an existing regex<\/b>. By seeing the strings a regular expression would match you can get a sense of how fine tuned your expression really is. What\u2019s more, by pushing a regular expression to its limits it can help you find loopholes.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Give me a list of 10 strings that would match the following regular expression. Of those 10 strings, generate 5 that are reasonable matches and 5 that push the regular expression to its limits.<\/p>\n
REGULAR EXPRESSION ><\/p>\n
[\/et_pb_text][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Troubleshooting is a natural part of working with regex<\/b>, there are often many possible matches that are easy to overlook. This is a straightforward prompt, but it is an invaluable tool to iterate your expressions to perfection.<\/p>\n
[\/et_pb_text][et_pb_text module_class=”spreadsheet-function” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Troubleshoot the following regular expression.<\/p>\n
REGULAR EXPRESSION ><\/p>\n
EXPECTED BEHAVIOR >\u00a0<\/p>\n
PROBLEM ><\/p>\n
[\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.24.1″ _module_preset=”default” custom_margin=”40px||||false|false” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
That\u2019s it for now! All of these awesome chat gpt prompts will take your use of spreadsheets to the next level. Now you can get your work done faster and more efficiently.<\/p>\n
As a nice complement, you can create your own regular expressions with little knowledge of how they actually work.<\/p>\n
Check out our post on How to generate Google Sheets formulas with AI<\/a> for an in-depth comparison of using different AIs to generate formulas.<\/p>\n