Excel stays welcome, not in charge.
Many orders and forecasts still arrive as spreadsheets, and some people want to keep working in one. Frontlink reads them in and exports what you need, so Excel is a view, not the source.
Excel and Frontlink.
Frontlink reads Excel and CSV files: customer call-off lists, forecasts, order sheets and existing planning spreadsheets. Each layout is set up once, after which files that arrive by email or upload become orders, forecasts or planning without retyping.
The other way round, every overview in Frontlink can be exported to Excel. Teams that are used to spreadsheets keep their view, while the data itself lives in one place.
- Direction
- Import and export
- Data exchanged
- Order lists, forecasts, planning sheets, stock and batch overviews
- How it connects
- Excel (.xlsx) and CSV files, by email or upload
- Access
- No system access needed
- Typical setup time
- About a day per layout
What moves between them.
- Order lists and forecasts are read
Call-off lists and forecasts from customers are read in and matched to items and existing orders.
- Your old planning sheet becomes the start
At the start we read in your current planning sheet, so nobody begins with an empty board.
- Exports for whoever still wants them
Planning, stock and batch overviews can be exported to Excel at any moment, always current.
How we connect it.
- Send us an example
One real spreadsheet per customer or process is enough to see what is in it.
- We map the columns once
Each layout is set up once. If a customer changes their sheet, Frontlink flags it instead of guessing.
- Via email or upload
Files arrive by email or are dropped in, whatever your team is used to.
Other integrations.
Where you see it in Frontlink.
- Orders and customer contactRequests arrive by email, as PDF or Excel. Frontlink calculates the quote, prepares the order in your ERP and keeps the customer informed all the way to shipment.
- PlanningA plan that knows what is really happening on the floor. Orders come from your ERP, progress comes from the line, and when something moves the warehouse, sales and the customer know straight away.
Frequently asked questions.
Can we keep planning in Excel?
You can, but you do not have to. Most teams keep an export for a few weeks and then stop opening it.
What if every customer uses a different layout?
That is normal. Every layout is set up once and recognised after that.
Does Frontlink work with Google Sheets too?
Yes, through an export to Excel or CSV. A direct link we look at per case.
Can we import our items from Excel at the start?
Yes. Items, recipes and customers can be imported from Excel if your ERP does not have them yet.
Using something else? Tell us.
In a 30-minute call we look at your systems and machines and tell you which connections make sense to start with.
Book a call