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
4
votes
5answers
312 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 ...
1
vote
1answer
393 views

Excel to CSV Java library

I am looking for a Java library (preferably in Maven Central) that can read XLS and XLSX and save the sheet to CSV. I am looking for something higher level than poi and jxl as neither of these have ...
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 ...
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, ...
1
vote
0answers
304 views

Tool for REST API JSON response to CSV

I work with a platform that has a robust REST API able to return reports as JSON array. I am looking for a tool (not a library) that would be able to query REST APIs which authenticate with BASIC ...
0
votes
3answers
156 views

CSV to SQL Insert Statement Software

I am looking for software to assist me in the process of converting CSV files into insert statements for MySQL. The software would ideally have the following characteristics: Be able to convert a ...
0
votes
1answer
55 views

Tool for migrating oracle table to CSV file

I want to migrate data from oracle table to a csv file. Is there any tool for this migration?
2
votes
0answers
34 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 ...
0
votes
0answers
39 views

Program for exporting data to CSV files

I'm setting up a WooCommerce store, and I'm after an application for Windows that will allow me to put together products and then export to a CSV file for upload into WooCommerce. I'm thinking the ...
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 ...
1
vote
1answer
2k views

Recommendation for personal database (Bento replacement) for iOS and OS X

Looking for a personal database recommendation for iOS and OS X – basically a replacement for Bento. It needs to be able to have cloud sync, so I can do work on multiple devices. Two options seem to ...
8
votes
3answers
7k 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 ...
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 ...
4
votes
3answers
893 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, ...
2
votes
3answers
920 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 ...
1
vote
0answers
23 views

Wordpress CSV or Excel Import and Display Plug-in

I am looking for a general purpose or specialized Wordpress plug-in that would enable the following basic functionality. Import a CSV file say 10 columns wide and up to a 1000 rows. I would want the ...
3
votes
1answer
289 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 ...
2
votes
0answers
767 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
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 ...
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:...
3
votes
1answer
108 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 ...
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 ...
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 ...
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 ...
5
votes
3answers
628 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 ...
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 ...
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 ...
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 ...
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 ...

1
2