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.
82
questions
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 ...
- 161
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,042
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 ...
- 121
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 ...
- 101
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 ...
- 101
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 ...
- 123
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 ...
Karan
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/...
- 31
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 ...
- 111
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 ...
- 71
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 ...
- 111
-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 ...
- 11
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, ...
- 141
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 ...
- 121
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 ...
- 21
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?
- 121
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 ...
- 131
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 ...
- 131
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 ...
- 21
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 ...
Berne
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 ...
- 313