onedevatlasBeta
Browse the atlas
AllUI5CAPABAPBTP
PackagePackagetypeA library you install and call yourself.See every one →What this type is →by a community orgby a community orgoriginPublished by a community organisation, so it outlives any one maintainer.See every one →

ui5-cc-spreadsheetimporter

A UI5 component that adds a spreadsheet upload dialog to a Fiori elements or freestyle app and submits the rows it reads through the app's own OData model.

Declared in manifest.json as a component usage against a version-pinned name such as cc.spreadsheetimporter.v2_4_0, it opens an upload dialog in a running UI5 app, reads the file in the browser and submits the extracted rows through the model the app already has. The file itself is never sent, which is what its documentation rests the claim on that the component works independent of the backend, OData version and Fiori scenario. That is also where it stops: the rows arrive at the service as ordinary OData requests, so the service's own checks decide what is written, and nothing parses a file on a server. For server-side parsing instead, cds-spreadsheetimporter-plugin takes the file in CAP and the ABAP Spreadsheet Importer takes it in RAP. Version 1.x is Apache-2.0 and is kept in the ui5-cc-spreadsheetimporter-community repository; 2.0.0 and above are published under the SpreadsheetImporter Commercial License, free for non-production use and paid for production or resale.

GitHub103 ★
npm175/wk
Docs
Homepage
Issues

Facts

Latestv2.4.0ReleasedLast pushLicenceSee LICENSE.md

Where it sits

Lives in
UI5
Provides
Importing and exporting table dataUI5Importing and exporting table datacapabilityGetting a file somebody supplies, a spreadsheet, a CSV or a JSON dump, into tables with its columns mapped and its values checked, and getting table content back out as a file. Data shipped with an application for development and demonstration is [seed data](capability:seed-data).
Flavors
Fiori elementsFreestyle

Who is behind it

Marian ZeisMarian ZeisPersonMaintains this
In the atlas: maintains 35, contributes to 86, wrote 25@marianfooSpreadsheet ImporterSpreadsheet ImporterOrganisationMaintains this
In the atlas: maintains 9@spreadsheetimportermaintainersWouter LemairePersonContributes to this
In the atlas: maintains 25, contributes to 39, wrote 12@lemaiwoM̷̱̥̳͔̖̠̙͈̫͕͔̳͉̱̣̭̮̠̰̄͊̒̈͛͗̈̇͆͗͆͋̾̋̅ͅͅẠ̴̡̬̭͓̟̠̣̤̓̽͛̋̌̆̆̔́̊̋́͜Ŕ̶͈̹̯̹͈̠̮̰̓̈́̐̊͐̕̕͝C̷̨̡̖̱̭͉̞̗̳͈̩͚̏͛̓̃͂͌̀̆͊̅̃̒̄͐̿̽̚͝PersonContributes to this
In the atlas: contributes to 2@MARCxGAMBITMarco BeierPersonContributes to this
In the atlas: contributes to 13@wridgeuXexerPersonContributes to this
In the atlas: maintains 7, contributes to 8@Xexer4 contributors

What it declares

Every artifact

Type
Package
Origin
By a community org

As a package

Where it runs
Inside its host
Distributed through
npm

Connections4

Download
ui5-cc-spreadsheetimporter connectionsui5-cc-spreadsheetimporterPROVIDES→ provides1provides stated The import side in the browser: a dialog reads an uploaded spreadsheet and submits its rows through the app's existing OData model, so no file reaches the server and the service's own checks apply row by row. Spreadsheet Importer documentation — UI5 Custom Control Spreadsheet Upload: https://docs.spreadsheet-importer.com/ spreadsheetimporter/ui5-cc-spreadsheetimporter — README: https://github.com/spreadsheetimporter/ui5-cc-spreadsheetimporterImporting and exporting table dataUSED BY← needed by3needed by derived The Spreadsheet Upload button in the risks list report opens the component's dialog: the app lists the component under its dependencies and an extension controller creates the usage before calling openSpreadsheetUploadDialog. Through: inverted from its requires edge spreadsheetimporter/sample-full-btp — app/risks/webapp/manifest.json: https://raw.githubusercontent.com/spreadsheetimporter/sample-full-btp/main/app/risks/webapp/manifest.json spreadsheetimporter/sample-full-btp — app/risks/package.json: https://raw.githubusercontent.com/spreadsheetimporter/sample-full-btp/main/app/risks/package.jsonspreadsheetimporter/sample-full-btpneeded by derived The dialog the Excel Upload button opens is the component's own: the app declares it as the component usage spreadsheetImporter and its Main controller creates that usage before calling openSpreadsheetUploadDialog. Through: inverted from its requires edge spreadsheetimporter/sample-odata-api-upload — webapp/manifest.json: https://raw.githubusercontent.com/spreadsheetimporter/sample-odata-api-upload/main/webapp/manifest.json spreadsheetimporter/sample-odata-api-upload — package.json: https://raw.githubusercontent.com/spreadsheetimporter/sample-odata-api-upload/main/package.jsonspreadsheetimporter/sample-odata-api-uploadneeded by derived The manifest it rewrites is the Spreadsheet Importer's own, so without that component in the build there is no sap.cloud name to change. Through: inverted from its requires edge spreadsheetimporter/ui5-task-btp-manifest — README: https://github.com/spreadsheetimporter/ui5-task-btp-manifestui5-task-btp-manifest

Install

npm add ui5-cc-spreadsheetimporter

Derived from the package name. No recipe recorded; the README has the configuration.

README

quoted from spreadsheetimporter/ui5-cc-spreadsheetimporter, read
spreadsheetimporter/ui5-cc-spreadsheetimporter/packages/ui5-cc-spreadsheetimporter/README.mdOn GitHub

UI5 custom control ui5-cc-spreadsheetimporter

UI5 Spreadsheet Importer Logo

A UI5 Module to integrate a Spreadsheet Upload for Fiori Element Apps.
This control simply enables the mass upload of data, independent of the backend, OData version and Fiori scenario.
This is made possible by reading the Spreadsheet file and using the standard APIs.
The control will submit not the file, but just the data from the Spreadsheet File.
The integration of the control is designed to be as simple as possible and, in the best case, requires no configuration.

The aim is to support as many Fiori Scenarios and UI5 Versions as possible.
See here for all currently supported Versions.

Spreadsheet Upload Dialog

excerpt, See LICENSE.md, read the rest, on GitHub

History

Latest

v2.3.0

Features 1, Fixes 2

  1. v2.4.0

    Features 1, Fixes 2

  2. v2.2.0

    Features 3, Fixes 1

  3. v2.1.0

    Features 3, Fixes 4

  4. v2.0.0

    Breaking 1, Other 1

  5. v1.7.3

    Fixes 2

  6. v1.7.2

    Fixes 1

  7. v1.7.1

    Fixes 1

  8. v1.7.0

    Features 3, Fixes 1

  9. v1.6.0

    Features 1, Fixes 1

  10. v1.5.2

    Fixes 1

  11. v1.5.1

    Fixes 2

  12. v1.5.0

    Features 2, Fixes 2

  13. v1.4.3

    Fixes 1

  14. v1.4.2

    Fixes 1

  15. v1.4.1

    Fixes 1

  16. v1.4.0

    Features 1

  17. v1.3.0

    Features 1, Fixes 1

  18. v1.2.2

    Fixes 1

  19. v1.2.1

    Fixes 1

  20. v1.2.0

    Features 1, Fixes 2

  21. v1.1.1

    Fixes 1

  22. v1.1.0

    Features 2

  23. v1.0.0

    Breaking 1, Features 2, Fixes 1

  24. v0.34.1

    Fixes 1

  25. v0.34.0dated in the atlas

    Breaking 1, Features

  26. v0.33.4

    Fixes 1

  27. v0.33.3

    Fixes 3

  28. v0.33.2

    Fixes 2

  29. v0.33.1

    Fixes 1

  30. v0.33.0

    Features 1

  31. v0.32.0

    Features 1

  32. v0.31.6

    Fixes 1

  33. v0.31.5

    Fixes 1

  34. v0.31.4

    Fixes 1

  35. v0.31.3

    Fixes 1

  36. v0.31.2

    Fixes 1

  37. v0.31.1

    Fixes 1

  38. v0.31.0

    Features 4, Fixes 1

  39. v0.30.0

    Features 4

  40. v0.29.1

    Fixes 5

  41. v0.29.0

    Features 2, Fixes 2

  42. v0.28.1

    Fixes 2

  43. v0.28.0

    Features 1

  44. v0.27.1

    Fixes 1

  45. v0.27.0

    Features 2, Fixes 1

  46. v0.26.1

    Fixes 1

  47. v0.26.0

    Breaking 1, Features 1

  48. v0.25.4

    Fixes 1

  49. v0.25.3

    Fixes 2

  50. v0.25.2

    Fixes 1

  51. v0.25.1

    Fixes 1

  52. v0.25.0

    Features 1, Fixes 2

  53. v0.24.0

    Features 1

  54. v0.23.1

    Fixes 1

  55. v0.23.0

    Features 3, Fixes 1

  56. v0.22.0

    Features 2, Fixes 1

  57. v0.21.2

    Fixes 1

  58. v0.21.1

    Fixes 1

  59. v0.21.0dated in the atlas

    Breaking 1, Features 1

  60. v0.20.0

    Features 3

  61. v0.19.1

    Fixes 1

  62. v0.19.0

    Features 1

  63. v0.18.1

    Fixes 1

  64. v0.18.0

    Features 2, Fixes 4

  65. v0.17.5

    Fixes 2

  66. v0.17.4

    Fixes 1

  67. v0.17.3

    Fixes 1

  68. v0.17.2

    Fixes 2

  69. v0.17.1

    Fixes 2

  70. v0.17.0

    Breaking 1, Features 6

  71. v0.16.4

    Fixes 1

  72. v0.16.3

    Fixes 1

  73. v0.16.2

    Fixes 1

  74. v0.16.1

    Fixes 1

  75. v0.16.0

    Features 3, Fixes 2

  76. v0.15.0dated in the atlas

    Breaking 1, Features 2

  77. v0.14.1

    Fixes 2

  78. v0.14.0

    Features 2

  79. v0.13.0

    Features 2

  80. v0.12.3

    Fixes 1

  81. v0.12.2

    Fixes 1

  82. v0.12.1

    Fixes 1

  83. v0.12.0

    Features 4

  84. v0.11.4

    Fixes 1

  85. v0.11.3

    Fixes 1

  86. v0.11.2

    Fixes 1

  87. v0.11.1

    Fixes 1

  88. v0.11.0

    Features 1

  89. v0.10.0

    Breaking 1

  90. v0.9.1

    Fixes 1

  91. v0.9.0

    Features 2, Fixes 2

  92. v0.8.1

    Fixes 1

  93. v0.8.0

    Features 1

  94. v0.7.0

    Features 1, Fixes 3

  95. v0.6.0

    Features 4, Fixes 1

  96. v0.5.0

    Features 4

  97. v0.4.0

    Features 1

  98. v0.3.4

    Features 1, Fixes 2

  99. v0.3.3

    Features 1, Fixes 1

  100. v0.3.2

    Features 1

  101. v0.3.1

    Fixes 1

  102. v0.3.0dated in the atlas

    Breaking 1

  103. v0.2.2

    Fixes 1

  104. v0.2.1

    Fixes 1

  105. v0.2.0

    Features 2

  106. v0.1.2

  107. v0.1.1

  108. v0.1.0

On GitHub
188downloads per week, npm
Weekly downloads for ui5-cc-spreadsheetimporter26 complete calendar weeks from 2026-04-20 to 2026-10-18; the latest total is 188.20 Apr – 26 Apr: 85827 Apr – 3 May: 4424 May – 10 May: 52911 May – 17 May: 59618 May – 24 May: 66225 May – 31 May: 1,0431 Jun – 7 Jun: 5038 Jun – 14 Jun: 55115 Jun – 21 Jun: 73922 Jun – 28 Jun: 81329 Jun – 5 Jul: 6536 Jul – 12 Jul: 75313 Jul – 19 Jul: 53120 Jul – 26 Jul: 46427 Jul – 2 Aug: 3583 Aug – 9 Aug: 75110 Aug – 16 Aug: 43717 Aug – 23 Aug: 64124 Aug – 30 Aug: 69631 Aug – 6 Sept: 6707 Sept – 13 Sept: 55414 Sept – 20 Sept: 52121 Sept – 27 Sept: 60228 Sept – 4 Oct: 7395 Oct – 11 Oct: 52812 Oct – 18 Oct: 188

Others providing8

Compare all 9 on the Importing and exporting table data page →
Importing and exporting table data
  1. abap2UI5 for ExcelOffice add-in running an abap2UI5 app in Excel's task panefrom ABAP
  2. abap2UI5-addons/table-content-loaderUpload, edit and download ABAP table content as JSON, CSV or XLSXfrom ABAP
  3. boy0korea/abap2jsonExports and imports ABAP table content as zipped JSONfrom ABAP
  4. boy0korea/ABAP2XLSX_HELPERHelper methods over abap2xlsx for Excel, JSON and tablesfrom ABAP
  5. abapDataToTableImportMaps clipboard, Excel or text data onto a declared ABAP structurefrom ABAP
  6. mkysoft/xlsxreaderReader for Excel spreadsheets in OpenXML format from ABAPfrom ABAP
  7. ABAP Spreadsheet ImporterABAP component importing XLSX or CSV files into RAP business objectsfrom ABAP
  8. cds-spreadsheetimporter-pluginSpreadsheet upload into a CDS entity, parsed on the serverfrom CAP

Details

Sources4
Added by handdiscovered here, spreadsheetimporter organisation repositorieschecked
npm registry, ui5-cc-spreadsheetimporterversion, releases, installschecked
github.com/git+https://github.com/spreadsheetimporter/ui5-cc-spreadsheetimporter.gittree, pushes, contributors, CIchecked
packages/ui5-cc-spreadsheetimporter/README.mdquoted, and what the entry declareschecked

Sources are graph entities: the same page may back several entries, and an unreachable source flags every row that rests on it.

Compatibility and provenance
latestv2.4.0
first release
releases and cadence63, ~6d median
discovered viaAdded by hand · spreadsheetimporter organisation repositories
first seen in the atlas
ecosystem and domainui5, data-and-persistence
Flavors2
Fiori elements
“Usable across all Fiori scenarios (Fiori Elements, Freestyle, OpenUI5, V2/V4)” — Spreadsheet Importer documentation — UI5 Custom Control Spreadsheet Uploadchecked
Freestyle
“Usable across all Fiori scenarios (Fiori Elements, Freestyle, OpenUI5, V2/V4)” — Spreadsheet Importer documentation — UI5 Custom Control Spreadsheet Uploadchecked
Contributors4
Wouter LemaireM̷̱̥̳͔̖̠̙͈̫͕͔̳͉̱̣̭̮̠̰̄͊̒̈͛͗̈̇͆͗͆͋̾̋̅ͅͅẠ̴̡̬̭͓̟̠̣̤̓̽͛̋̌̆̆̔́̊̋́͜Ŕ̶͈̹̯̹͈̠̮̰̓̈́̐̊͐̕̕͝C̷̨̡̖̱̭͉̞̗̳͈̩͚̏͛̓̃͂͌̀̆͊̅̃̒̄͐̿̽̚͝Marco BeierXexer

From the repository’s contributor list, .

History in the atlas1
  1. First seen.
For your agent
Ref
artifact:spreadsheetimporter-ui5-cc-spreadsheetimporter
JSON
/artifacts/spreadsheetimporter-ui5-cc-spreadsheetimporter.json
MCP
Connecting an agent