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.

8 guides

Spreadsheet to dashboardTurn any Excel or CSV file into a dashboard

Upload a spreadsheet and get KPIs, charts, filters and a breakdown table 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

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.

Try CTRON Loop free No account, no card, no API key.