How do I save csv file?

stefdelec

Hi,

I am trying to save a table in libreoffice in CSV file to be able to import it. It ask for the alphabet, the text delimiter, field delimiter...etc... Anyway at the end, GS import it as one column, with weird character...

:-(

tatiang

I don't use libreoffice but what are the file format options for saving to CSV? What does the save dialog look like? What does the screen where it asks for delimiters look like?

stefdelec

I can use, excel otherwise. But I don't understand where " or ; can be changed and have to be. thanks!

tatiang

Excel will definitely work. You can't use a {Tab} for the delimiter. Does it list {Comma} as an option?

stefdelec

I tried with excel. The same... it import in "one colonne".

tatiang

This post and the whole thread might help:

http://forums.gamesalad.com/discussion/comment/453372/#Comment_453372

just worked out that tables doesn't like these characters - ',£,;

stefdelec

I gonna try. Tks

stefdelec

Hi,

I am really trying all possible options... but the one which works. I read most of article related to csv.

I have a table with words: 2 columns, y rows. I am saving it as CSV. Then GS=> import csv, text... All is in one column. What am I doing wrong?

I am thinking it might be the text delimiter or something?

What am I doing wrong?

tatiang

Please don't create multiple threads for the same issue. It's against forum rules. I've merged the threads.

Are you saving it in Excel as a CSV formatted file? Can you open that file in a text editor and paste the first few lines here?

Have you tried creating a new Excel file, typing in a few words in a few rows, saving as CSV, and then importing to GameSalad? What happens?

What happens when you import the attached CSV file? Here are the contents:

Question1,Answer1
Question2,Answer2

stefdelec

Please don't create multiple threads for the same issue. It's against forum rules. I've merged the threads.

I thought my thread was lost among all the other thread. Sorry for that.

Are you saving it in Excel as a CSV formatted file? YES

Can you open that file in a text editor and paste the first few lines here?
Question1,Answer1
Question2,Answer2

Have you tried creating a new Excel file, typing in a few words in a few rows, saving as CSV, and then importing to GameSalad?

Yes. Same issue.

stefdelec

And i I import your test.csv in gs, no prob: 2 column.

stefdelec

Ok I found a way to do it.

I "concatenate(A1;",";B1). And copy-paste "value" in a new tab. Save it as csv. It works fine.

stefdelec

Thanks for your "test.csv" file. It have shown me what accepted csv looks like.

tatiang

A couple things in terms of forums etiquette (no big deal but since you're new you might want to know):

To quote a post, you can either use the Quote button below that post or you can use the greater than symbol > in front of text you want to quote, in which case it will look like this:

quoted text

You can add a new post to an existing thread you've created by clicking on the My Discussions link in the sidebar at the top-right of the forums page.

Glad it's working now!