Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
There are currently about 1600 records in the CSV. I read somewhere that if you have a lot of records, you might want to break them up into several uploads; what exactly is "a lot"?
I added a column at the begining for the autonumbered field and put a 1 in the first entry (all the others I left blank). Then, I checked the tab delimited file Excel created before uploading. It had added a lot of empty lines to the end (I'm not particularly good with Excel either and seem to have added lots of blank lines to the end of the spreadsheet which deleting doesn't actually seem to remove).
After fixing these two things, I uploaded the file and everything worked fine. My autonumbered fields are now appropriately numbered, if it matters. Any other insight or advice is still greatly appreciated. Thanks.