excel converting

[tele111fon]

Hi guys!
I have a problem. I have got a text file thats formatted like the following example:

["text","text","number","text","number","number","text"],
["text","text","number","text","number","number","text"],
["text","text","number","text","number","number","text"],

but this list is about 250 rows long... =(

Is there a way to batch convert this *.txt list into an excel file?
Thanks

[tigeravatar]

tele111fon,

Give this a try:

1. Make a copy of the .txt file
2. Rename the copy to end in .csv instead of .txt
3. Open the .csv file (default to open a .csv file should be Excel)

Hope that helps,
~tigeravatar

[tele111fon]

thx for the fast reply, but i want it sorted to different collumns, not just pasted into one collumn

[tigeravatar]

tele111fon,

If, like in the sample data you posted, the terms are seperated by a comma, excel will automatically separate those terms into columns when its reading the data as a .csv file

csv = comma separated values

If that is not the case however, you can use Data -> Text to Columns to separate the data by whatever delimiter is separating the terms.

For a more detailed look, I would need a sample file that you're trying to convert

Hope that helps,
~tigeravatar

[tele111fon]

Thank you very much tigeravatar =)