Plus here is a good online tutorial for making a CSV file:
Mac users have trouble making a windows compatible CSV file. One solution is to use google docs. Another is to use the the program “Numbers.” OpenOffice does not do the line endings compatibly with a PC. A comment from a very knowledgable user indicates that you must save the CSV in Excel 2011 as “Windows Comma Separated (.csv)” and yet another user said that in “LibreOffice spreadsheet, remember to save as text (.csv)” which is way down the list.
Thanks to my great tester Lisa, here are some step by step instructions for creating a CSV from a downloaded Excel file from 23andme:
- 23andme: Download Ancestry Finder (AF)
- Open in Excel (I use 2007, other versions might vary slightly), I also have Excel 2003 if these do not translate well)
- Remove or Hide columns “B” through “I” by holding down left mouse pointer on “B” and pull through to column “I”, then click the delete key on your keypad
You can highlight the same way, then right mouse click to reveal a menu, select “HIDE” and they will no longer be shown
- Go to the top of your AF and put mouse pointer on column A1
- From the HOME tab select “INSERT”, it should automatically insert a new row, if not click the drop down triangle and manually select to add a row, alternately you could select all of your data by pulling the mouse over it and moving it down one row. Also click the drop down triangle and manually select to add a column in order to add the column for “side.”
- These instructions will make it easy to just paste the column headings even though the program will ignore other columns, paste these row headings. If you have a file that already has column headings then you do not need to insert a row but you do need to replace the column headings with these:
side MRCA Chr Start point End point cMs
- SAVE AS: other format, a drop down box will appear, follow it until you see CSV (COMMA DELIMINATED), click SAVE. Be sure to recall where you are saving it as you will need to find it to run the program.