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
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