Old 02-13-20, 12:47 PM
  #25  
St33lWh33ls
Senior Member
 
St33lWh33ls's Avatar
 
Join Date: Oct 2014
Location: Sunny Florida
Posts: 388
Mentioned: 2 Post(s)
Tagged: 0 Thread(s)
Quoted: 95 Post(s)
Liked 12 Times in 9 Posts
Kurt, Here’s an example of what needs to be done to convert, I just took the first two lines. Commas denote columns, Newline denotes rows, copy and paste into Notepad and save the file as yourfilename.csv. Open in Excel you should have what you need.

Serial,Finish,Notes,Caps,Lugs,Drops,Year

1,*Blue,Schwinn Team - Ray Cass' prototype race bike,BE,QW,TE,1937
1,*Red,Schwinn Team - Ray Cass' prototype training bike,BE,QW,TE,1937


Also wanted to note if you don’t have info for a particular column you can use two commas and it will leave that cell blank, example below.


1,*Red,Schwinn Team - Ray Cass' prototype training bike,,QW,TE,1937

Last edited by St33lWh33ls; 02-13-20 at 01:12 PM. Reason: More info
St33lWh33ls is offline