Main
Date: 26 Mar 2006 07:23:47
From:
Subject: PGN to Excel
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.





 
Date: 26 Mar 2006 20:29:54
From: Wijnand Engelkes
Subject: Re: PGN to Excel
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.
<[email protected] > schreef in bericht
news:[email protected]...
> 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.
>




  
Date: 28 Mar 2006 21:40:25
From: David Vancina
Subject: Re: PGN to Excel
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.
> <[email protected]> schreef in bericht
> news:[email protected]...


   
Date: 29 Mar 2006 09:34:25
From: David Richerby
Subject: Re: PGN to Excel
David Vancina <[email protected] > 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!


    
Date: 29 Mar 2006 22:14:55
From: Wijnand Engelkes
Subject: Re: PGN to Excel
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" <[email protected] > schreef in bericht
news:rTb*[email protected]...
> David Vancina <[email protected]> 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!