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
2
votes
0answers
22 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
0answers
18 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
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 ...
5
votes
3answers
98 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 ...
0
votes
1answer
14 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 ...
0
votes
0answers
11 views

A tool or addon to export excel as CSV including image cell

I'm looking a tool or addons for any of Online Excel Live, Google SpreadSheet, OpenOffice and LibreOffice to convert my excel which includes image as a cell into CSV format which will contain image as ...
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 ...
0
votes
0answers
20 views

Web CSM for database and search

I'm working with a small database built from spreadsheets, so I have several CSV files that may be related through column keys. I want to upload this work to a webpage and allow people to search ...
0
votes
0answers
46 views

Terminal editor for CSV files

I want to edit a CSV file - in a terminal session. Of course I can edit it as a plain text file, and that will work, but - I want to see it in a tabular format. I don't want nor need full-scale ...
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 ...
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 ...
0
votes
1answer
27 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?
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
2answers
526 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
1answer
25 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. ...
0
votes
3answers
148 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 ...
0
votes
1answer
107 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
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 ...
0
votes
0answers
14 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 ...
-1
votes
1answer
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
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
votes
2answers
26 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 ...
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 ...
0
votes
1answer
24 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 ...
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 ...
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 ...
1
vote
0answers
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,...
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 ...
1
vote
0answers
40 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 ...
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 ...
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 ...
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 ...
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 ...
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, ...
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 ...
0
votes
3answers
1k 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
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 ...
1
vote
2answers
35 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
64 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
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 ...
0
votes
1answer
52 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
2answers
84 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
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...