How to connect Excel to an ERP without a marketplace connector
Power Query handles a simple export. Work across systems needs another bridge.
Siglata team
Sep 23, 2026 · 6 min read
Connecting Excel to an ERP works when the export is stable and someone in-house maintains Power Query. When the routine mixes Omie, Bling, a store spreadsheet, and rules that change, a generic connector does not finish the process.
Siglata connects the company's systems and automates spreadsheet work with the team. The pilot lasts 30 days and is quoted per process. We do not sell an ERP replacement, and we do not promise to drop spreadsheets.
When doing it yourself is enough
Periodic exports, few tabs, fixed rules, and someone in-house maintains Power Query. In that slice, pulling ERP tables into Excel is usually the shortest path.
When doing it yourself stalls
Files in different formats, checks with exceptions, no native integration between two ERPs and the spreadsheet purchasing still uses. Omie and Bling appear only as systems the company already has, not as partners or ready-made connectors.
The pilot path
Listen to the people who run the spreadsheet
The real routine, the exceptions, and the expected result come from the people who already do the work.
Connect the sources
Engineers connect the ERP, the spreadsheets, and the files for the agreed process.
Test with real data
The team uses the result in daily work and says what needs to change.
Decide what runs on its own
What needs review stays with the team. The order and the authorization stay in the current flow.
A flat export and the operations workbook
Illustrative grid. Switch Before and After to see the operations tab become a flat table.
| A | B | C | D | |
|---|---|---|---|---|
| Tab | SKU | Qty | Note | |
| 1 |
| A | B | C | D | |
|---|---|---|---|---|
| Tab | SKU | Qty | Note | |
| 1 |
A bridge without a marketplace connector
Illustrative chrome. Sources listed: Omie export and the store spreadsheet.
Omie export
Example
Sources
Omie
| SKU | Qty |
|---|---|
| CAM-104 | 12 |
Source bridge
Example
Sources
Omie + store
Review
Human
| SKU | Qty | Note |
|---|---|---|
| CAM-104 | 12 | Aligned with the Omie export |
The systems stay
The ERP stays. Excel stays where it still helps. The bridge is what engineers implement with the team, without waiting for a marketplace connector. The page at /integracao-erp-planilha describes the same slice of work.
If Excel and ERP integration in your company has become a queue of spreadsheets, we want to understand one process. Write to angelica@siglata.com or WhatsApp from the integration page.
See how we work
