| |
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!
|
|
