Ok,

Someone must have done this before but I'm having a hard time. So any
help is appreciated.

I'm trying to get a PGN file into Excel form so that I can manipulate
the variables and have them be separate columns. I've tried importing
the data but it keeps treating everything as one column.

Is there a simple way to import PGN into an Excel file so that each bit
of info is in a separate column (event, black, white, tournament, year,
ply, result, moves, etc) with each row being one game?

Thanks a lot to all the experts out there.

Cannot be much of a problem when you know the transpose function (rows to
columns and vice versa) to put a table on its side.
It's an option under "Paste special".
First read the PGN into a word processor, replace all hard returns by
space, then replace ] by ]+return (to get the headers back and each on one
line). Import or cut/paste into Excel, transpose, ready.

But did you think of the limitations of Excel?
255 characters in a cell, so problems to put a long game into one cell,
256 columns wide maximum (not much of a problem)
65535 rown maximum, so no database file of over 65535 games.

Best regards, Wijnand.
schreef in bericht
ups.com...
Ok,

Someone must have done this before but I'm having a hard time. So any
help is appreciated.

I'm trying to get a PGN file into Excel form so that I can manipulate
the variables and have them be separate columns. I've tried importing
the data but it keeps treating everything as one column.

Is there a simple way to import PGN into an Excel file so that each bit
of info is in a separate column (event, black, white, tournament, year,
ply, result, moves, etc) with each row being one game?

Thanks a lot to all the experts out there.

I don't know about older versions of Excel, but Excel 2003 (Office 11)
will happily store 10's of thousands of characters in a single cell,
although it does seem to get squirrley about *displaying* cells with
that many characters. Have to use "wrap text", and even that seems to
just give up after 1100-1200 characters. Doesn't seem to lose any data
though.

I think the 255 is the maximum *displayed* width for a cell, not a
storage limitation. I didn't test it, but I'm pretty sure you're right
about the 65,535 row limit.

Despite its tempting simplicity, Excel is pretty limited as a database.



Wijnand Engelkes wrote:
Cannot be much of a problem when you know the transpose function (rows to
columns and vice versa) to put a table on its side.
It's an option under "Paste special".
First read the PGN into a word processor, replace all hard returns by
space, then replace ] by ]+return (to get the headers back and each on one
line). Import or cut/paste into Excel, transpose, ready.

But did you think of the limitations of Excel?
255 characters in a cell, so problems to put a long game into one cell,
256 columns wide maximum (not much of a problem)
65535 rown maximum, so no database file of over 65535 games.

Best regards, Wijnand.
schreef in bericht
ups.com...

David Vancina wrote:
Despite its tempting simplicity, Excel is pretty limited as a database.

Which shouldn't come as a surprise as

1) it's a spreadsheet, not a database;
2) Microsoft produces separate database software.


Dave.

--
David Richerby Carnivorous Incredible Soap (TM):
www.chiark.greenend.org.uk/~davidr/ it's like a personal hygiene product
but it'll blow your mind and it
eats flesh!

My favorite feature of Excel as a database:
Create a large database of 1100 items, numbered 1 to 1100
Turn autofilter on
Try to find item nr. 1100 in the list produced by autofilter.
Wijnand.

"David Richerby" schreef in bericht
...
David Vancina wrote:
Despite its tempting simplicity, Excel is pretty limited as a database.

Which shouldn't come as a surprise as

1) it's a spreadsheet, not a database;
2) Microsoft produces separate database software.


Dave.

--
David Richerby Carnivorous Incredible Soap
(TM):
www.chiark.greenend.org.uk/~davidr/ it's like a personal hygiene
product
but it'll blow your mind and it
eats flesh!