The structure of your AI prompt will depend on the output you’re looking for – written outputs, spreadsheet outputs, code outputs, etc. For written outputs, provide a task, topic, style, tone, audience, length and format. For spreadsheet prompts, provide the platform you’re using, describe what you’re looking for the formula to do in depth, provide information around your data range – cells, sheet name, and if it contains a header, column and/or row references. Bonus, if you know the function that should be used, provide it!

To create the best AI prompt, always start with a clear goal in mind. The more specific, concise, and simple you can be, the less likely you’ll need to create a follow up prompt. Lean towards using very natural language and always avoid ambiguity. Provide as much context and keywords you can and you’re headed towards a prompt you’re happy with. Use our free tool above as guidance to create the best prompt.

The core difference between GPT-3 and GPT-4 is that GPT-4 has more parameters, leading to improved performance. ChatGPT, on the other hand, is a fine-tuned version of GPT-3 that has been optimized for conversational AI purposes, resulting in more human-like responses. Which we love!

Yes. There are tools out there including SheetsGPT, Ajelix, SimpleML, and PromptLoop. Learn more about these Google Sheets AI productivity tools.

To convert a ChatGPT output into a CSV file, you’ll need to create a follow up prompt asking ChatGPT to turn your list into a CSV file. Next, click the ‘Copy code’ link. Then, you’re ready to copy-paste your list into a spreadsheet!