Questions tagged [csv]

CSV (comma-separated values) is a text file format where each line 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
2 votes
0 answers
10 views

Data integration or ETL tool with API as destination

I am looking for a simple data integration or ETL tool to integrate data (e.g. as CSV) into our platform. There are many ETL tools (like Fivetran, Hevo, Talend, Airbyte, etc.) but they are very ...
  • 121
1 vote
0 answers
28 views

Using Java, what other libraries are avalible for easily converting CSV files to DBF (dBase/xBase)?

I am currently writing an android app that interfaces with database files and was considering a way to export data neatly without errors. Currently every library I can find has one issue or another ...
1 vote
0 answers
18 views

An open source software/ecosystem I can use to quickly create faceted search UIs for CSV files in the range of 20 - 100 GBs?

Problem I have some large CSV files between 20 GB to 100 GB. The data can be useful to a lot of non technical people, each of whom will only be interested in a slice of data. I could distribute the ...
  • 11
2 votes
0 answers
45 views

Command line tools to do a diff of csv/tsv files?

I work on a bioinformatics tool that produces large TSV files with many (~100) and long (~5-200 char) columns. Getting a whole line from a normal diff is overwhelming. It's more important to have the ...
1 vote
0 answers
22 views

Raw data spreadsheet

I use little tables that contain mainly text on a daily basis. I currently use LibreOffice Calc to view and edit them, with the Autofilter feature for sorting and filtering. However, spreadsheets are ...
  • 11
2 votes
1 answer
142 views

Searching in .csv files on Android smartphone

I am looking for an app that allows easy search within .csv files. Minimal features can somehow read .csv files allows to search in them (searching for exact match of string in any column) is ...
1 vote
1 answer
353 views

Command Line Program for Converting XML to CSV

I need a software for converting xml files to csv. It has to run on Windows Server 2012 / 2016 on command line. The software must have good support (updates, live help etc..)
  • 111
2 votes
0 answers
53 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 ...
0 votes
0 answers
23 views

Is there any API service that converts a CSV file (inside url) to a simple table on a webpage so I can call an API to take a screenshot of this page?

The project will be running automatically in Google App Script, which is based on Javascript.. I have a URL that when I open, downloads a CSV file to my computer. But instead of downloading it to my ...
1 vote
0 answers
24 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 ...
  • 111
8 votes
3 answers
1k 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 ...
  • 183
0 votes
1 answer
98 views

Java compare CSVs in Junit tests - if failure, give specific line(s) of failure

I've got some Junit tests that compare large blocks of JSON using a framework called JsonUnit. When there is a failure in the test, it's typically just a few lines in a 1000+ line JSON. The JsonUnit ...
1 vote
2 answers
85 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
0 answers
6 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 ...
  • 111
2 votes
2 answers
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 ...
user avatar
0 votes
1 answer
36 views

Open and visually browse large CSV files [closed]

Which software do you recommend to open and visually browse large (>2.5 GB) CSV files?
  • 131
3 votes
3 answers
50 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, which includes a client number that is unique to that client. I am looking for a program/...
1 vote
2 answers
1k 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 ...
0 votes
1 answer
66 views

Data validation library in Python and user defined rules

I'm starting a solution that matches data rows (importing a csv file initially) from created rules. It would be like an Excel filter solution with some specific options for date and number formats. ...
  • 103
0 votes
3 answers
280 views

"MailMerge" for CSV + Markdown

I remember from my MS Office days the Mail merge feature: I had a table in an Excel sheet, a template in Word and Mail Merge created a Word document from each row in the Excel sheet. I now have ...
  • 225
1 vote
1 answer
292 views

Good, free software for candlestick charting (using CSV or text input file)

I am looking for Desktop software which takes Daily Open/Close/High/Low (and possibly Volume) input as csv or any text format. I already have Excel but I found several shortcomings with Excel If ...
1 vote
0 answers
21 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 ...
  • 11
0 votes
0 answers
23 views

Fastest framework / method to perform multiple calculations on 11m rows x 12 columns of data from a csv

I have a CSV that is supplied from a 3rd party every morning. That csv requires processing, and I'm looking for recommendations as to how those familiar with data science / big data management would ...
  • 101
-1 votes
1 answer
13 views

Uploading csv files to an R file without having excel

I'm starting an internship where I'll be uploading different csv files into some R files I'm working on. Problem is, I don't have excel and can't really pay for Microsoft Office. Are there any options,...
1 vote
1 answer
51 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 votes
2 answers
35 views

Convert CSV file to another layout

I would like to change the layout of a input CSV file and change the layout of values. So the initial Format has headings like: - Customer Zone Type 1 2 3 4 5 6 7 8 9 10 11 12 Under the number ...
  • 11
1 vote
1 answer
42 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 ...
0 votes
1 answer
39 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 ...
  • 19.1k
20 votes
13 answers
17k 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 ...
  • 301
1 vote
0 answers
7 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 ...
1 vote
0 answers
14 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,...
  • 111
2 votes
0 answers
50 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 ...
1 vote
0 answers
41 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, ...
  • 111
0 votes
1 answer
15 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 ...
  • 103
1 vote
2 answers
165 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 ...
  • 19.1k
3 votes
1 answer
115 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
1 answer
72 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 ...
  • 121
1 vote
1 answer
387 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 ...
  • 137
4 votes
3 answers
57 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, ...
2 votes
1 answer
540 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
0 answers
28 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
3 answers
2k 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?
4 votes
1 answer
10k 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,081
1 vote
2 answers
48 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
2 answers
111 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
1 answer
276 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 ...
  • 113
0 votes
1 answer
58 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
2 answers
95 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? ...
  • 113
4 votes
2 answers
94 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 ...
user avatar
5 votes
3 answers
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 ...