rigacellConnect different systems
Connect the MySQL, Firebird, SQL Server or PostgreSQL databases behind your ERP, inventory software or other business applications.
YOUR BUSINESS SYSTEMS, CLOSER
Different systems. All within reach of Excel.
Connect your databases to Excel and find the data you need without leaving your worksheet. Select a value, choose a saved lookup, and explore the results.
Free 30-day trial · Version 1.0.0.338 · what to expect
CellLens in action20 seconds · Fictional demo dataSelect a product code. CellLens shows its stock records from SQL Server.
No sound neededVideo playback is unavailable. Open the video directly
All your systems, one place to look
Configure the lookups your work depends on, then read the answer without leaving Excel.
Look up different tables
Switch between saved lookups for product details, stock, orders or other records. Each lookup uses its configured connection and table.
Get answers without leaving Excel
Read the results alongside your worksheet instead of opening another application and searching for the same code again.
Your connections, your rules
Each saved lookup uses the connection and table your administrator configured.
Switch without switching apps
Move between lookups when the answer lives in another table or system.
ONE SKU · TWO SOURCES
Stock in one system. Orders in another.
See what each saved lookup tells you about the same product.
INVENTORY · SQL SERVER
Which sizes are available, and where?
One product code can match several stock records. Here, TESSA74X returns eight combinations of colour, size and location from the inventory database.
- Available stock alongside reserved quantities
- Product origin alongside stock details
SALES · POSTGRESQL
Who ordered this product?
The same TESSA74X code returns six order lines from a separate sales database. Read the customer, order date, quantity, unit price and status beside your worksheet.
- Same SKU, a different connection and table
- Keep the worksheet open while checking orders
Real Excel recordings with fictional data. These examples use two separately configured database connections; each lookup reads its own source.
Free trial
Try CellLens for 30 days.
The full add-in for 30 days. No account, no card, and no automatic charge.
Read the free trial terms before installing.
Download for WindowsWhat you need
- Excel desktop for Windows
- .NET Framework 4.8 and the VSTO Runtime
- Close Excel before installing
The add-in installs for your Windows user. Installing missing Microsoft prerequisites may require administrator rights. Uninstall from Settings → Apps.
About the unsigned installer and Windows warnings
This release does not have an Authenticode digital signature. Your browser or Windows SmartScreen may warn that the file or publisher is unrecognised. A reputation warning is not a malware scan result, and signing a future release does not guarantee that warnings will disappear.
If your organisation manages software installation, ask your IT team to review the installer. Do not bypass a malware detection or an organisation policy to install it.
To compare your download with this published release, open PowerShell in the folder containing the installer and run:
Get-FileHash .\CellLens-Setup-1.0.0.338.exe -Algorithm SHA256It should print
41A237427EB21B57453DCED66E778E9179AFD14F76825DEB5783D79D38531C60
A matching SHA-256 confirms that the file matches this release; it does not certify that a file is safe. Read Microsoft’s explanation of SmartScreen reputation.
What happens after the trial?
After 30 days, CellLens requires a valid licence to continue using lookups. Trial expiry does not delete your database records or saved Excel workbooks.
The annual launch price is €99 per user, excluding applicable taxes. To purchase a licence, contact us by email. Online checkout is not available, and there is no automatic charge. Contact Rigacell.
In detail
Set up the connection.
Keep the answer close.
Connect a source, save a lookup, and choose how the results appear. Click any screenshot to read the actual settings.
01 / CONNECT THE SOURCES
Give each database a familiar name.
Save a connection for each source you need. In this demo, inventory lives in SQL Server and sales in PostgreSQL. Each lookup chooses which connection to use.
- Separate connections for separate systems
- Configure access with your database administrator
- Reuse a connection across several lookups
02 / DEFINE THE ANSWER
Choose which field your Excel cell searches.
In Simple mode, choose a table and click the circle under Search on beside the column to match against your selected Excel cell. Here, SKU is selected. Choose Location instead, save the lookup, then select a location name in Excel to find its stock records.
- One search field per lookup, chosen by you
- Choose the result columns and rename their headings
- Set the order of columns and sort the results
OPTIONAL / FOR YOUR DATABASE TEAM
Use an existing query when you need more control.
Advanced mode lets your database team define a query. This Customer orders example reads a PostgreSQL view and uses @value for the code selected in Excel.
- An alternative to the Simple table picker
- The selected value is passed as a query parameter
- Save the query as a named lookup
03 / FIT YOUR WORKSPACE
Keep the answer where you can see it.
Dock the panel above your worksheet to give wider tables more room, or on the right to read results beside your cells. Here, customer orders stay above the selected product code.
- Above the worksheet for wider tables
- On the right for side-by-side reading
- Adjust the panel dimensions to fit your work
Your workflow, with CellLens
Your data lives in different systems. Your work stays in Excel.
Check stock in one system, order details in another, or product information in a different table. Switch between your configured lookups while keeping your worksheet in view.
Connect your data sources
With your database administrator, configure access to the supported databases behind the business systems you use.
Save the lookups you need
Choose the connection, table, search field and result columns, then give the lookup a name that makes sense for your work. Set up once, and it is there every morning.
Find the answer in Excel
Select a cell containing a product code, order reference or another value. Choose a saved lookup and read the results in Excel. Switch lookups when you need information from another table or system.
CellLens · Guide
Get started with CellLens.
Start at the beginning or jump straight to the task you want to complete.
01
Connect & look up
Connections, tables, search fields and your first matching records.
02Make the table yours
Choose and move columns, rename headings, match values and sort results.
03Go further with SQL
Parameters, additional filters, aliases and query ordering.
Work through an example
Before you start
Made for your Windows workspace.
Install the Microsoft prerequisites if needed, then the add-in. Configure your source in Settings; your IT team may need to help with network or database access.
Your source: MySQL, Firebird, SQL Server and PostgreSQL behind your business systems.
CellLens reads through configured database connections. Your business system must use a supported database and allow access to the required tables. Confirm database compatibility and permissions with your administrator.
What you need
- Windows 10 or Windows 11
- Microsoft Excel for Windows, installed on the machine
- .NET Framework 4.8 or later — Setup offers to download and install it if missing
- Microsoft Visual Studio Tools for Office (VSTO) Runtime — required before installation; not bundled with the installer
Not supported
- Excel for Mac
- Excel for the web, and the mobile apps
- Excel through a browser-only Microsoft 365 subscription
Still being confirmed
- Development target: Microsoft 365 desktop Excel on Windows. A list of tested versions and builds has not yet been published
- Compatibility with Excel 2016, 2019, 2021 and 2024, and with 32-bit and 64-bit Office, is not yet confirmed
- Behaviour under Windows Server and shared-session installs
A trial download does not confirm compatibility with every Office build. Contact us with your Excel version and edition if you need confirmation before installing.