Tutorials

Learn Cellify step by step.

Four short guides.

1. The Cellify panel

What each part of the panel does.

  1. Top bar: your plan and the message counter (used / available), Favorites (heart), New chat, and the ⋯ menu with your account, panel colors, language, “Check for errors” and “Write to us”.
  2. Start screen: in an empty chat, “What can I do?” suggests three requests that fit your file, “Check for errors” checks the sheet without changing it, and “Summarize” says what the workbook is about. None of them uses a message.
  3. Message box: write what you need in your own words, in any language. Attach PDF, CSV or Excel files with the paper clip.
  4. Work panel: while Cellify works you see the current step; afterwards a summary such as “Done · 5 changes in Excel”. Click it to see every action and where it ran.
  5. Undo these changes: under each answer; one click reverses the whole request.

2. Your first request

  1. Open a sheet with your data (or an empty one).
  2. Write a request, for example: “Turn this data into a table, add a Revenue column (quantity × price) and a chart of revenue by region.”
  3. Cellify reads the workbook first, then makes the changes and tells you what it did. “This sheet” always means the sheet that is open when you send the message.
  4. Before deleting or overwriting anything, Cellify shows what will change and waits for your click.

Tip: name the columns and sheets you mean. “Sum of Amount by Region on a new sheet” works better than “make a summary”.

3. Big tasks: the plan and Continue

  1. You can ask for several things in one message, for example a table, two pivot tables, three charts and formatting.
  2. Cellify shows its plan in the work panel and ticks off each part as it finishes.
  3. Each message uses one from your plan. If a request is too big for one message, Cellify finishes the parts it started and shows what is done and what is left.
  4. Click Continue · uses 1 message to go on. Cellify reads the workbook again and does only what is left.

4. Repeated work: Favorites

  1. Do you prepare the same report every month? Write the whole request once, with the steps numbered and the column names you use.
  2. Click the heart next to your message to save it as a Favorite.
  3. Next month, open Favorites, click Use: the request is put into the message box. Adjust it if needed (for example the month) and send.
  4. The Catalog tab in Favorites has 150 ready-made requests by category; “Use” puts one into the message box, “Save” copies it to your Favorites.
See what you can ask