# Trying to import csv, i get totally random columns

**URL:** <https://forum.bubble.io/t/trying-to-import-csv-i-get-totally-random-columns/325483>\
**Category:** Need help\
**Created:** [June 4, 2024, 11:37pm UTC](https://forum.bubble.io/t/trying-to-import-csv-i-get-totally-random-columns/325483 "2024-06-04T23:37:01Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![maisterrenamariano](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/maisterrenamariano/32/206845_2.png) [@maisterrenamariano](https://forum.bubble.io/u/maisterrenamariano)\
**Post date:** [June 4, 2024, 11:37pm UTC](https://forum.bubble.io/t/trying-to-import-csv-i-get-totally-random-columns/325483/1 "2024-06-04T23:37:01Z")

</div>

I cant seem to understand why am i getting completely random numbers as if it were the column to import some data. I have the exact same data field in my user data type. any ideas what could be causing the problem?

thanks

 ![image](https://us1.discourse-cdn.com/bubble/original/3X/b/3/b3303529be2aeaaf0bebd98211b238e2de47eef8.png)  
 ![image](https://us1.discourse-cdn.com/bubble/original/3X/c/b/cba77f86d63aea28b40c5f40ddccaad7334a61f3.png)  
 ![image](https://us1.discourse-cdn.com/bubble/original/3X/2/1/21ad3a84c75e5486acecb399d8f0538b7676a99b.png)  
 ![image](https://us1.discourse-cdn.com/bubble/original/3X/b/3/b3303529be2aeaaf0bebd98211b238e2de47eef8.png)

---

<div class="post-metadata">

**Author:** ![yamada.shoji99](https://avatars.discourse-cdn.com/v4/letter/y/76d3ee/32.png) [@yamada.shoji99](https://forum.bubble.io/u/yamada.shoji99)\
**Post date:** [June 5, 2024, 12:08am UTC](https://forum.bubble.io/t/trying-to-import-csv-i-get-totally-random-columns/325483/2 "2024-06-05T00:08:30Z")

</div>

Because the first row is the column name, you need to rearrange your csv file structure

---

<div class="post-metadata">

**Author:** ![maisterrenamariano](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/maisterrenamariano/32/206845_2.png) [@maisterrenamariano](https://forum.bubble.io/u/maisterrenamariano)\
**Post date:** [June 5, 2024, 4:39pm UTC](https://forum.bubble.io/t/trying-to-import-csv-i-get-totally-random-columns/325483/3 "2024-06-05T16:39:41Z")

</div>

how would it need to be if rearrenged

---

<div class="post-metadata">

**Author:** ![code-escapee](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/code-escapee/32/195485_2.png) [@code-escapee](https://forum.bubble.io/u/code-escapee)\
**Post date:** [June 5, 2024, 4:42pm UTC](https://forum.bubble.io/t/trying-to-import-csv-i-get-totally-random-columns/325483/4 "2024-06-05T16:42:55Z")

</div>

“transpose” to columns

---

<div class="post-metadata">

**Author:** ![maisterrenamariano](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/maisterrenamariano/32/206845_2.png) [@maisterrenamariano](https://forum.bubble.io/u/maisterrenamariano)\
**Post date:** [June 5, 2024, 5:10pm UTC](https://forum.bubble.io/t/trying-to-import-csv-i-get-totally-random-columns/325483/5 "2024-06-05T17:10:10Z")

</div>

what is transpose? you mean i delete the columns that do not match?

---

<div class="post-metadata">

**Author:** ![code-escapee](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/code-escapee/32/195485_2.png) [@code-escapee](https://forum.bubble.io/u/code-escapee)\
**Post date:** [June 5, 2024, 5:47pm UTC](https://forum.bubble.io/t/trying-to-import-csv-i-get-totally-random-columns/325483/6 "2024-06-05T17:47:05Z")

</div>

no. your first column has to be your first row and your second column your second row and so on. Google how to do transpose in Sheets or csv.

---

<div class="post-metadata">

**Author:** ![maisterrenamariano](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/maisterrenamariano/32/206845_2.png) [@maisterrenamariano](https://forum.bubble.io/u/maisterrenamariano)\
**Post date:** [June 6, 2024, 4:13pm UTC](https://forum.bubble.io/t/trying-to-import-csv-i-get-totally-random-columns/325483/7 "2024-06-06T16:13:27Z")

</div>

thanks my bro, solved it

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/bubble/original/3X/2/8/2847faa74692c2ffa5d939d3dc3724cdd060d247.png) [@system](https://forum.bubble.io/u/system)\
**Post date:** [August 13, 2024, 11:37pm UTC](https://forum.bubble.io/t/trying-to-import-csv-i-get-totally-random-columns/325483/8 "2024-08-13T23:37:25Z")

</div>

This topic was automatically closed after 70 days. New replies are no longer allowed.