Alignment issues with Excel file

Hello, I'm attempting to do an import into a new system.  it needs to be in this order:
agent_custid, refnum*, last*, first*, address1*, address2, city*, state*, zip*, country, daytime, night, ship_last, ship_first, ship_address1, ship_address2, ship_city, ship_state, ship_zip, ship_country, payinfo, paycvv, paydate, invoicing_list, pkgpart, username, _password

Each field has to have a column, respectively, but only the ones with * need to be populated.  The format needs to be either .xls or .csv
I have attempted taking the data from notepad and importing it to excel and saving in an .xls file.
I have attempted copying the data from notepad to excel.
I have attempted using tabs to separate the columns, spaces, commas etc.  I can get it to line up in excel just fine;however, when i copy that back to notepad, it doesn't line up in that.  I only do this, because the import is failing in the software system that uses the above format.  I have attached several files to show you the issue that I'm seeing.  you will see the alignment problem in notepad, and i have even made it so they are separated by only commas as well.
CSV-transfer-to-excel-take-4.txt
test-telebill-import.xls
binaryman101Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
Could you point out the alignment problem because I'm probably overlooking it but I don't see it. I also don't see any heading with or without asterisks.
binaryman101Author Commented:
In this attachment you will see the very top line line worked when I imported only that line into excel.  Then from excel I imported into the new system.  Below that are several attempts taking the same data from excel to notepad.

The problem is I am not seeing the formatting difference between the top line on this file from the entire list sent in the previous notepad file.
does that make sense?
CSV-transfer-to-excel-take-2.txt
binaryman101Author Commented:
Also, for this to work, the columns cannot have headings so I literally have to count columns to make sure they are in the correct place according to the format listed above.
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Martin LissOlder than dirtCommented:
I'm really confused.

In this attachment you will see the very top line line worked when I imported only that line into excel.
What indicates, or where can I see, that it worked?

Also, for this to work, the columns cannot have headings so I literally have to count columns to make sure they are in the correct place according to the format listed above.
Why can't they have headings?

It would help if you explained the whole process step by step. If it's a requirement that you need to use Notepad, please let me know.
binaryman101Author Commented:
Ok, my apologies for making this confusing, i've been working on this for quite some time.  Let me step back.  

I was originally given a .csv file that had all of the addresses listed in one cell separated by commas.
I split those addresses using the text to columns tool making sure to separate the values by comma.  
From that point I had to create the data in all of the other cells including making a place for blank columns. (Telebill, AAA, etc)
Once I got all of the data in excel according to the format required, I attempted to import that file giving, and I was given an alignment error.

Side notes about the software system which I am attempting to import this data into: (The software is called Freeside from Freeside.biz)  When importing customers, or any other large body of data they do not allow text headings as those would be included in the import which would cause it to fail as unrecognizable fields.  For example in the second column they call it a refnum which can only have values of 1,2,3,4 or 5.  So if it saw the text refnum anywhere in that column it would reject the import.

I have only used notepad to attempt to see where the alignment issues exist simply to see if tabs or spaces exist that shouldn't.  
Now, this string:
, 1,Telebill,A,1510 W Market St,,SALEM,IN,47167

When I took the data and moved it from excel to notepad, I consolidated it. Rather than using tabs as it originally displayed, I removed the spaces and separated the values with commas.  With the string listed here, I saved this notepad file.  I opened excel in a new spreadsheet and used the txt import tool and had it separated by commas.  It aligned correctly in excel after the import.  I then saved that file as a .xls file and I imported it to Freeside.  Freeside then gives the response if Import Successful, or it will display the error there. For this sting i got succesful import, but when attempting the entire sheet or even a small portion of it, i get an alignment error.
So I don't really have a method for you to test if it is successful, but mainly I need help ensuring my alignment is correct.
binaryman101Author Commented:
I have had this issue before several years ago, and people here were able to assist.  Unfortunately I don't remember that string or have my email that had the solution to this problem.
Martin LissOlder than dirtCommented:
You seem to be saying that a row that starts with a comma is OK, but if it doesn't then it's not. If that's true then that begs the question why not just add a comma at the start of each row?
Martin LissOlder than dirtCommented:
BTW if by the "people here" you mean EE then you should be able to search for it using your member name and a keyword or two.
Martin LissOlder than dirtCommented:
Was this your previous question?
binaryman101Author Commented:
No it didn't.  When I do the import from excel to Freeside there is an alignment issue.  I have tried adding/deleting commas etc.

My issue, and hopefully you have some suggestions here is this:  How can or what methods can I use to verify the alignment of the data in the excel spreadsheet?  

Let me give you an example of a sting of data that successfuly worked for an import and one that did not:
This one worked:  , 1,Telebill,A,1510 W Market St,,SALEM,IN,47167
This one did not:  ,1,Telebill,AAF,3710 Newton St,,JASPER,IN,47546

I don't know how to explain this any further simply because I don't understand the hidden alignment problems here.
Thoughts?
Martin LissOlder than dirtCommented:
Does this work? (No leading comma or comma+space)

1,Telebill,A,1510 W Market St,,SALEM,IN,47167
binaryman101Author Commented:
No it doesn't because without that first comma it treats the "1" as the agent_custid,  instead of the refnum*
Martin LissOlder than dirtCommented:
Have you gone here?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Martin LissOlder than dirtCommented:
I'm glad I was able to help. I'd be very interested in knowing what the problem was when you eventually find out.

In my profile you'll find links to some articles I've written that may interest you.
Marty - MVP 2009 to 2015
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.