This is a sample CSV that can be pasted into the Import Text addon gramplet.
It demonstrates a FEW of the recent improvements to the Import and provides a template for people who would like to use a spreadsheet for mass entries.
(It is even more simple to copy and paste from a spreadsheet when the “Tab” delimiter is selected for text import instead of a comma. It does not require saving a file and finding it for import. Nor do you need placeholder commas and quotes when using commas. Save the file to a .csv text file and import into your favorite spreadsheet.)
The failure to use square brackets around the Place identifier for the German places was INTENTIONAL. The demonstrates how the Import Text will create a new record if there is a conflict with an existing ID. (It is a good example for testing the Isotammi automatic multimerge too!)
Place,Title,Name,Type,Latitude,Longitude,Code,Enclosed_by,Date
[P0957],USA,USA,Country,,,,,
[P0957a],British Colonies,British Colonies,Territory,,,,,
[P0958],Deutschland,Deutschland,Country,,,,,
P1111,"Bayern, DE",Bayern,State,,,,[P0958],
P1112,"Niederbayern, Bayern, DE",Niederbayern,District,,,,P1111,
P1113,"Passau, Niederbayern, Bayern, DE",Passau,County,,,,P1112,
P1114,"Ruhstorf a d Rott, Passau, Niederbayern, Bayern, DE",Ruhstorf a d Rott,City,48.4389,13.3332,94099,P1113,
[P0020],Republic of Mexico,Republic of Mexico,Country,,,,,1821
[P0007a],"Alta California, Republic of Mexico",Alta California,Territory,,,,[P0020],bef 2 Feb 1848
[P0050],"OH, USA",OH,State,,,,[P0957],
[P0007],"CA, USA",CA,State,,,,[P0957],9 Sep 1850
[P0022],"WA, USA",WA,State,,,,[P0957],
[P0029],"TN, USA",TN,State,,,,[P0957],
[P0032],"SC, USA",SC,State,,,,[P0957],
[P0036],"AR, USA",AR,State,,,,[P0957],
[P0039],"IN, USA",IN,State,,,,[P0957],
[P0041],"MS, USA",MS,State,,,,[P0957],
[P0042],"NM, USA",NM,State,,,,[P0957],
[P0059],"SD, USA",SD,State,,,,[P0957],
[P0062],"LA, USA",LA,State,,,,[P0957],
[P0066],"MT, USA",MT,State,,,,[P0957],
[P0070],"ID, USA",ID,State,,,,[P0957],
[P0239],"Humboldt, CA, USA",Humboldt,County,,,,[P0007],
[P0266],"Greene, AR, USA",Greene,County,,,,[P0036],
[P0316],"LaPorte, IN, USA",LaPorte,County,,,,[P0039],
[P0409],"Twin Falls, ID, USA",Twin Falls,County,,,,[P0070],
[P0433],"Washington, LA, USA",Washington,Parish,,,,[P0062],
[P1131],"Aberdeen, WA",Aberdeen,City,,,,[P0022],
[P1132],"Bogalusa, LA",Bogalusa,City,30.7910204,-89.8486858,,[P0433],
[P1388],"Portsmouth, OH",Portsmouth,City,,,,[P0050],
[P1398],"Albuquerque, NM",Albuquerque,City,,,,[P0042],
[P1414],"Eureka, CA",Eureka,City,40.8020712,-124.1636729,,[P0239],
[P1435],"Great Falls, MT",Great Falls,City,,,,[P0066],
[P1494],"Knoxville, TN",Knoxville,City,,,,[P0029],
[P1498],"Paragould, AR",Paragould,City,36.0584021,-90.4973286,,[P0266],
[P1623],"Michigan City, IN",Michigan City,City,41.7075394,-86.8950297,,[P0316],
[P1643],"Aberdeen, SD",Aberdeen,City,,,,[P0059],
[P1661],"Myrtle Beach, SC",Myrtle Beach,City,,,,[P0032],
[P1678],"Twin Falls, ID",Twin Falls,City,42.5629668,-114.4608711,,[P0409],
[P1691],"Picayune, MS",Picayune,City,,,,[P0041],
Person,Surname,Given,Call,Suffix,Prefix,Title,Gender,Birth date,Birth place,Birth source,Baptism date,Baptism place,Baptism source,Death date,Death place,Death source,Burial date,Burial place,Burial source,Note
[I0044],Garner,Lewis Anderson,Anderson,Sr,,Dr.,male,21 Jun 1855,[P1435],Baptize registry 1850 - 1867 Great Falls Church,,,,28 Jun 1911,[P1678],,1 Jul 1911,[P1678],,
[I0106],Garner,Robert W.,,,,,male,24 Apr 1826/7 (Julian),[P1131],2nd Source,,,,3 Feb 1916,[P1114],,5 Feb 1916 (Mar25),[P1494],,
[I0045],Martel,Luella Jacques,,,,,female,23 Jan 1852,[P1414],3rd Source,,,,28 Apr 1921,[P1661],,30 Apr 1921,[P1661],,"Notes are forever"
[I0107],Zieliński,Phoebe Emily,,,,,female,12 Apr 1827,[P1132],,,,,7 Mar 1882,[P1398],,9 Mar 1882,[P1623],,
Marriage,Husband,Wife,Date,Place,Source,Note
[F0017],[I0044],[I0045],1 Apr 1875,[P1498],,
[F0018],[I0106],[I0107],4 Oct 1849,[P1498],,
[F0019],,,3 Jan 1823,[P1691],,
[F0306],,,,,,
[F0307],,,4 Apr 1840,,,
Family,Child
[F0018],[I0044]
[F0019],[I0106]
[F0306],[I0107]
[F0307],[I0045]