---
title: How to connect Excel to an ERP without a marketplace connector
description: When Power Query is enough, when Omie, Bling and the store
  spreadsheet need a bridge, and what a 30-day pilot covers.
language: en-US
canonical: https://www.siglata.com/en-US/blog/integrar-excel-com-erp
date: 2026-09-23
---

# 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

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

1. **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.
2. **Connect the sources** — Engineers connect the ERP, the spreadsheets, and the files for the agreed process.
3. **Test with real data** — The team uses the result in daily work and says what needs to change.
4. **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.

### Before

| Tab | SKU | Qty | Note |
| --- | --- | --- | --- |
| Giro | CAM-104 | 12 | Check the Giro tab |

### After

| Tab | SKU | Qty | Note |
| --- | --- | --- | --- |
| export | CAM-104 | 12 | Aligned with the Omie export |

## A bridge without a marketplace connector

Illustrative chrome. Sources listed: Omie export and the store spreadsheet.

### Omie export

Omie export

- Sources: Omie

| SKU | Qty |
| --- | --- |
| CAM-104 | 12 |

### Store spreadsheet

Source bridge

- 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.

- [What Siglata is and what we believe](/en-US/blog/o-que-e-a-siglata)

- [How to automate stock replenishment across ERP and spreadsheets](/en-US/blog/como-automatizar-reposicao-estoque)

- [What a 30-day spreadsheet automation pilot is](/en-US/blog/piloto-30-dias-automacao-planilhas)