Questions tagged [csv]

CSV (comma-separated values) is a text file format where each lines contains fields separated by a comma. The format generalizes to “character-separated values” where the separator is some character other than comma.

Filter by
Sorted by
Tagged with
29
votes
6answers
57k views

Fastest free Python library to read a CSV file with 1~3 columns of numbers

I am looking for the fastest Python library to read a CSV file (if that matters, 1 or 3 columns, all integers or floats, example) into a Python array (or some object that I can access in a similar ...
15
votes
12answers
9k views

Is there a software tool which allows to perform SQL on CSV files?

I have been trying to find tools which allows me to import a CSV file and perform SQL operations on it. I tried to import on SQL Dev 4 but it does not work without a local connection. The data is ...
12
votes
2answers
338 views

Software to collect information from employees over internet

I need to capture information from client employees by having them filling out a form. For now the best way to do that is by EXCEL sheet, since the table format best supports the information to ...
10
votes
3answers
16k views

Program to generate a CSV file from an image containing a table

I'm looking for a program that can generate a CSV file from a scanned image or PDF containing a table E.g. if the input is the ouput would be the corresponding CSV file: AIDS Behav, 9712133, ...
10
votes
1answer
724 views

Simple text editor for spreadsheet-style data entry

I enter a lot of data that will ultimately be saved as comma separated text files (.csv). I currently use Excel but often find that it auto-formats the data inappropriately and is basically overkill ...
8
votes
3answers
6k views

Lightweight contact manager for Linux with import & export feature

I am looking for a light weight contact manager for Linux (similar to this unanswered request for a Lightweight Contact Manager for Windows). I would like to be able to both import and export vCard ...
6
votes
2answers
5k views

Viewer for huge CSV files which don't fit in memory

I would like to find a CSV viewer that has the following features: Runs on Linux. Handles very large files. I mean it should not try to load the entire file in memory at any time (unlike LibreOffice ...
5
votes
3answers
623 views

Program for opening .csv files with custom delimiter

I am looking for a program that can open and display nicely .csv files and gives you the ability to set the delimiter of each file.That's because most of the files I handle have some weird delimiters ...
5
votes
3answers
6k views

Convert JSON to CSV

I'm looking for software that will convert JSON formatted data into CSV formatted data with or without header values. I'd prefer for this software to be able to take the JSON formatted file from a ...
5
votes
3answers
96 views

Open-source CSV viewer & editor

Expanding on several questions asked 10 years ago on Stack Overflow, I'd like to elaborate what's the best CSV Viewer Editor in 2021. What makes a good viewer (for me): Displays CSV in Grid view, not ...
5
votes
4answers
1k views

Tool to generate CSV lists from Wikidata

Wikidata is an online database which contains many details about many countries, politicians, paintings, etc. For instance, for each country you have name, flag, map, which are all strings or URLs to ...
5
votes
2answers
1k views

PDF to Spreadsheet Converter for bank statements

I am trying to parse bank statements and credit card statements into a machine-readable format. The bank statements are issued as (unprotected) Pdf documents. I am looking for a tool that can ...
4
votes
3answers
882 views

Offline CSV validator

I have many bash scripts converting various sources of data to CSV. The scripts often have bugs, so I would like to add a validation step. Is there a tool to validate CSV file? Requirements: Free, ...
4
votes
3answers
51 views

Web app for reviews of proposals imported from CSV

I'm helping organize a conference and am looking for a web app to assist with reviewing speaker proposals. We received the proposals through Google Forms, so the data (proposer name, session title, ...
4
votes
5answers
298 views

Tools for big CSV files manipulations

I'm working with a huge CSV dataset and I'm now make some pre-processing on it. The pre-processing consists of removing lines with "not a numbers", change columns positions or remove lines. Is there ...
3
votes
2answers
78 views

Software to build a regression model with 3.5 GB CSV on a low memory PC

I have a .csv file with 3.5 GB of data (around 8 million rows and 86 columns), and I need to build a regression model on this dataset. The thing is, just trying to read the CSV using pandas, and then ...
3
votes
1answer
7k views

Modern C++ CSV reader/parser library

I'm looking for a nice modern C++ CSV library, mostly for parsing. Required features: Written in modern C++ (C++11 at least) Gratis Libre Fast (yes, this may be difficult to quantify) Desired ...
3
votes
3answers
204 views

Tool for converting Excel files to CSV

We require a tool/program/utility that can do the following - Scan folders to look for Excel files at regular intervals. The Excel file might have different formats and the output has to be in a ...
3
votes
1answer
287 views

Speadsheet software that can handle thousands of columns

Microsoft Excel has a max number of columns of 16,384 Open/Libre Office Calc has max number of columns of 1,024 A summery of the limits for several speadsheet softwares can be found here I have ...
3
votes
1answer
76 views

Transpose a 150x3000 field CSV file

I'm looking for a software (not an online tool) that can transpose large CSV files. I found this answer, but the proposed tool can't handle my file. I also heard about EmEditor, which can handle large ...
3
votes
2answers
169 views

Android app for exporting contacts properly to csv / ods / xlsx

I use Android 5.1 on my phone. My contacts include information in essentially all fields (e.g. including email, mailing addresses, notes and more obscure ones), many include photos, and many contain ...
3
votes
1answer
107 views

Spreadsheet software that can open several CSV as tabs in the same window?

I have 3 local CSV files that I often need to check. I don't like to have too many windows open, so tabs would be great. Is there a spreadsheet program that would open the 3 CSV files as tabs of the ...
3
votes
0answers
33 views

What software can be used to create logic from datasets?

I need a software that can import a dataset (excel/CSV table) and I can write formulas/create a workflow logic to export into another (excel/CSV) table. I need this software to be able to be deployed ...
2
votes
3answers
916 views

Get random records from CSV files

I have 50 CSV files, up to 2 millions records each file. I need daily to get 10000 random records from each of 50 files and make a new CSV file with all info (10000*50). I can not do it manually ...
2
votes
2answers
2k views

Bulk search and replace in text file with results from CSV or spreadsheet?

I was wondering if there was software for Linux or Windows (preferably Win), that would allow you to take a line from a CSV or spreadsheet file and replace it inside of a seperate text file? Example:...
2
votes
2answers
27 views

What tool would you suggest I use if I have to analyze millions of rows of csv data?

I'm using windows and can't change that. Novice at programming. Something that'd let me make pivots easily to analyze would help. Basically I have about 20gb data of userids, spend, country and so on ...
2
votes
1answer
50 views

Software for conversion of csv data to pretty pdf's

For a migration between software products, we have a lot of data that can not be stored in the new product. To keep it archived somewhere in a way my colleagues can access it easily, we'd like to ...
2
votes
0answers
19 views

Open source tool to read batch CSV files and output parameter results?

I am looking for a tool that could scan batch csv files and ensure that all preset parameters are accurately reflected in the output file. Essentially, scan batch CSV files, ensure the preset ...
2
votes
0answers
42 views

Append big CSV files with some filtering, on Windows

Hi i've a very big csv file (more than 1,000,000 rows, 872.319 KB). I need to open and add some other rows from another file also csv. Which is the best solution. I tried ACCESS/VBA but freeze and ...
2
votes
1answer
351 views

Open Source OCR to Excel/csv file convert

I'm looking for the best piece, or combination or pieces of software where I take a scanned image of a table, apply some OCR and are able to convert it to a .csv format or similar. I've been playing ...
2
votes
0answers
25 views

Displaying and deleting lat/long points (from CSV file) on map

I am looking for a piece of software that will easily let me display lat long points from a CSV file on a map, then be able to select a group of points (via a box or drawing), delete the points ...
2
votes
0answers
217 views

Java library to load CSV file into any JDBC database

I would like to know if there is any library that I can use to populate tables in my application (tests and data migration) from CSV files using JDBC. I know some databases has this feature but I ...
2
votes
0answers
33 views

Print two-sided flash cards for learning on paper

I have a simple CSV file like this: Question;Answer Capital of Australia?; Canberra Capital of Austria?; Vienna I want to print these questions on DIN-A4 paper. On the front the questions and on the ...
2
votes
0answers
764 views

Extract HTML Tables and convert into CSV file

I am looking for a free tool that can convert HTML tables into CSV files. It should be able to do this with all HTML files of a given local directory or by a set of URLs. It should run on Windows 7. ...
1
vote
2answers
53 views

WYSIWYG CSV editor that logs changes

I have a csv file that I want to edit manually on my Mac. I work with data digitization from PDFs, and sometimes rare errors occur that I just want to fix manually. For the sake of reproducibility, I ...
1
vote
2answers
525 views

Parsing large (30GB) XML into CSV (with Python)

I need to parse a very large XML file of 30 GB into CSV. I have 15 GB of RAM available. I have been looking at some alternatives, for instance xmltodict, which has some sort of Streaming option, but ...
1
vote
2answers
170 views

XML Replacement Tool from CSV

I have XML files where I want to replace certain strings. The replacement source is a CSV file that contains 2 columns old | new ------------------------- OldPart1 | NewPartName1 ...
1
vote
1answer
248 views

Software to make text analysis of csv file

I have a csv with thousands (+5k lines) of entries about reviews. Each line is a review about a specific subject. I am looking for a software to help me to make an analysis about this data. What I ...
1
vote
2answers
117 views

Online spreadsheet webapp that can view 10 million rows

I have a data file with 14 columns and 9,523,125 rows. What online spreadsheet program (NOT A DATABASE!) can view at least 9,523,125 rows? I must be able to: upload the CSV file view it (with some ...
1
vote
1answer
321 views

open source large dbf file converter to csv

I'm looking for a gratis software that can convert a large dbf file called gpmouve.dbf (1 Gigabyte in size) to a csv file. All the options I found are either not gratis or not working correctly. I ...
1
vote
2answers
215 views

Converting Several Thousand .xml files into .csv

I'm looking for a way that I can convert several thousand .xml files into .csv. I've had no problems doing so in small quantities, but the data that I am dealing with is within several thousand ...
1
vote
1answer
101 views

SDF (Chemical Table File) parser in any language

I'm looking to parse a large .sdf file and put it into a CSV. The only software I could find that parses .sdf files is OpenBabel's Pybel, but it won't properly install for my El Capitan, for either ...
1
vote
1answer
138 views

Application for draw financial's graphs from CSV data [closed]

I need to draw many financial's graphs about Bitcoin like there (example): https://bitcoinwisdom.com/ I have CSV data from here: http://api.bitcoincharts.com/v1/csv/ It is possible to draw by ...
1
vote
0answers
12 views

JavaScript/jQuery tool to read data from CSV file to use in API endpoint

I am looking for a recommendation for a JavaScript library or jQuery plugin. I need to take a CSV file, read an id number from one of the columns, and plug that id number into an API GET request to ...
1
vote
0answers
5 views

is there a freeware form creator with import csv capabilities?

I have a sensor that outputs (csv format) logged data like date, time, temperature, pressure, etc) Can anyone recommend a free form creator that I could design graphically the fields I need to be ...
1
vote
3answers
40 views

Program to take spreadsheet data, compute data, charts/graphs for multiple pages that allows user input

I have a spreadsheet that is for a group of clients. Each line of data has information on insurance claims, of which include a client number that is unique to that client. I am looking for a program/...
1
vote
0answers
17 views

.NET Core CSV deserialiser

I read this some time ago, and I assumed that by now all C# based CSV parsers would be using pipes and spans. CSVHelper and TinyCSV don't appear to use spans/pipes, so I was wondering if any other ...
1
vote
1answer
37 views

What language+libraries could I use to parse a CSV/Google Sheets file and then send text messages using some of the parsed info?

The goal is to send the same message to many people (volunteering reminders) but in an automated fashion. The only difference between messages would be the name at the beginning and the target phone ...
1
vote
1answer
39 views

Prepare dataset in CSV for machine learning?

I have a dataset consisting of CSV files (weather data). My issue is to clean the wrong values or empty values before using the dataset for machine learning. Right now I have to copy by hand the data ...
1
vote
0answers
6 views

Software for 3D Processing

I have a project for my work which requires me to take XYZ data from a CSV/Excel file using this data I need to generate a 3D line/spline then using this I need to render small segments of a pipe ...