Excel CSV。文件具有超过1,048,576行数据 [英] Excel CSV. file with more than 1,048,576 rows of data

问题描述

我已经得到一个CSV文件，超过MAX Excel可以处理，我真的需要能够看到所有的数据。我理解并尝试了拆分它的方法，但它不工作。

I have been given a CSV file with more than the MAX Excel can handle, and i really need to be able to see all the data. I understand and have tried the method of "Splitting" it but it doesnt work.

一些背景：CSV文件是和Excel Csv文件，文件已经说有大约 2m 行数据。

Some background: The CSV file is and Excel Csv file, and the person who gave the file has said there are about 2m rows of data.

当我将它导入Excel时，到行 1,048,576 ，然后在数据中的 1,048,577 行开始的新标签中重新导入，一行，我知道一个事实，应该有更多的（不仅是因为该人说有超过200万，而是因为在最后几组行的信息）

When I import it into Excel, i get data up to row 1,048,576, then reimport it in a new tab starting at row 1,048,577 in the data, but it only gives me one row, and I know for a fact that there should be more (not only because of the fact that "the person" said there are more than 2 million, but because of the information in the last few sets of rows)

我以为也许，这是因为我已经提供了CSV文件作为Excel CSV文件，所以所有的信息过去 1,048,576 丢失了？

I thought that maybe, the reason for this happening is because i have been provided the CSV file as an Excel CSV file, and so all the information past 1,048,576 is lost?

我需要询问一个SQL数据库格式的文件吗？

DO I need to ask for a file in an SQL database format?

推荐答案

您应该尝试定界，它可以打开多达20亿行和200万列，非常快速地获得15天免费试用。为我工作！

You should try delimit it can open up to 2 billion rows and 2 million columns very quickly has a free 15 day trial too. Does the job for me!

这篇关于Excel CSV。文件具有超过1,048,576行数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！