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

问题描述

我收到了一个超过 MAX Excel 处理能力的 CSV 文件，我真的需要能够查看所有数据.我理解并尝试了拆分"它的方法，但它不起作用.

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 an 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 re-import 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)

我认为发生这种情况的原因可能是因为我以 Excel CSV 文件的形式提供了 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?

推荐答案

你应该试试 delimit 它最多可以打开 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屋！