import from excel

Is it possible to import via excel into aras. If yes, How?
  • Hi, Not sure if this is for initial import or for regular data manipulation in an excel file. For data import, subscribers benefit from the Batch_Import tool which will take a csv as an input and will help you do the mapping and the import of the Data. If non subscriber, we suggest you build AML from your csv. You can do that either directly with code or I would suggest you look for an ETL which can read excel (most of them) and can produce XML. If you are more looking for data manipulation, like exporting to Excel, manipulating data in the spreadsheet and importing back to Aras, then it is preferable to build a specific add-on to Excel in which you can consume the IOM (the Aras API) to build a nice dedicated tool within Excel to push data to Aras.