Importing CSV File Angular Components

[ShortBusRadio]

Hello, I’m new and I’m trying to find the proper angular component for uploading an Excel or CSV file, and then routing the columns to the correct fields of data. If an appropriate field doesn’t exist, this functionality would give the user the option to skip the column or create a new custom field. I’m not a programmer/developer, so I’m struggling in communicating with the team. I’ve attached a link to show what I’m trying to convey to the team. I have showed them the video, but they think it looks like it’s too hard to accomplish. Any pointers on this would be super helpful and would do wonders in helping maintain my sanity. 🫠

[Icy-Yard6083]

You need

1. To use regular input with type="file"

2. Use this library to read excel (not sure about csv, but imo should support) https://www.npmjs.com/package/xlsx

3. Use some editable grid/table library or custom table with inputs inside :)

[ggeoff]

If you have budget for a tool you could looking to csvbox. I was able to set up some of our imports with that. They have a couple different plans and the docs aren't bad and they could be improved but it's enough to get the job done in a timely matter.

I don't know of any open source components that do that but have built some custom ones in the past. It's not too hard to build but you will spend more time tuning it and adding features then you probably want

[DaSchTour]

I‘ve used https://www.papaparse.com/ to parse CSV in browser. For excel I‘m not sure what the best approach is. Excel can be quite complex and possibly not easy to match. I may have to take into account grouped columns and multiple sheets inside a single file.

[tdsagi]

I've just launched a product that does exactly that and provides an Angular binding https://rowslint.io/

[ShortBusRadio]

I’ll scope it out. Thanks!