Import csv without edge collection file?

[Ayrton Ciancimino]

Is there any possible way to import data with only a singular csv? From what I have found the typical means of import with arangoimp has you import the nodes as separate document csv and a to/from edge csv.

For context, imagine I have the below dummy data in a csv. Student, Major, and Class are labels for nodes each with respective name properties of the below data. Graduation date is a property of the student node as well. A given student node has relationships with the major node and the class nodes. Bonus if you can figure out how it could handle variable number of "class" columns.

Student| Graduation    |  Major  |Class | Class2 | Class3 | Class4 | Class5 | ...
Jack   |   2021        | IT      |Math  | Science| History| Coding |
John   |   2023        | Finance |Math  | Science| History| English| Spanish|
Jake   |   2020        | Finance |French| English| Spanish|        |        |

Is there any way that this can all be imported efficiently into arangodb. I know I can obviously perform data transfomation to get it into the proper format, but is that takes time and sometimes I want quick imports for testing purposes.

Taboo to mention them here maybe, but in Neo4j I was able to get an import cypher query written up real easy to handle this, where I can map out the values and it even handles repeat nodes. I am looking to maybe switch from neo to arango but this issue is kinda bugging me.

[noel del rosario]

We can import Database File in MS-EXCEL in our ARANGODB using its tool 'arangoimport'.
arangoimport --file DIR-path\airports.csv --collection airports --create-collection true --type csv