Generate data in Canva Sheets using Magic Write
Canva Sheets offers three ways to use Magic Write.
Generate a Table from a Prompt
- Open a Canva Sheets file.
- Select a blank cell where the table should start.
- In the floating toolbar, select Actions, then choose Generate table.
- Enter a prompt (e.g., “Weekly project tracker for a marketing team”).
- Select Generate, then Insert to place the table.
Fill a range of empty cells with content
- Select a group of empty cells.
- Click Actions.
- Select Fill empty cells.
- Magic Write will suggest content based on the cell context.
- To customize the result, click More like this or This but..., then enter a prompt (e.g., “List five inspirational quotes.”).
- Press Enter or arrow up icon to regenerate the content based on your prompt.
- Select Insert to add the results to your sheet.
Apply Magic Write to existing cell content
- Select the cells you want to enhance.
- ClickActions in the floating toolbar, then choose Magic Write.
- In the prompt window, type your request (e.g., “List the top 5 largest cities and their population”).
- Press Enter or click the arrow up button to generate results.
- To refine the output, click More like this or This but..., then enter a new prompt (e.g., “List five inspirational quotes”).
- Press Enter to regenerate the content.
- When you're satisfied with the output, click Insert to apply it to your sheet.
Magic Write Selection Requirements
The range you select helps Magic Write understand the context of your data, but it must meet the requirements of the action:
- For Fill Empty Cells, the range must only include empty cells.
- For Generate Table and Magic Write, start from a blank cell or valid selection.
If the selection includes content where it shouldn't, you'll see an error and the action will not proceed.
Learn about how Magic Write works and the different ways to use it.
Was this helpful?
Helpful
Unhelpful