Wednesday, 25 October 2017

How to Split a Huge CSV Excel Spreadsheet Into Separate Files

Microsoft Excel

Excel is excellent at so many day-to-day tasks. But every now and then, you encounter one of its shortcomings: the size of a spreadsheet. If you need to know how to make an Excel spreadsheet smaller or how to split a large CSV, we have you covered. Hitting the spreadsheet row limit is a pretty serious task in and of itself. The current Excel spreadsheet row limit is 1,048,576. That’s right — over 1 million rows, and the same amount of columns, too. But hitting that row limit is actually incredibly easy, during certain tasks. If you’re marketing via email,...

Read the full article: How to Split a Huge CSV Excel Spreadsheet Into Separate Files



from MakeUseOf http://ift.tt/1w0O0km
via IFTTT

No comments:

Post a Comment