MS4BI & Excel: More Than Just Compatibility

With MS4BI, turn your Excel sheets into dynamic applications: SQL, Web, instant collaboration.

✔ Simple, ✔ Agile, ✔ Powerful

Search, filter, and leverage your Excel data effortlessly... and publish it instantly to the Web.

With MS4BI, just 3 lines of code turn an Excel sheet into a dynamic, SQL-queryable web page. No server, no complex import — everything runs live.

DBconnect {Ado:"xls"}("/dossier/viewInvoices.xlsx");
tabname := "[viewInvoices$]";
Ms4_Query:Web {Ado:"xls"}("SELECT * FROM %s WHERE CustomerID = 'ABC123'", tabname);

Publish an Excel Sheet in 3 Lines of Code

Quickly deploy an Excel sheet online, without server or macros. Your users access it through their browser.

Update Excel via the Web

Add web forms linked to your Excel files. All changes are saved automatically.

Publish Excel Charts

MS4BI is compatible with native Excel charts, which you can publish and customize using MS4Script.

Import Multiple Files

Combine several Excel files or sheets into a single database without heavy processing. ODBC/ADO supported.

Export to Excel, CSV, JSON

All your data can be exported in standard formats, with one click or via script.

🔍 MS4BI Excel : Web Collaboration

   Str_Format(LcurrentDirExcel1,"%s/932-dataInteractive.xlsx",LCurrentDir1 ) ;   
  BEGIN
    DBconnect{Excelweb}(LcurrentDirExcel1);
  	FormExcelWeb : DrawGrid ,title : "Interactive Sheet" ,		 
				Option : BEGIN   inlineEdit : yes END ;
  END ;

🔍 MS4BI Excel : Import

  DBconnect{Excelweb}(LcurrentDirExcel1);
IMPORT_Excel: 
option :
 BEGIN  
Input  :  File : "#DRIVERSYS+\....\1-IMPORT\example.xlsx", sheet :  "who","age",
Output :  DBconnect {Ms4DB} (NewDb)  , 
Create : Table("[mytable]") 
Sql : 
(" SELECT  who.firstname, who.name,  age.age,age.sex  " +
  " from  [who]  " +
  " INNER join  [age] ON who.name =  age.name  "  ) returning(x) 
END ;

🆚

Excel + BI: MS4BI vs Other Tools

MS4BI

✔ Direct SQL queries on Excel
✔ Web publication in 3 lines of code
✔ Collaboration and updates via Web
✔ Native Excel chart integration
✔ Multi-sheet, multi-file import
✔ Native CSV, Excel, JSON export

Power BI

✔ Excel connection possible
❌ No direct SQL query support
❌ No native Web publishing
✔ Excel chart support (import only)
❌ No Web update of source Excel
✔ Limited export (static CSV, Excel)

Tableau

✔ Excel connection via import
❌ No SQL querying on Excel
❌ No direct Web publishing of Excel
❌ No Web editing of Excel
✔ Visualization export supported
❌ No native Excel sheet integration

This comparison table highlights real-world functional differences.

💡 Why MS4BI Stands Out with Excel

✔ Run SQL queries on your Excel files as if they were full databases.
✔ Instantly publish results to the Web with just 3 lines of code, no external server needed.
✔ Enable direct updates to an Excel sheet through a dynamic web interface.
✔ Integrate your Excel charts into interactive dashboards.
✔ Merge multiple files and sheets into a consistent data base.
✔ Simplified exports: Excel, CSV, JSON — all natively supported.

🔍 And What About Other Tools?

Power BI: Excel connection available, but no SQL queries or file updates. Web publishing requires Power BI Service license.
Tableau: Can read Excel files, but without SQL or editing. Visualizations are isolated from the original Excel data.

MS4BI Excel

MS4BI Excel

Contact our team or consult our guides to better understand MS4BI.

⚡ MS4BI Philosophy: power + simplicity + speed.

MS4BI is built on a No Code / Low Code productivity-first approach.
With MS4Script, you can build dashboards, charts, queries, menus, or business apps in just a few lines — without dealing with web and server technicalities.
Whether you are a developer or a business user, you have the power to create.

What is MS4BI?