GPTExcel
Sign inStart free
Script Generator

AI VBA & Apps Script generator

GPTExcel's script generator writes spreadsheet automation code from a plain-English description: VBA macros for Excel, Apps Script for Google Sheets, LibreOffice Basic, Airtable scripts, and Python. It can also explain what an existing script does or refactor it.

Try the Scripts tool freeSee pricing

How it works

From plain English to a working macro

  1. 1

    Choose the script language

    Pick VBA for Excel, Apps Script for Google Sheets, LibreOffice Basic, Airtable Script, or Python.

  2. 2

    Describe the automation

    Explain what should happen in plain English, e.g. “Loop through every sheet and delete empty rows”.

  3. 3

    Generate the script

    GPTExcel returns the complete script in a copyable code block with notes on how it works and anything to set up.

  4. 4

    Paste it into your editor and run

    Paste VBA into the Visual Basic Editor (Alt+F11) in Excel, or Apps Script into Extensions › Apps Script in Google Sheets. Use Explain or Optimize on scripts you already have.

Example

One prompt, one result

A typical request and the kind of answer the Scripts tool returns. AI output varies, so check it against your own data before you rely on it.

Language: Visual Basic Script (VBA) · Excel

Loop through every sheet and delete empty rows

Result

Here's a VBA macro that removes every completely empty row from each worksheet in the workbook.

Sub DeleteEmptyRowsInAllSheets()
    Dim ws As Worksheet
    Dim lastRow As Long, r As Long

    Application.ScreenUpdating = False
    For Each ws In ThisWorkbook.Worksheets
        lastRow = ws.UsedRange.Row + ws.UsedRange.Rows.Count - 1
        For r = lastRow To 1 Step -1
            If Application.WorksheetFunction.CountA(ws.Rows(r)) = 0 Then
                ws.Rows(r).Delete
            End If
        Next r
    Next ws
    Application.ScreenUpdating = True
End Sub
  • Rows are checked from the bottom up so deleting one doesn't skip the next
  • CountA treats a row as empty only when no cell in it has a value
  • Save the workbook as .xlsm to keep the macro, and keep a backup: deleted rows can't be undone

Supported languages

Written for the tool you actually use

Every mode works with every option below: Generate, Explain, Optimize.

  • Visual Basic Script (VBA)

    Excel 365, Excel 2021, Excel 2019, Excel 2016, Excel 2013, Excel 2010

  • Apps Script (JavaScript)

    For Google Sheets

  • LibreOffice Basic Script (Basic)

    For LibreOffice Calc

  • Airtable Script (JavaScript)

    For Airtable

  • Python Script

    Excel: openpyxl, xlwings · Google Sheets: Google Sheets API · LibreOffice Calc: UNO API · Airtable: Airtable API

Frequently asked questions

Which scripting languages does the script generator support?
Visual Basic Script (VBA) for Excel, Apps Script (JavaScript) for Google Sheets, LibreOffice Basic Script (Basic) for LibreOffice Calc, Airtable Script (JavaScript) for Airtable, and Python Script for Excel (openpyxl, xlwings), Google Sheets (Google Sheets API), LibreOffice Calc (UNO API), and Airtable (Airtable API).
Do I need to know VBA or JavaScript to use it?
No. Describe the task in plain English and GPTExcel writes the full script with notes on how to set it up. If you want to understand a script, paste it into Explain mode for a walkthrough of each part.
Can it improve a macro I already have?
Yes. Paste the script into Optimize mode and GPTExcel refactors it for speed, safety, and readability, and describes what changed.
Is the script generator free?
Yes, you can start free. The free plan includes 4 tool runs every 12 hours, shared across the Formula, Script, SQL, Regex, and Template tools, and paid plans raise that limit. You need a free GPTExcel account to use it.
GuideAutomating spreadsheets with AI: a guide to the script generator

Try the Scripts tool free

No credit card required. The free plan includes 4 tool runs every 12 hours.

Sign in and start generating