Downloaded csv file wont open in excel

Will the file fit in a single worksheet?? See How can I work with a 4GB csv file? Download a program that can open it like Sublime Text Guessing if it's 3.

You're probably going to need a database not Access as this is too big for that too to deal with this kind of data. And see Viewing a very large CSV file? Show 1 more comment. Active Oldest Votes. Add a comment. Solar Mike Solar Mike 4, 3 3 gold badges 12 12 silver badges 23 23 bronze badges. Jabe Hickey Jabe Hickey 63 8 8 bronze badges.

This is a common problem. The typical solutions are Insert your. Processing you data using Python, or R. Devin Yang Devin Yang 1. Sign up or log in Sign up using Google. I found that KerouacJack's suggestion put me on the right trajectory, however being a bit gun shy of making a lot of changes in the Trust Center settings, I only deselected "Enable Protected View for files originating from the Internet" in the Trust Center Protected views tab, and made no other changes.

When you try to open the downloaded spreadsheet, you do get the warning armandsalmon pasted in above, however this is EXACTLY the same behavior that I have been getting for years on Excel Just select "yes" and it opens just like Excel I don't consider this workaround, I consider it a problem solved. Good job KerouacJack and thanks! To continue this discussion, please ask a new question.

Get answers from your peers along with millions of IT pros who visit Spiceworks. Best Answer. If anyone finds a permanent solution, I'm all ears. Search Support Search. Learn More. Chosen solution Hello, this is a very simple thing to change. Chosen Solution Hello, this is a very simple thing to change. Hello, this is a very simple thing to change. If you want to investigate that further: I created an add-on to view the Content-Type header sent with each download, and create overrides for certain file extensions.

What's gone wrong with Office ? I just installed it, replacing Office , which was working OK for all my purposes. I regularly export. Now they just don't open at all and I can't find any setting in Excel that would allow them to open. Fortunately I can rely on Apache Open Office Calc to do the job but why on earth would Microsoft remove a really basic feature in what is supposed to be an upgrade? Please fix asap. Friday, September 15, AM.