PDA

View Full Version : Importating Formulators .csv files to Excel


o0xst!
09-05-2007, 04:31 PM
Has anyone used the .csv files provided by Formulator (export as .csv) to import in Excel and create various charts and whatnot? Im thinking about brushing up on my Excel skills if anyone has done this and can tell me that it isn't to much of a pain.


thanks!!!

robert99
09-05-2007, 05:14 PM
oOxst!

I use Lotus 123, but as long as the files imported have a csv extension they will be easily downloaded into the spreadsheet through File/Open (filename).
each data item goes into one spreadsheet cell.

Make sure you click first on the cell where the csv data is to start.
You might want to try things out on a blank worksheet first.

Later try recording a macro to do it all in one click.

Tom
09-05-2007, 08:31 PM
Very simple to import them into Excel. You can export as txt, asc, or cvs.

o0xst!
09-05-2007, 11:06 PM
Thanks, Im on it!!!!