Export CSV with emojis in text

Need help App Organization
1

Hi All,

Does anyone know if it’s possible to export data from Bubble and keep emojis? I have text fields with emojis and I lose them when I export.

Thanks!

2

Hey @jamie,

I did a quick test and emoji’s seem to export just fine (using a MAC):

24%20PM
24%20PM874×164 11.4 KB
16%20PM
16%20PM1306×394 77.2 KB

Make sure the app opening the file understands UTF8 files.

Looking to improve your Bubble™ skills?

Let me turn
:thinking: :tired_face: :confounded:

into
:grinning: :sunglasses: :woman_student:

Coaching and Development at https://uniqueideas.com or schedule a free intro session :gift:

Ken Truesdale
LinkedIn

3

Hi, thank you for your response!

I was opening in Excel 2016 on a Mac. An excel XLS reads them, but I guess not CSV?

Do you happen to know how to view in excel?

4

Doesn’t work for me either (Excel 2011 on a MAC.) My quick google search leads me to believe that UTF8 files are not supported. Very odd.

5

@jamie

Forgot to add this screenshot. It didn’t work for me, but your 2016 version might have better luck. Open an Excel workbook and do an import of a text file rather than double clicking on the csv to open. Try changing using the settings shown here:

50%20PM
50%20PM1110×936 131 KB

6

ooh ok I will try thanks!!

7

I went thru the steps a few different ways, but I couldn’t get the data to position correctly in each column. I did figure out another way:

  1. Right click on the CSV export and open with Numbers
  2. Copy all cells
  3. Paste Special as “Unicode Text” into excel

Thanks for your help!

1 Like