# CSV Upload Front End Field Mapping

**URL:** <https://forum.bubble.io/t/csv-upload-front-end-field-mapping/272339>\
**Category:** Idea\
**Created:** [July 13, 2023, 5:29pm UTC](https://forum.bubble.io/t/csv-upload-front-end-field-mapping/272339 "2023-07-13T17:29:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![rosejrr](https://avatars.discourse-cdn.com/v4/letter/r/dc4da7/32.png) [@rosejrr](https://forum.bubble.io/u/rosejrr)\
**Post date:** [July 13, 2023, 5:29pm UTC](https://forum.bubble.io/t/csv-upload-front-end-field-mapping/272339/1 "2023-07-13T17:29:02Z")

</div>

I’d like to be able to have a user upload a CSV file directly to database. I know such an option exists with CSV Uploadeder but I would like to have the user be able to map fields similar to how I can from the backend when I do an upload.

Through the searching I’ve done, it doesn’t seem I can access the field names/types from the front end to allow this mapping. I was thinking I could create a temp dataset that has the user upload to and then allow user to map field from temp dataset to real dataset and with an API copy those items over.

---

<div class="post-metadata">

**Author:** ![yurii](https://avatars.discourse-cdn.com/v4/letter/y/cdc98d/32.png) [@yurii](https://forum.bubble.io/u/yurii)\
**Post date:** [December 5, 2023, 2:40pm UTC](https://forum.bubble.io/t/csv-upload-front-end-field-mapping/272339/3 "2023-12-05T14:40:05Z")

</div>

Sorry for bumping an old thread, didn’t want to create a new one with a simple question (hopefully).

I currently use 1T - CSV Uploader plugin. I know it clearly states that the values I put in “Field Names” should match the ones I have in the database.  
 ![Screenshot 2023-12-05 161711](https://us1.discourse-cdn.com/bubble/original/3X/1/e/1e85c3971e1ffec43fce74fdac56b44070240999.png)

Now, let’s say a user uploads a csv file with column headers that don’t exactly match the ones I have in the db and correspondingly in Field Names (i.e. a user has ‘Surname’ column header instead of a ‘Last Name’).

The question is: is there any way (using this plugin or any other) it can still automatically map the ‘Surname’ column to the ‘Last Name’ field in the database?

Thanks a lot!

---

<div class="post-metadata">

**Author:** ![Buddha](https://avatars.discourse-cdn.com/v4/letter/b/a9a28c/32.png) [@Buddha](https://forum.bubble.io/u/Buddha)\
**Post date:** [December 24, 2023, 6:46am UTC](https://forum.bubble.io/t/csv-upload-front-end-field-mapping/272339/4 "2023-12-24T06:46:49Z")

</div>

@yurii  
They get the option to map the fields themselves. That’s what the dropdown that appears (after CSV upload) beside each field is for.

---

<div class="post-metadata">

**Author:** ![j2pp](https://avatars.discourse-cdn.com/v4/letter/j/e36b37/32.png) [@j2pp](https://forum.bubble.io/u/j2pp)\
**Post date:** [June 9, 2024, 9:40am UTC](https://forum.bubble.io/t/csv-upload-front-end-field-mapping/272339/5 "2024-06-09T09:40:28Z")

</div>

Hello, hope you don’t mind me asking this question since its somewhat related but is it possible to hide all the dropdowns and just have the UPLOAD button visible? I have no problem with the file being uploaded in terms of their formatting and labels. I just want to be able to skip directly to UPLOAD button. Is this possible? TIA
