export?

[chriskelly]

How do I export rosters to an excel spreadsheet?

[Bigrod]

Originally Posted by chriskelly

How do I export rosters to an excel spreadsheet?

Open the league's settings page and on the right, click export leagues rosters. The go into your saved game's import/export folder and change the rosters.txt to rosters.csv (if needed) and open it.
Make your changes and save. Then on the league settings page, click import rosters and select the roster file you want to import . If it doesn't load, change the extension to .txt from .csv. (both should work though if I remember correctly).

[Kent814]

Can you make a word document where are the names are listed like in excel except just a list?

[NoOne]

Originally Posted by Kent814

Can you make a word document where are the names are listed like in excel except just a list?

suggestions based on lack of knowldge, so user beware:

word won't be able to separate all the fields - at least i don't think so. check out its import features. can you import a csv or other type of spreadsheet file? does it ask about delimiters? if so, it's a good chance word can do what you want. play around in word and see what happens.

or

you could get it into the spreadsheet first then reformat it or use an export feature in the program? i've never done what you are trying to do, so i don't have intimate knowledge of the associated functions.

or

you can remove grid lines and pretend it's a word document

a highlight, copy and paste between the two programs should result in a simple table inserted into your word document, and you may even have advanced options when you click paste ("paste special" in word?).

if you are concerned about experimenting, back up all related files to a safe place and only work on expendable ones. if you "break" them, copy backups over the wrecked files.

[OBSL Commish]

Originally Posted by chriskelly

How do I export rosters to an excel spreadsheet?

When you export the rosters to a text file, you can also open it in Excel. Just right-click then "Open With. . ." and choose Excel, or open Excel, then click File, Open, and choose .txt files instead of .xls files. When Excel tries to open it, it'll open up a text import wizard. In the first step, click "Delimited" then Next. In the second step, click Tab and Comma, then Next. And in the last step, just click Finish. Once you're done with all your edits, save it as a Comma Delimited file (.csv) and you can re-import them into the game.