about importing CSV files into GS tables
FViMagination
Member Posts: 89
Hi guys, I'm getting crazy with tables, I don't know what I'm doing wrong but here's what I have:
I'm making a word game and have a table with 5 columns and several rows, each cell has a single letter. If I import a CSV file that has the same configuration into a GS table, I get only 1 column of text with the 5 letters gathered together all in 1 word per row.
So, I've tried to export my GS table into CSV file, and if I open the CSV file I get all words in this way:
a,"b","a","c","o" (this string stays in 1 cell, it doesn't show me 1 letter/cell as my GS table shows instead...)
Even funnier, if I import that CSV file again into my GS table, it gives me all the words into a cell, row by row, instead of separating all the letters into a single cell...
So I have a CSV file that has 5 columns and more than 999 rows (I know it's possible, Mumble Jumble's tables have something like 1600+ rows), each cell has a single letter, and I would love to import that file into my GS tables, select TEXT as table's format and get what I've done instead of a mess...
help please!
I'm making a word game and have a table with 5 columns and several rows, each cell has a single letter. If I import a CSV file that has the same configuration into a GS table, I get only 1 column of text with the 5 letters gathered together all in 1 word per row.
So, I've tried to export my GS table into CSV file, and if I open the CSV file I get all words in this way:
a,"b","a","c","o" (this string stays in 1 cell, it doesn't show me 1 letter/cell as my GS table shows instead...)
Even funnier, if I import that CSV file again into my GS table, it gives me all the words into a cell, row by row, instead of separating all the letters into a single cell...
So I have a CSV file that has 5 columns and more than 999 rows (I know it's possible, Mumble Jumble's tables have something like 1600+ rows), each cell has a single letter, and I would love to import that file into my GS tables, select TEXT as table's format and get what I've done instead of a mess...
help please!
Comments
Can you successfully import the csv file I've attached? If not, what happens if you create a new blank project file and try to import it?
What application are you using to create the csv? What format (the exact name) are you saving it as? Is this on a Mac or PC?
New to GameSalad? (FAQs) | Tutorials | Templates | Greenleaf Games | Educator & Certified GameSalad User