CSV file to Import correctly into Excel 2003

Google is your friend.

Maybe this helps convert to what you want:

https://support.office.com/en-us/article/import-contacts-from-an-excel-spreadsheet-to-outlook-f6483469-0684-4c30-82c5-c881930f5451

most spreadsheet programs have the ability to import .csv files. Be sure to use a blank sheet.

That probably depends upon the 3rd party. You MIGHT try exporting your contacts list (as a .csv, or Comma Separated Values, file). You can then open that file with Excel or OpenOffice Spreadsheet and change it around however you like. Your 3rd party software may be able to import the .csv file, or you may be able to reimport it into gMail and have it automatically rearrange your contacts.

The problem occurs, only when the CSV file was edited and saved by MS Excel. The solution: use only Notepad, Excel never!

Here is the skinny, if you cannot find the software but still have your mml file all you have to do is download a dos program to convert your file to a csv, comma separated value file. here is the link to the database providers site:
http://vermontdatabase.com/mymail.htm
the program dbport.exe is in the dbport.zip file.
Download it and unzip it in the same folder that has your mml files in it.
Then run the command dbport.exe e oldfilname.mml newfile.csv
Then open the new csv file with excel or a similar database program that will open csv files.
Then copy all the cells that have your addresses.
Paste them into notepad and then you can cut and paste from there. You can import them into outlook as contacts too. This however means you have to set up the importing correctly.

CSV means:
A comma-separated values or character-separated values (CSV) file is a simple text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next by a character (typically a comma, but some European countries use a semi-colon as a value separator instead). Implementations of CSV can often handle field values with embedded line breaks or separator characters by using quotation marks or escape sequences. CSV is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. For example, a CSV file might be used to transfer information from a database program to a spreadsheet.
A comma-separated values or character-separated values (CSV) file is a simple text format for a database table. Each record in the table is one line of the text file. Each field value of a record is separated from the next by a character (typically a comma, but some European countries use a semi-colon as a value separator instead). Implementations of CSV can often handle field values with embedded line breaks or separator characters by using quotation marks or escape sequences. CSV is a simple file format that is widely supported, so it is often used to move tabular data between different computer programs that support the format. For example, a CSV file might be used to transfer information from a database program to a spreadsheet.

The problem occurs, only when the CSV file was edited and saved by MS Excel. The solution: use only Notepad, Excel never!

You can save the file as a csv (comma seperated values) which will lose all the formatting in the excel sheet and save only the single worksheet. You should then be able to open this in quickbooks.

When you choose to open the csv file - A pop up box will take you through the steps - You need to highlight the seperators as Excel is currently unable to do this.

Once you are going through the process you will be able to select, hash, space, comma as the seperataor into the respective columns.

You can save it as csv and use the file to insert using
LOAD DATA LOCAL INFILE '/importfile.csv'
INTO TABLE test_table
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(field1, filed2, field3);