What kind of CVS should I save my file to for tables

gotyours

hello- what kind of cvs should i save my file as when working in excel- when i import it back into GS i find that any " turn into different symbols and ' change too, any help with this would be great as i did all the work for a project on my cpu and imported in and had this issue- i am working with text for this project

MotherHoose

any csv file can be opened in TextEdit.app
you can see the content/layout there
*every comma separates the value as new column
*every new line is a new row

check that the quoteMarks are correct
if the a " (double quoteMark) is ' (single) … then Edit > Find > Replace all the ' with "
if that file shows column/row labels … you can delete them there

import into GS as Text … if that is all your file contains

MH

Cluv

I use a standard CSV.

The issue I found is that you need to input your table titles and the type of variable, separately. In GameSalad, there is a pair of rows above (1,1) that are both for column title and variable type respectively. When I imported my CSVs, I had my column headers at (1,1) which meant that I had an extra row of info that was supposed to go above the variable.

I would import only the data so that your data starts at the upper left corner of your table. Most likely what is happening is that you either didn't define the variables in your table, or the first row of data is actually not data at all, but names.

I hope that helps.

-C

gotyours

still don't get it- i think your trying to tell me to change the A column to 1? i have no clue how to do that-any help would be good i am not good at excel at all i guess i could just work in the table in GS if i have to, thanks for the help though

Cluv

If you already have a spreadsheet setup then remove any label column or rows and only keep the actual data. Then save it as a CSV file that you can then upload into gamesalad. Once there, you can configure the table as you see fit.

gotyours

thanks guys was getting so pissed about the issue was driving me nuts thinking i had to do all the work again, but it worked- so thanks for not making me pull my hair out lol