When I export from ShoppingCenters.com and open the file, the data is not in columns? How do I fix this?
You may run into this problem when your computer does not know how to handle CSV files. For both Windows and Mac computers, you will have to change your settings to open CSV files with Excel by default.
- For computers with Windows 7, you will have to go to the “Start button” at the bottom-left corner of the window, and then click Default Programs.
- Click “Associate a file type or protocol with a program”.
- The list is in alphabetical order, so look for “.csv” and double-click it.
- Then under “Recommended Programs” click “Excel (desktop)” – Microsoft Corporation. Then place a check mark under “Always use the selected program to open this kind of file”. Then click “OK”.
So that’s it and you don’t ever have to bother with that again. From now on any CSV file you download and save, will be opened automatically by Excel.
If you want more information on how to do this, click here.
- For computers with Mac OSX, first find the exported CSV file with the OS X Finder, right-click (or Control + Click) on the file.
- Then hold down the Option key so that the “Open With” menu becomes “Always Open With”.
- Look for Microsoft Excel, if it’s not in the main list of apps, click “Other” and you will be able to better find it there.
For more information on making Microsoft Excel the default program to open CSV files on Mac computers click here.
For more information on this and exporting, click here.
- Technical Support
- Research Methodology
- Historical Inventory of Listings
- DMM Data in Research Studies and Whitepapers
- Where can I see past issues of DMM e-News?
- Is there a short video I can watch which gives me the highlights of the site?
- DMM Mapping Tool Tutorial
- Using the Search Query Function
- I am seeing a blank screen or blank fields when I try to run a query
Still Need Help?Contact Us