Opening the Download File With Microsoft Excel 5.0 or higher
Please note: We provide this information as a
free service to guide you in using our information. However, we do not sell
Microsoft Excel and therefore cannot provide technical support for it.
1. First, use mnileads.com to select the companies you want and download them to
your computer. For text file options, leave the default choices selected: Yes
for Field Names as First Record, Commas for the Quoted Field Delimiter. The
result will be a .TXT file (Example: MNI403062797105112.TXT).
2. Next, launch Microsoft Excel 5.0.
3. Click on File and choose Open… from the menu.
4. In the Files Of Type: box, choose Text Files.
5. Then find the exported file (Example: MNI403062797105112.TXT) and
double-click on it. The Text Import Wizard will be displayed.
6. In step 1 of the Text Import Wizard, select Delimited, then click Next.
7. In step 2 of the Text Import Wizard, deselect Tab if necessary, select Comma,
then click Next.
8. In step 3 of the Text Import Wizard, format any numeric fields that may
contain 0 as a first digit as TEXT. These fields may include (but are not
limited to) Zip codes, telephone and fax numbers and SIC codes. Click Finish.
9. Click File and choose Save. In the Save as type: box, choose Microsoft Excel
Workbook to save your file as a standard Excel file.
You are finished importing the file from EZ Select into Excel. For a list of the
fields or columns in the file, point your browser to
http://www.mnileads.com/pages/fields.asp.