- 想看看CSV文件吗?
- 你是否遇到过引号问题(缺少引号或双引号)导致 CSV 文件损坏,但你却不知道问题出在哪里?
This simple tool helps to visualize these problems without loading bigger tools (MS Excel …).
它还允许导出为其他格式。
This simple tool helps to visualize these problems without loading bigger tools (MS Excel …).
它还允许导出为其他格式。
| Online CSV Viewer and Checker | Microsoft Excel | Google Sheets | LibreOffice Calc |
|---|---|---|---|
| 尺寸限制: The free plan on the vendor pricing page lists a 50 MB maximum file size and 100 records per file. Paid plans raise this to 200,000 and then 400,000 records per file. | 尺寸限制: A worksheet holds 1,048,576 rows by 16,384 columns, and CSV import and export are limited to the same size. | 尺寸限制: Files created in or converted to Google Sheets can hold up to 20 million cells or 100 MB. The Drive help page does not state a column limit. | |
| Loading and parsing control: Data is loaded by file upload, paste or URL. The page also lists an Amazon S3 connector, with Google Drive, Dropbox and SFTP marked as coming soon. The stated purpose is to locate quote problems in a corrupted CSV without opening a heavier tool. | Loading and parsing control: Data > From Text/CSV opens Power Query with a delimiter picker and live preview. Opening a .csv directly applies default data formats, which can alter columns such as those with leading zeros. | Loading and parsing control: File > Import lets you pick the separator: detect automatically, tab, comma or a custom character. Six import modes decide whether the data replaces, appends or goes into a new sheet. | Loading and parsing control: The Text Import dialog sets the separators and the text delimiter to match the file quote character. Fields that contain a comma must be wrapped in quotes. |
| Formats handled: Besides CSV, the page lists Avro, Excel, JSON, Parquet, PDF, TSV and XML as source types. Export to other formats is the second stated use, and the exact list is not given on the viewer page. | Formats handled: Save As writes CSV (comma delimited) or tab-delimited text. Only the active worksheet is saved, and features specific to Excel are lost. | Formats handled: Import accepts .xls, .xlsx, .xlsm, .ods, .csv, .txt, .tsv and .tab files, among other spreadsheet types. | |
| 平台和成本: Runs in the browser. The vendor lists a free plan, a 3-day pass as a one-time purchase and a Professional subscription plan. | 平台和成本: The support page for this import procedure covers Windows-based Excel only. | 平台和成本: Desktop builds are offered for Windows, macOS and Linux on the LibreOffice download page. The page does not state a price. |
涵盖的主题: CSV、查看器、检查器、可视化、数据完整性、导出格式、文本解析、错误检测、文件格式、在线工具、用户友好、数据验证、ISO 8601、ISO/IEC 27001、ISO 9001、ISO/IEC 25010 和 ISO 19115。
隐私 我们没有关于该工具和作者潜在问题的反馈。但与许多在线服务一样,您在这里向他们提供的是您自己的数据。您有责任评估作者的声誉和可能的滥用情况,并检查和接受他们的条款和条件,这取决于您的数据是否具有批判性。
只有注册会员才能免费获得 100% 的全尺寸图片和下载。.
> 登录 <