Click "Next." Click "Next" to allow Microsoft Access to add a primary key, which is a unique table identifier, to your table. Click "Finish" to import the data from the Excel document.

3. Convert to formulas. Finally, position your cursor in the PivotTable you want to convert, and from the PivotTable Tools menu, select Analyze, OLAP Tools, Convert to Formulas, as pictured below.

How to Convert Excel Data to a Mailing List. Capturing and organizing customer or prospect email addresses is the first basic step toward compiling a mailing list.

If the source data is not in a Table object, Excel will prompt you to convert the data range into a Table object. Check the My Table Has Headers option and click OK.