Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

-1
votes
0answers
6 views

Python: search csv file for specific string and store row number for [closed]

My goal is to make this file searchable. My program should prompt the user for the following inputs, in this order: Whether they want to search using an invoice id (input of id) or by a customer's ...
0
votes
0answers
3 views

Easy to use WIndows tool to view HDF5 files and/or convert to CSV

I tried using HDFView (https://www.hdfgroup.org/downloads/hdfview/ ), but it doesn't display the columns clearly. It groups all data columns into an array and removes the column headings when I try ...
0
votes
1answer
14 views

GitHub continuous integration to validate a CSV/TSV file

I have a GitHub project which consists mostly of a TSV file. People often send pull requests, and each time most of the work is to simply check that it is valid TSV. People often break TSV by ...
4
votes
4answers
78 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 ...
1
vote
0answers
5 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 ...
0
votes
0answers
7 views

Is there “everything” like interface async text searching software?

I'm looking for a software or opensource project for creating grafical interface which featured asynchronously searching for sqlite database or CSV formatting file or both. Because I'm leaning ...
1
vote
0answers
8 views

Software to get FOREX data in CSV format

Could you guys recommend me a software that can: Download today's FOREX data only. Forex Currencies must contain Peso, Yen, Chinese yuan (Please correct me if I'm wrong), Euro. (If it can be modified,...
0
votes
0answers
4 views

Wordpress MultiSite CSV importer

does anybody know some plugin for CSV import of posts, pages, etc, that will work on WordPress multisite installation on network admin level? I need to have an importer that can from one place (...
0
votes
0answers
8 views

What's your offline charting software that can import and parse csv data recommendations?

I'm in search of a chart/graph software that can use csv not only to upload data but also parse only the data I need. The catch is this needs to be all offline. I tried using AMCharts and Highcharts ...
1
vote
0answers
28 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 ...
0
votes
0answers
9 views

Hosting Data Online with CORS

I'm looking for a way I can host data files online (CSV, JSON) that is CORS enabled. Does such a thing exist online? Ideally I would like the solution to be free and not to involve a lot of ...
0
votes
0answers
6 views

Looking for well-regarded CSV library benchmarks

I'm trying to find a well-regarded CSV library benchmark, preferably cross-platform, preferably language independent. I'm most concerned about C++ performance on Linux, but would like to make ...
0
votes
0answers
9 views

Looking for R package to sample records from csv url without downloading it

I need to sample records from a variety of Gb plus sized csv url's. This appears to be reasonably straightforward using a curl script with a range argument to sift through the url. This seems to be ...
1
vote
0answers
37 views

How to store 1.5 GB CSV files?

I am searching a solution to store files of 1.5 GB. There is a decade of file per day. I am searching a solution to store those files. I have already done some searches on HDFS and MongoDB. However, ...
0
votes
1answer
11 views

Are there any reliable and supported CSV parsers in C?

I have some algorithms that I need to test on different data sets in CSV format. I was wondering if there is any reliable and supported CSV parser in C that can accept an arbitrary amount of columns ...
0
votes
0answers
8 views

Automaticly import csv table into mysql database [duplicate]

I want to know how to write a script or what program to use to automaticly import data out of different csv tables into my database. Ive got 2 different csv tables with data they get updated every ...
0
votes
0answers
9 views

CSV to concept map: Organizations, funders, and grant recipients

I have a simple CSV spreadsheet with headings like this: Organization,Funders,Grant recipients For the "Funders" and "Grant recipients" fields, I have the names of other organizations in a semicolon ...
1
vote
2answers
58 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 ...
0
votes
0answers
11 views

Utility to create timeline from events

Suppose I have a table (e.g. in a CSV file) of events with start and end times, and names. I want to generate a timeline, which is made up of either intervals in which there's no change (i.e. between ...
3
votes
1answer
55 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 ...
2
votes
1answer
38 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 ...
1
vote
1answer
154 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 ...
4
votes
3answers
50 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, ...
1
vote
0answers
208 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
21 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 ...
0
votes
2answers
856 views

Android app for ledger-cli

I want to use the Ledger command line accounting software. Are there any android apps I can use to generate CSV files of expenses when I'm away from home, which can then be imported into Ledger?
3
votes
1answer
1k views

Modern C++ CSV reader (and maybe writer) 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 ...
1
vote
2answers
30 views

Software to merge CSV files with true/false columns if entry is present

I have multiple separate CSV files that are just a single column list of email addresses, where each file represents a 'tag' associated with that email. I'd like to merge them into one CSV file, such ...
1
vote
2answers
47 views

Intuitive tool to filter multiple CSV files or multiple columns in one CSV file with complex IF requests

I have a large email list I broadcast to, where each subscriber has multiple tags. My email broadcast system lets me download each tag as a separate CSV file containing all tagged email addresses* and ...
1
vote
1answer
199 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 ...
0
votes
1answer
48 views

Matching phone numbers within a vCard or CSV

I have an iPhone with Whatsapp, and a Windows PC with Outlook 2016 that also runs iCloud sync, to sync Outlook contacts with iCloud. Somehow, phone numbers from one contact have been copied over to ...
0
votes
1answer
53 views

JavaScript chart webapp

I'm looking for a webapp that allows me to code in JavaScript based on CSV files and create charts using one of the JavaScript charting libraries like plotly or highcharts. Does such a thing exist? ...
3
votes
2answers
64 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
2answers
4k 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 ...
1
vote
2answers
160 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 ...
2
votes
2answers
126 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 ...
2
votes
0answers
163 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 ...
3
votes
3answers
55 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
202 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
86 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 ...
9
votes
3answers
7k 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
252 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
1answer
50 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
51 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
26 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
36 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 ...
5
votes
2answers
3k 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
1k 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 ...
5
votes
2answers
4k 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
30 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 ...