Import 300+ application profiles from Excel to EA

[EA_enthusiast]

Hello, EA experts,

I need your advice on the right approach to import 300+ application profiles from Excel to EA. The first few records are shown in the screenshot below.



This Excel spreadsheet is an export from another architecture tool. You will notice that the GUID is available in the first column.

Thank you so much in advance!

[Hurra]

I would script a custom csv import, using the csv's guid as some kind of external id. I would let EA create the element, thus give it a new guid. The other fields I would save either as existent standard-fields, like 'Application' would probably be name, and 'Criticality' a tagged value.

[ea0522]

For this kind of imports, I usually use the Excel tool from Geert Bellekens.
See https://bellekens.com/ea-excel-import-export/ for more information.

[EA_enthusiast]

Thank you, ea0522 and Hurra for your advice.