Introduction

42 Rows is an advanced AI-powered spreadsheet tool designed to automate complex processes and amplify the capabilities of existing AI models. Our platform allows you to run thousands of prompts automatically based on your template, enabling AI to execute long and intricate tasks that would otherwise be time-consuming.

With 42 Rows, users can either upload a CSV file or create a table directly on our website. Once the table is set up, you can write a prompt and choose an AI model to generate text, create images, or analyze images. The tool then executes these tasks for every row in the table, streamlining your workflow and saving valuable time.

Key Features

• Execute AI prompts for each row of your spreadsheet
• Support for multiple AI models for various tasks
• Generate text, images, or analyze images automatically
• Perfect for small, medium, and large businesses

Applications

The versatility of 42 Rows makes it suitable for a wide range of applications across different industries. Here are some examples:

Quick Start Guide

Welcome to 42 Rows! This guide will help you get started with our powerful AI-powered spreadsheet tool. You can begin using 42 Rows in two simple ways: by importing a CSV or JSON file, or by creating a new table from scratch. Follow the steps below to start automating your workflows.

Importing a CSV or JSON File

Step 1: Upload Your File in "File" Menu

Creating a New Table

Step 1: Create a New Table

Step 2: Add More Rows

Next Steps

Once your table is set up, you can start writing prompts and selecting AI models to generate text, images, or analyze data.

Opening Existing Files

Step 1: Access the "Open" Button

Click on the “Open” button located in the top menu bar.

Step 2: Choose Your File

A dialog box will appear, displaying a list of your previously uploaded and created files. You can easily identify your files by their names and timestamps.

Step 3: Open or Delete Files

• To open a file, simply click on its name in the list. The file will load into the main workspace, ready for you to use.
• To delete a file, click on the trashcan orange icon next to the file name. You will be asked to confirm the deletion before the file is permanently removed.

This streamlined process ensures you can quickly access your data and manage your files efficiently within 42 Rows.

Save As: Preserving Your AI-Enhanced Spreadsheet

After generating content, analyzing images, or making any other modifications with the help of 42 Rows’ AI models, you can save your progress using the Save As button. This feature allows you to download a copy of your current table in either CSV or JSON format.

Step 1: Access the Save As Option

Once you are satisfied with the data in your table, navigate to the “File” menu located in the top menu bar.

Step 2: Choose Your Format

Within the “File” menu, you’ll find the “Save As” option. Clicking on it will present you with two choices for download format:

• CSV: Save your table as a comma-separated values file, a widely compatible format for spreadsheets and data analysis.
• JSON: Save your table as a JavaScript Object Notation file, a lightweight data-interchange format commonly used in web applications.

Step 3: Download Your File

After selecting your preferred format, click the corresponding button. Your browser will initiate the download of the file, which will be named according to the original filename you uploaded or a name you provided when creating a new table.

Structure Preservation

42 Rows ensures that the downloaded file maintains the same structural integrity as your original uploaded file or the structure you defined when creating a new table. This means:

• Column Order: The order of columns in the downloaded file will match the order in your current 42 Rows table.
• Data Types: The downloaded file will preserve the data types of each cell, ensuring consistency when reopening the file in other programs.
• Generated Content: All content generated by AI models, including text, image URLs, or analysis results, will be included in the downloaded file.

This robust “Save As” functionality enables you to seamlessly integrate 42 Rows into your workflow, allowing you to easily save, share, and reuse your AI-enhanced spreadsheets.

You can reimport your file into your platforms and systems wuthout any risk or incompatibility.

Export Your Data

Once you’ve generated your content, images, or analysis results, you can easily export them from 42 Rows.

1. Click “Export”: Find and click the “Export” button located in the top menu bar.
2. Choose Your Column and File Settings: A pop-up window will appear, prompting you to:
   • Select Template Export Column: Choose the specific template column from your table that you want to use for export files.
   • Select Names Column: Choose the specific column from your table that you want to use for naming your exported files. This column’s data will be used as the unique filename for each row’s output.
   • Select File Extension: Choose the desired file extension from the dropdown list. The available options are:
     • Text-based Files: .html, .pdf, .docx (MS Word), .txt, .css (Style), .php, .asp, .py, .js (JavaScript), .class, .c, .java (Java), .vb
     • Special Option: “HTML to PDF”: This option will render the generated HTML code from your template into a visually formatted PDF file.
3. Download Your ZIP File: After making your selections, click “Export”. 42 Rows will then package all the generated files (one for each row in your table) into a convenient ZIP archive. You can then download the ZIP file to your computer.

Example:

Let’s say you used 42 Rows to generate personalized website copy for different clients. You have a column named “Client Name” in your table.

• You would select “Client Name” as your export column.
• You would choose “.html” as your file extension.

42 Rows would then create a ZIP file containing individual HTML files for each client, named according to their entry in the “Client Name” column (e.g., “JohnDoe.html”, “JaneSmith.html”, etc.).

Importing a Generation Schema

42 Rows allows you to streamline your workflow even further with the “Import Generation Schema” feature. This powerful option lets you import all settings, prompts, and model configurations from previously saved files. This is incredibly useful when dealing with similar data structures and desired outputs, saving you valuable setup time.

Example Scenario:

Imagine you use 42 Rows to generate product catalogs for an e-commerce platform. You’ve meticulously crafted prompts and chosen specific AI models for generating product descriptions, image captions, and even pricing suggestions. Now, your supplier sends you a new price list with a similar structure but updated product information.

Instead of recreating all your settings from scratch, you can simply:

1. Upload your new product list file (CSV or JSON).
2. Click the “Import Generation Schema” button.
3. Select the previously saved file containing your desired settings.

42 Rows will instantly apply all your saved configurations to the new dataset. This includes:

• Selected AI Models: Whether you’re using GPT-3 for text generation or Stable Diffusion for image creation, your chosen models will be carried over.
• Custom Prompts: All your carefully crafted prompts for different columns will be imported and ready for execution.
• Output Settings: Any specific formatting or output preferences you defined previously will also be applied.

Step 3: Execute Your Jobs

With the generation schema imported, your new file is ready for action! Simply review the imported settings, make any minor adjustments if necessary, and hit “Send All” to let 42 Rows work its magic.

Benefits of Importing Generation Schema:

• Massive Time Savings: Eliminate repetitive setup for recurring tasks.
• Enhanced Consistency: Ensure uniformity in output across different datasets.
• Simplified Workflow: Focus on data analysis and results rather than tedious configuration.

The “Import Generation Schema” button in 42 Rows empowers you to leverage your previous work, turning complex AI tasks into efficient, repeatable processes.

AI Training Modal Window

This modal window allows users to enhance 42 Rows’ content generation capabilities by providing custom training data.

Modal Title: AI Training

Modal Content:

1. Data Source:

• Website URLs:
  • Input field for pasting URLs (multiple URLs allowed, separated by commas or newlines).
  • Crawl Depth Dropdown:
    • URL Only
    • 1 Level Deep (URL + links directly accessible)
    • 2 Levels Deep (URL + 1st and 2nd level links)
  • Button: “Add URLs” – adds the URLs and initiates crawling based on selected depth.
  • Progress bar indicating crawl status (number of URLs crawled/total).
• File Upload:
  • Drag-and-drop area for uploading files.
  • “Choose Files” button for browsing and selecting files.
  • Supported formats: PDF, TXT.
  • Batch upload enabled.
  • Progress bar for each file upload.

2. Training Data Preview:

• “Show Chatbot Trainings” button:
  • Expands a section displaying the extracted text content from crawled websites and uploaded files.
  • Provides a scrollable view of the training data.

3. Training Options:

• “Use Embeddings” Checkbox:
  • When checked, 42 Rows will prioritize using the custom training data for generating content if it finds relevant information based on user prompts and embeddings similarity.
  • Unchecked: Relies on the default model’s knowledge base.

4. Actions:

• “Train” Button:
  • Initiates the training process using the provided URLs and files.
  • Displays a progress bar indicating training status.
  • Upon completion, a confirmation message appears, indicating the data is ready for use.
• “Cancel” Button:
  • Closes the modal without saving any changes.
  • manage (view, delete, retrain)  custom datasets.

Template Menu: Unleash the Power of Automation

The “Template” menu in 42 Rows takes automation to the next level. Instead of writing individual prompts, you can use pre-designed templates to generate content or execute actions based on the data in your spreadsheet. This is particularly useful for complex or repetitive tasks where consistency and efficiency are paramount.

Open Button: Access Your Template Library

Clicking the “Open” button in the “Template” menu opens a new page displaying your personal template library. This library contains all the template files you’ve previously uploaded to 42 Rows.

Understanding Templates:

A template file is essentially a blueprint for your AI actions. It can contain:

• Plain text or programming code: Use this for generating reports, scripts, code snippets, or any textual output.
• Variables: These are placeholders denoted by curly braces and a column letter (e.g., {A}). 42 Rows automatically replaces each variable with the corresponding cell content from that column in your spreadsheet.

Example:

Imagine a template file containing the following text:

## {A} - Product Description

**Price:** {B}

**Description:** {C}

When you apply this template, 42 Rows will:

1. Read the content of columns A, B, and C in each row.
2. Replace {A} with the cell value from column A, {B} with the value from column B, and so on.
3. Generate a separate output for each row based on the template structure.

File Type Selection:

When saving your template, you can choose from various file types:

• Document Formats: .pdf, .docx (Word), .txt
• Programming Languages: .c, .html, .asp, .py, .js, .java, .php
• Special Case: .pdf (from .html) – This option renders your HTML content graphically to produce a visually appealing PDF file.

Downloading Generated Files:

After 42 Rows processes your spreadsheet using the selected template, you have two download options:

• Download Single File: Click the download icon next to a specific row to download the generated file for that row.
• Download All Files (ZIP): Download all generated files conveniently packaged into a single ZIP archive.

Default Templates: Jumpstart Your Workflow

The “Default Templates” button offers a selection of pre-built templates for common use cases. These templates provide a starting point for your automation needs, saving you time and effort in setting up basic tasks. You can further customize these templates to fit your specific requirements.

Chatbot

The Chatbot feature provides users with a versatile and powerful interface to interact with various AI language models. It offers multiple functionalities, including model selection, response type selection, and data export options.

Features

1. AI Model Selection

Users can choose from a wide range of AI language models:

• GPT-3.5
• GEMINI-1.5-PRO
• GEMINI-1.5-FLASH
• GPT-4
• GPT-4O
• GPT-4O-MINI
• O1-PREVIEW
• O1-MINI
• GPT-4-1106-preview
• GPT-3.5-turbo-1106
• GPT-3.5-turbo-16k
• GPT-3.5-turbo-instruct
• Anthropic

These models are available in a single dropdown selector, allowing users to switch between different AI capabilities easily.

2. Response Type Selection

Users can choose from three types of AI responses:

1. GPT Response: The AI will provide a standard conversational response, similar to ChatGPT.
2. Embeddings Response: The AI will use embeddings to generate an answer, which can provide more context-aware responses.
3. Table Response: The AI will generate a response based on information from a provided table.

3. Table Integration

• Send Table Checkbox: Users can select a checkbox labeled “Send Table” to inform the AI about the content of a table. This allows the AI to incorporate table information into its responses, regardless of the selected response type.

4. Data Export

• Get CSV Button: After the AI generates a response, users can click the “Get CSV” button to export the conversation history as a CSV file.
• Table Export: If a table is generated during the chat, this information will be displayed in a new table file for easy reference and export.

How to Use

1. Select AI Model: Choose your preferred AI model from the dropdown menu.
2. Choose Response Type: Select the type of response you want from the AI (GPT, Embeddings, or Table).
3. Table Integration (Optional): If you have relevant table data, check the “Send Table” box to include this information in the AI’s context.
4. Start Chatting: Enter your questions or prompts in the chat interface.
5. Review Responses: Read the AI-generated responses based on your selected model and response type.
6. Export Data: Use the “Get CSV” button to download your conversation history, or refer to the generated table file if table data was produced during the chat.

Notes

• The availability and performance of different AI models may vary.
• The Embeddings and Table response types may provide more specialized or data-driven answers compared to the standard GPT response.
• Always review the exported data for accuracy and relevance to your needs.

This chatbot system offers a flexible and powerful way to interact with various AI models, making it suitable for a wide range of applications, from casual conversation to data-driven analysis.