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
0 votes
2 answers
47 views

Recommendations for a CSV editor (for non-programmers)

At my company we have a data warehouse which imports some .csv files that are directly supplied by the business side. Some of these are manually created from Excel files, some of them are .csv files ...
Alex's user avatar
  • 101
2 votes
0 answers
11 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 ...
Dennis's user avatar
  • 121
1 vote
0 answers
35 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 ...
cellswithincells's user avatar
1 vote
0 answers
20 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 ...
Hashir's user avatar
  • 11
2 votes
0 answers
97 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 ...
Cornelius Roemer's user avatar
1 vote
0 answers
23 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 ...
Myvh's user avatar
  • 11
2 votes
2 answers
222 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 ...
reducing activity's user avatar
1 vote
1 answer
615 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..)
Rosebud's user avatar
  • 111
2 votes
0 answers
83 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 ...
jcthomas113's user avatar
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 ...
Digital Farmer's user avatar
1 vote
0 answers
28 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 ...
apex2022's user avatar
  • 111
10 votes
4 answers
3k 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 ...
Harper's user avatar
  • 203
0 votes
1 answer
164 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 ...
user952342's user avatar
1 vote
2 answers
107 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 ...
roussanoff's user avatar
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 ...
Rodrigo's user avatar
  • 111
2 votes
2 answers
31 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
40 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?
Stücke's user avatar
  • 131
3 votes
3 answers
51 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/...
J. Jordan's user avatar
1 vote
2 answers
2k 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 ...
Vladimir Vargas's user avatar
0 votes
2 answers
89 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. ...
Danmaxis's user avatar
  • 103
0 votes
3 answers
342 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 ...
halloleo's user avatar
  • 305
1 vote
1 answer
408 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 ...
user93353's user avatar
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 ...
Stevey's user avatar
  • 11
0 votes
0 answers
24 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 ...
anakaine's user avatar
  • 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,...
Sophie Wulfing's user avatar
1 vote
1 answer
56 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 ...
kevinlinxc's user avatar
-1 votes
2 answers
44 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 ...
Ualati's user avatar
  • 11
1 vote
1 answer
44 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 ...
Jacques De Mongaillard's user avatar
0 votes
1 answer
61 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 ...
Nicolas Raoul's user avatar
  • 19.4k
22 votes
14 answers
20k 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 ...
Vish_er's user avatar
  • 321
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 ...
user51297's user avatar
1 vote
0 answers
16 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,...
Mr.J's user avatar
  • 111
2 votes
0 answers
52 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 ...
Marco Bozzola's user avatar
1 vote
0 answers
42 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, ...
Thomas R's user avatar
  • 111
0 votes
1 answer
17 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 ...
LeoVen's user avatar
  • 103
1 vote
2 answers
188 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 ...
Nicolas Raoul's user avatar
  • 19.4k
3 votes
1 answer
118 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 ...
Stefan Berger's user avatar
2 votes
1 answer
93 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 ...
Cloud's user avatar
  • 121
1 vote
1 answer
430 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 ...
Andy K's user avatar
  • 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, ...
Ellen Spertus's user avatar
2 votes
1 answer
685 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 ...
Mike Miller's user avatar
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 ...
Jeff Price's user avatar
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?
John L. Godlee's user avatar
4 votes
1 answer
12k 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 ...
einpoklum's user avatar
  • 3,149
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 ...
Benny Lewis's user avatar
1 vote
2 answers
119 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 ...
Benny Lewis's user avatar
1 vote
1 answer
290 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 ...
anvd's user avatar
  • 113
0 votes
1 answer
59 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 ...
user28951's user avatar
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? ...
Harry's user avatar
  • 113
4 votes
2 answers
97 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