CVS refuses to Import

Hi

Trying to import CVS file with 650 records in it. I have tried everything from removing all formatting, all comments and all notes, I set all tables to text.

I then save it as a cvs file.. It always fails with the error:
Error: The data for the import is invalid

This is a few lines copied from notepad showing the cvs contents…I don’t know much about this but I don’t see what is causing the problem…
==============================
OFFICIAL_NAME,NUMBER,ADDRESS,POSTAL_CODE,PHONE,FAX,#VALUE!,MEMBERSHIP_AUTHORITY,REGION,
Abegweit,1,PO BOX 36, 11222 ST. PETERS ROAD, SCOTCHFORT, PE,C0A 1T0,(902) 676-2353,(902) 676-3206,N/A,Section 10 Band,ATLANTIC,
Lennox Island,2,PO BOX 134, LENNOX ISLAND, PE,C0B 1P0,(902) 831-2779,(902) 831-3153,https://www.lennoxisland.com/,Section 10 Band,ATLANTIC,
Elsipogtog First Nation,3,373 BIG COVE ROAD, ELSIPOGTOG FIRST NATION, NB,E4W 2S3,(506) 523-8200,(506) 523-8230,https://www.elsipogtog.ca/,Section 11 Band,ATLANTIC,
Buctouche,4,9 RESERVE ROAD, BUCTOUCHE RESERVE, NB,E4S 4G2,(506) 743-2520,(506) 743-8995,https://www.nsmdc.ca/main.html,Section 10 Band,ATLANTIC,
Esgenoopetitj First Nation,5,621 BAYVIEW DRIVE, BURNT CHURCH, NB,E9G 2A8,(506) 776-1200,(506) 776-1243,https://esgenoopetitjfirstnation.org/,Section 10 Band,ATLANTIC,
Madawaska Maliseet First Nation,6,1771 MAIN STREET, MADAWASKA MALISEET FIRST NAT, NB,E7C 1W9,(506) 739-9765,(506) 735-0024,https://www.madawaskamaliseetfirstnation.com/,Section 10 Band,ATLANTIC,
===========================================

I’ve spent about 3 hours messing with it..is there a template cvs that we can use?

As much as this looks like my solution.. I’m at a loss as what to do

BTW..I see the text I copied has the http’s converted back to links……

Thanks

• This topic was modified 7 years, 3 months ago by tugeye.