How to Get Your myBrain to Answer Questions on Data in Tables

In this blog post, you will learn how to optimize your data for use with myBrain, allowing it to accurately answer questions based on data in tables.

Published on:

Do not index
Do not index
In this blog post, you will learn how to optimize your data for use with myBrain, allowing it to accurately answer questions based on data in tables.
By the end of this guide, you'll be able to transform your data into a structured format that myBrain can easily understand and process, ultimately improving the efficiency and accuracy of the AI's responses.

Step 1: Understand the Issue with Different Formats

myBrain struggles to answer questions when the data is in PDF or text formats because it's not structured well. The solution is to use a CSV format which forces a structure, making the data contextually relevant.

Step 2: Export Your Data as a CSV

Export your data as a CSV file from your table source, like Airtable, Google Sheets, or Excel. This will provide the structured format needed for myBrain to understand and process the information.

Step 3: Access myBrain’s CSV Upload Template

To access the CSV upload template, go to your myBrain’s dashboard, create a new myBrain project, and click on "?" followed by "Upload a CSV." Then, click on "Use our template" to access the CSV upload template.

Step 4: Follow the Template Instructions

Make sure to follow the template instructions, such as not having empty rows, including the content and title columns, not deleting any columns, and adhering to the character and row limits.

Step 5: Create Key-Value Pairs

Transform your data into key-value pairs for each item in the table. This will help myBrain understand the relationships between the different data points.

Step 6: Upload the CSV to myBrain

Once you have formatted your data according to the template, upload the CSV to myBrain. This will allow the system to effectively process the information and answer questions about the data in the table.
By following these steps, you'll be able to get your myBrain to answer questions on data in tables with more accuracy and efficiency.

Bonus (Macro)

This is the macro I used to reformat my table, just paste into Excel as a macro module, make sure your sheet with the table in is called Sheet1 and click ‘Run’.
Sub MergeHeaderAndDataForRange()
    Dim ws As Worksheet
    Dim dataRange As Range
    Dim headerRange As Range
    Dim lastCol As Long
    Dim lastRow As Long
    Dim i As Long
    Dim j As Long
    Dim result As String
    ' Set reference to the worksheet containing the data
    Set ws = ThisWorkbook.Sheets("Sheet1") ' Change "Sheet1" to the name of your worksheet
    ' Find the last row and last column of the data
    lastRow = ws.Cells(ws.Rows.Count, 1).End(xlUp).Row
    lastCol = ws.Cells(1, ws.Columns.Count).End(xlToLeft).Column
    ' Set reference to the header range
    Set headerRange = ws.Range(ws.Cells(1, 1), ws.Cells(1, lastCol))
    ' Set reference to the data range (excluding the header row)
    Set dataRange = ws.Range(ws.Cells(2, 1), ws.Cells(lastRow, lastCol))
    ' Loop through each row of the data range
    For i = 1 To dataRange.Rows.Count
        result = ""
        ' Loop through each column of the data range
        For j = 1 To dataRange.Columns.Count
            ' Concatenate the header and data with line breaks
            result = result & headerRange.Cells(1, j).Value & ": " & dataRange.Cells(i, j).Value & vbNewLine
        Next j
        ' Write the result to the new column
        ws.Cells(dataRange.Row + i - 1, dataRange.Column + lastCol).Value = result
    Next i
End Sub

Join other 3200+ marketers now!

Ready to take the next big step for your business?