Guides

The work you repeat, done once and ready for next time.

Pick the job in front of you. Each guide shows exactly how to do it in CTRON Loop, with a real example you can open straight away.

Photo by Kari Shea on Unsplash

11 guides

Spreadsheet to dashboardTurn any Excel or CSV file into a dashboard in under two minutes

Upload a spreadsheet and get KPIs, charts, filters and a breakdown table in under two minutes, not hours, calculated from your own rows. Try it on a sample now with no account.

Read the guide
Recurring reportsAutomate the report you rebuild every month

Build a weekly or monthly report from Excel, CSV or Google Sheets once, save it as a Loop, then rerun it on new data or on a schedule that emails the result.

Read the guide
Lookups across sheetsMatch data between two spreadsheets without VLOOKUP

Look values up against a list on another sheet with matching that forgives spelling, word order and hidden characters. Export a clean .xlsx with a Not found sheet.

Read the guide
Spreadsheet preparationClean and reshape messy spreadsheet data in plain English

Pivot and unpivot, combine date and time columns, add running totals and rankings, split data into a sheet per category and export a clean .xlsx. No formulas to write.

Read the guide
Google SheetsBuild a dashboard from Google Sheets that stays current

Connect a Google Sheet, build a dashboard from it and re-sync whenever the sheet changes. On Pro, schedule it daily or weekly and get the refreshed result by email.

Read the guide
Board and client reportsCreate a board report from a spreadsheet

Turn a spreadsheet into a board or client report with an executive summary, key figures, variance, trends, risks and actions. Download as PDF, Word, PowerPoint or Markdown.

Read the guide
Contract reviewPull obligations, risks and deadlines out of a contract

Upload a contract, agreement or policy and get an obligations register: who must do what, by when, plus the risks and penalties worth a closer look. Try it free.

Read the guide
Document summariesSummarise long business documents and pull out the actions

Summarise a long PDF, Word or text document in plain English and turn it into actions with owners and due dates. Try it on a sample with no account.

Read the guide
Power BI-style dashboardsBuild a Power BI-style dashboard from Excel, without DAX

Year-over-year comparisons, running totals, rates, rankings and slicers from an Excel or CSV file, described in plain English. No DAX, no data model, nothing to install.

Read the guide
AI spreadsheet analysisAnalyse a spreadsheet with AI, and trust every number

Ask questions of an Excel or CSV file in plain English. Every figure is calculated from your rows and explained in plain words. Try it on a sample with no account.

Read the guide
AI report generatorAn AI report generator that writes from your own files

Turn spreadsheets, PDFs and notes into operations reports, briefing notes, weekly updates and board reports, grounded in your own files. Try it on a sample with no account.

Read the guide

Do it once. Run it again in one click.

Bring the file behind your next recurring task and see a real result in the next few minutes.

Build a dashboard from my file No account, no card, no API key.