Excel Tools: Complete Spreadsheet Automation
Lotics includes a 19-tool Excel suite that handles every aspect of spreadsheet work: creating workbooks, reading and writing cells, formatting, structuring, searching, and exporting. Instead of switching between Lotics and Excel, your workflows generate, transform, and distribute spreadsheets automatically. Upload a template once, map it to your data, and produce hundreds of filled reports without touching a spreadsheet application.
Overview: 19 Tools for Every Excel Operation
The Excel tool suite covers the full lifecycle of spreadsheet work. You can create new workbooks from scratch, read individual cells or entire ranges, write data to specific locations, apply formatting (fonts, colors, borders, number formats), manipulate structure (insert rows, delete columns, merge cells, add named tables), search across sheets, and export finished workbooks as .xlsx files. Every tool is available to the AI assistant and to automated workflows.
These tools run server-side, so they work on workbooks of any size without browser memory limitations. A workflow can read a 50,000-row spreadsheet, extract specific ranges, cross-reference values against your database, and write results back, all in a single automation step. The AI assistant can also use these tools conversationally: "Read the totals from row 150 of the uploaded file" or "Create a new sheet with a pivot summary."
Because the tools operate on standard .xlsx format, the output is compatible with Microsoft Excel, Google Sheets, LibreOffice, and any other spreadsheet application. There is no vendor lock-in. Files generated by Lotics are standard Excel files.
| Category | Tools | What They Do |
|---|---|---|
| Create / Read / Write | create_workbook, read_cell, read_range, write_cell, write_range | Create new workbooks, read individual cells or rectangular ranges, write single values or arrays of data |
| Format | format_cells, conditional_format, merge_cells, set_column_width, set_row_height | Apply font, color, border, number format; add conditional highlighting rules; merge cell ranges; adjust dimensions |
| Structure | insert_rows, insert_columns, delete_rows, delete_columns, add_table, add_sheet | Add or remove rows and columns, create named Excel tables with headers, add new worksheets |
| Search | find_value, find_replace | Locate cells matching a value or pattern across all sheets; find and replace in bulk |
| Export | export_workbook, export_to_pdf | Generate downloadable .xlsx files; convert sheets to PDF for distribution |
Excel Template Generation
The most powerful Excel capability is template-based document generation. Upload a .xlsx template with placeholder markers in cells (e.g., {{company_name}}, {{invoice_date}}, {{total_amount}}), and Lotics maps those markers to record fields. When the workflow runs, it fills every placeholder with live data and produces a completed spreadsheet. This works for invoices, purchase orders, packing lists, customs declarations, or any document your business produces repeatedly.
Templates support array expansion for line items. Mark a row as a repeating section, and Lotics duplicates it for each item in a linked table. An invoice template with a single line-item row automatically expands to 5, 50, or 500 rows depending on the order. Formulas in the template (subtotals, tax calculations, grand totals) adjust automatically as rows expand, so the generated file is calculation-ready.
Template generation preserves all formatting from the original file: merged cells, conditional formatting, print areas, page breaks, headers and footers. The output looks identical to a hand-crafted spreadsheet, but it is generated in seconds from live data.
Workflow Integration
Excel tools integrate directly into Lotics workflows, enabling fully automated spreadsheet pipelines. A workflow can trigger on a schedule ("every Monday at 7 AM"), from a button press in an app, from an incoming email, or from a record change. The workflow reads data from your tables, generates an Excel report using a template, and distributes it by email, by saving to a record's file field, or by posting to a webhook.
Multi-step workflows chain Excel operations together. A monthly billing workflow might: query all completed orders for the month, group them by client, generate a separate invoice spreadsheet for each client using a template, convert each to PDF, attach them to the corresponding client records, and send personalized emails with the invoices attached. This entire pipeline runs unattended.
Because workflows log every step, you have a complete audit trail. You can see exactly which data went into each generated file, when it was created, and who (or what trigger) initiated it. If a number looks wrong in a report, you trace it back to the source record in seconds.
Real Use Cases
Financial reporting: operations teams generate weekly P&L summaries by pulling revenue and cost data from multiple tables into a formatted Excel template. The report includes pivot summaries by department, trend charts, and variance analysis, produced automatically every Friday afternoon and emailed to the finance team.
Customs and compliance: logistics companies produce customs declaration forms (manifests, packing lists, certificates of origin) as Excel files that match government-mandated formats. Templates are configured once with the exact layout, cell positions, and formatting required by customs authorities. Each shipment generates a complete, print-ready document set.
Inventory management: warehouse teams generate count sheets before physical inventory. The workflow pulls current stock levels, groups items by warehouse zone, and produces a formatted spreadsheet with columns for expected quantity, actual quantity, and variance. After counting, staff upload the completed sheet and a workflow imports the actual counts back into the database, flagging discrepancies automatically.
Import from Excel
Importing data into Lotics from Excel is a first-class operation. Upload a .xlsx or .csv file, and the AI analyzes the contents: it detects column headers, infers field types (text, number, date, email, URL, currency), identifies potential link relationships between sheets, and proposes a table structure. You review the proposed schema, adjust if needed, and confirm. Lotics creates the table with properly typed fields and imports all rows.
The import handles real-world spreadsheet messiness. Merged header cells, multi-row headers, blank rows used as separators, mixed data types in a single column. The AI parses through these common patterns and extracts clean, structured data. If a column contains mostly numbers but has a few text entries like "N/A" or "-", the AI flags these for review rather than silently dropping them.
For recurring imports (e.g., a supplier sends a price list every month), you can save the import mapping. The next time you upload a file with the same structure, Lotics applies the saved mapping automatically, matching columns to fields, applying transformations, and importing in seconds.
Why Not Just Use Excel?
Manual Excel work breaks down at scale. Copy-pasting data between systems introduces errors: a misaligned paste, a forgotten filter, a formula pointing at the wrong range. When reports are built manually, they reflect the data at the moment someone built them. By the time the report reaches a decision-maker, the underlying data may have changed. Lotics-generated reports always use current data because they query the database at generation time.
Collaboration on Excel files means emailing versions back and forth or dealing with SharePoint conflicts. In Lotics, everyone works on the same live data. Reports are generated on demand or on schedule, always from the single source of truth. There is no "which version is the latest?" problem.
Tracking changes in Excel requires discipline that teams rarely maintain. In Lotics, every record change is logged with who changed it, when, and what the previous value was. Generated reports link back to source records. If an auditor asks "where did this number come from?", the answer is one click away, not buried in a folder of spreadsheet versions.
| Manual Excel | Lotics Excel Tools | |
|---|---|---|
| Data freshness | Snapshot at time of creation | Live data at generation time |
| Error risk | Copy-paste mistakes, broken formulas | Automated, consistent every time |
| Distribution | Email attachments, version confusion | Auto-emailed, saved to records, always current |
| Audit trail | Manual tracking, often missing | Full log: source data, generation time, trigger |
| Scalability | One report at a time, manual effort | Hundreds of reports generated in parallel |
| Template updates | Update every copy manually | Update template once, all future reports use it |