Weird formatting on export
closed
B
Beautiful Bidget
I have tried multiple ways to export, but what I get is really not working for me. I just add a screenshot of what I mean. Is this, what it should look like?
Am I doing something wrong?
Log In
Hamish
marked this post as
closed
Thanks for letting me know!
Hamish
Beautiful Bidget nope, this should not be happening. I'm not sure what's going on. What device & operating system did you use to export, and what software & operating system did you use to open the file?
B
Beautiful Bidget
Hamish Thank you for your reply. I found out what the problem was in the meantime and was just not able to update the issue here. Here is the problem and the solution:
The problem was, that I used Microsoft Excel on windows. I tested to open the file with Google Sheets and, voila, it worked. I then did some research and found out, that I cannot open csv by just open the file with Excel, instead, I need to create a blank sheet and go to Data/import from csv.
I haven't used csv before, so I wasn't aware of it.
B
Beautiful Bidget
Here is the video that helps with the problem:https://youtu.be/5HhIGwcQw08?si=sd4EMgBJ06m3NrTm