42ROWS Quick Start Guide
42ROWS is your go-to platform for automating tedious spreadsheet tasks with AI.
From creating tables to running complex AI prompts, everything you need to amplify productivity is here. Let’s dive into the core features!
File Tab Features
Table Tab Features
Prompt Features
AI Tools Tab Features
Execution Commands
Chatbot Features
File Tab Features
Create New Table
Start fresh by clicking File > Create New Table. Enter your table name and column count, and you’re good to go!
Open Existing File
Need to revisit a previous table? Use File > Open Existing File, and load your saved file effortlessly.
Save Table
Save your progress with File > Save Table. Keep your work secure in just a click.
Import File
Import data directly with File > Import file. Supports both CSV and JSON formats.
Export as CSV
Share or back up your table as a CSV with File > Export as CSV
Export as JSON
Prefer JSON? Export with File > Export as JSON
Table Tab Features
Row operations
Add Row
Expand your table by adding new rows with Table > Add Row.
Delete Row
Remove unnecessary rows with Table > Delete Row.
Clean Row
Keep your table tidy by clearing data in specific rows with Table > Clean Row.
Generate Row Content
Use AI to populate rows dynamically with Table > Generate Row Content.
Column operations
Add Column
Need more data points? Add columns via Table > Add Column.
Delete Column
Simplify your table by deleting unnecessary columns with Table > Delete Column.
Clean Column
Clear column data while keeping the structure intact using Table > Clean Column.
Merge Columns
Combine information from multiple columns using Table > Merge Columns.
Generate Column Content
Leverage AI to fill columns efficiently with Table > Generate Column Content.
Table operations
Transpose
Switch rows with columns for a new perspective using Table > Transpose.
Re-order Columns
Drag and drop columns into your preferred order with Table > Re-order Columns.
Prompt Features
Copy Prompts from Other Files
Save time by reusing prompts already used previously in another table. Access via Table > Copy Prompts from Other Files.
Generate All Prompts
Let AI generate prompts for the entire table with Table > Generate All Prompts.
Rewrite All Prompts
Refresh your table’s prompts using Table > Rewrite All Prompts.
Setting Column Prompts
1. Open Column Settings
- Click the three dots on the column header and select Set Prompt.
2. Configure the Prompt
- In the pop-up, complete the following steps:
- Title: Add a descriptive name for the column prompt.
- Select AI Model: Choose the AI model to process this prompt.
- Prompt: Write the instructions for the AI to execute.
- Available Variables: Link this prompt to other columns or data variables for dynamic content generation.
- Content Generation Source: Define the context for the AI to generate content (e.g., cell, row, column, or table).
3. Save and Apply
- Save your settings to activate the prompt for the selected column.
AI Tools Tab Features
Smart Complete
Quickly complete your data with intelligent AI suggestions using AI Tools > Smart Complete.
Create Context
Build context-rich prompts with AI Tools > Create Context.
Execution Commands
Execute Jobs
Run your table’s prompts with a single click using Execute Jobs.
Fill Empty Cells Only
Preserve existing data while filling blanks with Fill Empty Cells Only.
Chatbot Features
Select AI Model
Choose the perfect AI for your task from the Chatbot > Select AI Model dropdown.
Type of Response
Customize outputs with response types like GPT, embeddings, or table-based results.
-
- GPT Response: The AI will provide a standard conversational response, similar to ChatGPT.
- Embeddings Response: The AI will use embeddings to generate an answer, which can provide more context-aware responses.
- Table Response: The AI will generate a response based on information from a provided table.
Send Table Data
Enable Send Table Data to use existing table info as input for the AI.
Need More Help?
Get in touch with us!