Power Query function · €19
SAP export cleaner
Turn a pipe-separated SAP list into a table you can reconcile.
Review build. Scoped native checks are listed under What you need. Full acceptance is incomplete. Purchases are disabled.
Will it fit your work?
- Your input
- Unconverted SAP text with pipe separators. Match encoding, decimal notation and date format to your export.
- Your result
- A typed table without repeated headers and recognised totals. Identifier columns retain leading zeros.
- What you need
- Excel for Windows with Power Query, or Power BI Desktop. No SAP login needed for a saved file. The bundled FBL3N, KSB1 and FBL5N samples, totals, notes and number formats passed natively in Power BI Desktop (17 Oct 2026) and Excel Power Query (19 Oct 2026), 19 scenarios each. Not yet run on exports from other SAP systems.
- Check this first
- Not a reader for arbitrary PDFs, spreadsheets or every SAP layout. Total markers default to the first column; configure TotalColumns for another layout.
Start with one known example
- Extract the whole ZIP and read START_HERE.md.
- Start with
SAP_CleanList.pqon a copy. - Use the example below; replace input paths and settings.
- Reconcile rows and totals before using real data.
SAP_CleanList(File.Contents("C:\Kit\FBL3N_sample.txt"))Each package includes the source file or workbook, its PDF guide, a short setup path, verification status and a support checklist.
Free builds are for evaluation; validate the result in your own environment. Price shown for a paid tool is the proposed one-time price, before any applicable checkout taxes.
Data stays in your own files except for configured service calls. VIES receives VAT numbers; currency services receive requested dates and currency codes. No tracking or signup is used by this static preview.