🚀 How to use Excel Killer
To get the best performance, this plugin accepts data as Text using Bubble's :format as text operator. This ensures your app stays fast even with large datasets.

Step 1: Define Your Columns In the Column Headers field, list your column names separated by a vertical pipe |.

        Example: Name | Email | Status | Revenue

Step 2: Set the Delimiter In the Delimiter field, enter the vertical pipe symbol: |. (Note: We recommend | instead of commas to avoid breaking data that contains addresses or descriptions).

Step 3: Load Your Data In the Table Data field, use a dynamic expression:

1. Select your list (e.g., Search for Users).

2. Click the operator :format as text.

3. In the Formatting Window:

  - Content to show per list item: Build your row using the same order as your headers, separated by the pipe |.

        Example: This User's Name | This User's Email | This User's Status | This User's Revenue

  - Delimiter: Press Enter (Use a new line to separate rows).

Step 4: Handling Clicks (Workflows) To perform an action when a user clicks a row:

  - Go to the Workflow tab.

  - Select Elements > Gridly - Row is clicked.

  - Use the state Gridly's Clicked Row Index to find the item.

        Example Action: Display Data in Popup -> Search for Users:item # (Gridly's Clicked Row Index)


💡 Pro Tip for "List" Fields
If one of your columns needs to display a list (e.g., a User has a list of Tags), use the :joined with operator inside the cell.

        Example: This User's Tags:joined with ", "


V3 Instructions:

🟢 1. Handling Row Creation vs. Updates (Crucial)
The plugin now handles row creation internally before saving to the database. You only need one Workflow on the Row Saved event.

How to distinguish:

Update: If the user edits an existing row, the exposed state clicked_row_uuid will contain the Row's Unique ID.

Create: If the user adds a NEW row (via the "+" menu) and saves it, the state clicked_row_uuid will be Empty (null).

Workflow Setup:

Step 1: Create a new thing... (Only when Excel Killer's clicked_row_uuid is empty).

Step 2: Make changes to a thing... (Only when Excel Killer's clicked_row_uuid is not empty).

💾 2. JSON Export & Save All
In the Export Menu (top-right of the grid), you now have two JSON options:

JSON (Button): Immediately downloads a .json file to the user's computer (backup).

Save to Bubble: Pushes all table data to the plugin's table_json exposed state and triggers the data_extracted event. Use this for Bulk Creates/Updates via Backend Workflows.

🧮 3. Calculated Columns (Formulas)
You can now add columns that calculate values in real-time based on other cells (e.g., Price * Qty).

How to use: Click the + icon in the Actions header → "Add Column".

Important: These columns are Client-Side Only (Ephemeral). They do not create new fields in your Bubble Database and will disappear if the page is refreshed. They are strictly for calculation and visual analysis during the session.

Inputs: Use column IDs (c1, c2, c3...) based on the order of your "Column Headers" property (Ignore Id Column).

Supported Numeric Functions: The engine is optimized for Financial/Numeric operations (always outputs 2 decimal places). String operations are not supported in this version.


📖 V4 Complete Instructions
Using the Clipboard Copy/Paste: Just copy any row/column structure from Excel or Numbers. Go to your Bubble app, click once inside the Excel Killer grid to give it focus, and press Ctrl+V (or Cmd+V on Mac). The rows will instantly generate at the bottom of the active grid with correct number/currency conversions applied.

Setting Up Custom Fonts: In the element properties panel, pass your app's font family (e.g., 'Inter', sans-serif). Adjust the base font size and primary text color to perfectly blend the grid into your UI layout.

Multi-Table Deployment: Simply drop as many elements as you need on a single page. The smart event handler isolates user inputs so each grid operates independently.