Ok, so you want to create an Excel sheet from the search results of your MLX search and don’t remember how? Here are some steps you might want to follow.
- First make sure the grid you are using in MLX have all the data you will need to do your presentation ( If you don’t remember how to prepare a grid please post a comment and I will respond in a blog)
- Now that you have your search results go to the bottom left of the search page in your MLX. You will see the word action. Select EXPORT DATA from the down arrow and click the green button
- Click NEXT. Check mark INCLUDE COLUMN HEADERS click NEXT again
- Choose DESKTOP and name the file
- Click save. This will put an icon with the same name on your desktop
- Close MLX when you see PROCESS COMPLETED
- Open a new Excel sheet document and click on DATA on the top bar
- Scroll to IMPORT EXTERNAL DATA – IMPORT DATA
- Change my data sources to DESKTOP
- Select your file by name (click once on it)
- Click OPEN
- Click NEXT
- Check mark COMA then click NEXT
- Click FINISH then OK
Voila! Presto your excel sheet appears and looks great. You are not quite finished. You will need to add a row or two to your excel sheet and give your work a title. Don’t forget to add your name and contact and logo to make it official.
TIP: You might want to print in landscape if necessary to include all the columns in your Excel sheet. Do a print preview to verify if everything fits.
Until next time have fun with this new tech tip.
5 comments on “Angela’s Tech Tip: Exporting Data from MLX to an Excel Sheet…”