Open Source Mac CSV Software

This is an Excel based VBA script used to import bulk .VCF files that contain more than 1 Vcard and then convert them to a comma separated .CSV file or Excel xls file that can then be imported into Outlook, Google, or any other application that supports import of contacts using CSV files. This has been written to support VCF 2.0, 2.1, 3.0 and 4.0 formatted files including those with printable encoding (MIME) and has been tested with bulk VCF files from Backupify, Google Contacts (Gmail Contacts), Apple IOS, Samsung Android devices and other platforms. If this doesn't work for you, please email me the VCF file and I'll modify the code to support your specific VCF format. To use, simply download and open the Excel file (xlsm), Enable Macros if prompted, and then select the VCF file you wish to import. Once complete, Excel will create and save new file titled VCFExport.csv that can also be saved in Excel format.

A read-only JDBC driver for Java that uses Comma Separated Value (CSV) files as database tables. Ideal for writing data import programs and conversion programs.

Editor for both Csv files and Fixed width files. There is automatic attribute detection for single record Csv Files. You can edit Fixed Width file and Multi-Record Csv / Fixed width files using a Xml Schema. There is also limited editing available for Xml and PO files.

provide Java Record based IO routines for Fixed Width (including Text, Mainframe, Cobol and Binary) and delimited Flat files via a Record Layout (Cobol, CSV or XML). The source is now available at https://github.com/bmTas/JRecord Projects using JRecord include: * https://github.com/thospfuller/rcoboldi - Cobol File in R * https://github.com/tmalaska/CopybookInputFormat - Cobol files in Hadoop * https://github.com/gss2002/copybook_formatter * https://github.com/gss2002/ftp2hdfs has some code that allows ftping RDW files directly from the Mainframe into Hadoop/HDFS as a mapreduce job or standalone client.

Bots is a complete translator for edi (Electronic Data Interchange). EDI data formats eg: edifact, x12, tradacoms, xml. Mail: http://groups.google.com/group/botsmail Web-site: http://bots.sourceforge.net Wiki: http://bots.readthedocs.io Develop: https://github.com/eppye-bots/bots

csv2odf can create business intelligence reports from csv data sources with output to ods, odt, html, xlsx, or docx documents. It uses a template file that you design to control the layout, fonts, and colors. Just query your database with output to csv (or tsv), then use csv2odf to insert the data into your template to produce a nice looking formatted output. It is a command line tool and you can automate the generation of reports by using scripts and cron. It can be used to create spreadsheets and documents for LibreOffice, OpenOffice, Microsoft Office Excel and Word. It is open source GPL v3 and crossplatform, it can run on most operating systems that can run Python (Python is required). More details, example files, and online manual at http://csv2odf.sf.net.

jdbc2csv is a small command-line tool written in JAVA and can be used on all platforms, for which JRE 8 or higher is available. To connect to a specific DBMS the tool uses its JDBC driver. The result of the executed 'select' query is displayed in CSV format ( different standards are supported ). When there is an error the tool stops with exit code 1 and the error message is output on stderr. jdbc2csv is created with a main purpose to be used in shell-scripts. Relatively easy to configurate, this tool is suitable for queries ‘select’, ‘update’ and ‘delete’. I think that is not suitable for a large number of requests, like 'insert'.

The world's first multi-threaded CSV parser for the browser. Use Papa when performance, privacy, and correctness matter to you. Papa alleviates privacy concerns related to uploading files. Malformed CSV is handled gracefully with a detailed error report. Now the fastest JavaScript CSV parser for the browser. Papa can handle files gigabytes in size without crashing. CSV to JSON and JSON to CSV. Auto-detect delimiter, open local files, download remote files, stream local and remote files, multi-threaded, header row support, type conversion, skip commented lines, fast mode, graceful error handling, and optional sprinkle of jQuery. Specify a step callback to receive the results row-by-row. This way, you won't load the whole file into memory and crash the browser. If you tell Papa there is a header row, each row will be organized by field name instead of index. If you want numbers and booleans, you can enable dynamic typing to do the conversion for you.

CSVboard is a tool for loading CSV files with minimum effort. Since I placed a great importance on its easy of use I implemented a search and filtering engine which provides you with the facility to efficiently find specified rows within a table. DON'T FORGET TO READ THE QUICK TUTORIAL!! Features: Lightweight and portable Set and reset title with Ctrl+q and Ctrl+w Auto-set column widths Auto-detection of delimiters Load files by Dragging&Dropping XML export Powerful search and filtering engine CSVboard was written in Java and JavaFX and actually it is a result of some recycled code collections. I experimentally developed during my time as a hobby programmer. So if you find any dysfunctionalities, errors, bugs, or the like do not hesitate to contact me. I'm further going to publish my code at Github in the near future so that everybody has the chance to improve my code.

CSV Comparator is a tool for comparing files which contain CSV-Data. It was created for performance engineers to be able to have a easy way to compare data from two testruns and be able to automate the comparing process of various files with scripts. There is a command line tool as well as a user interface. In case you need to compare .xml-Files you can convert them to .csv-Files with my other project CSV Transformer. The advantages by using CSV as input and output are the following: - Many applications allow an export of its data to CSV or Excel(were it could be saved to CSV) - It is possible to pre- and postprocess the data, e.g removing version numbers before comparing - It is easy to create CSV data from logfiles and other resources by using unix tools like sed or awk - CSV can be loaded into other applications, especially Excel, were it can be formatted by macros for analyzing.

Java XML to CSV (XML2CSV) generic conversion facility. Flattens one or more similar XML files into CSV projections. I made it in order to extract data from big XML files and gather them in files more easily opened with a spreadsheet because I didn't find anything adapted to my needs over the Internet when I needed to (Java + truly generic + self-contained algorithm + Unix like command line options + efficiency). It is packaged as an auto executable Jar for convenient command line execution but might as well be interfaced directly by a Java class as part of a broader [yet non commercial] software. It handles attributes, repeated elements, and so on, and produces results which level up with what spreadsheets generate when they import native XML (at least in its most extensive execution mode). Please refer to the documentation for further details (PDF doc, Open Office Writer doc, and API doc). This free software is released under the GNU GENERAL PUBLIC LICENSE Version 3.

Super CSV is a fast, programmer-friendly, open-source library for reading and writing CSV files with Java. PLEASE NOTE: As of January 2015 we have now moved to GitHub (https://github.com/super-csv/super-csv). This SourceForge page will remain, but with limited functionality (please go to GitHub to report issues and for project downloads). It is highly configurable, and supports reading and writing with POJOs, Maps and Lists. It also has support for deep-mapping and index-based mapping with POJOs, using the powerful Dozer extension. Its flexible 'Cell Processor' API automates data type conversions (parsing and formatting Dates, Integers, Booleans etc) and enforces constraints (mandatory columns, matching against regular expressions etc) - and it's easy to write your own if required. Super CSV is actively maintained, and the developers are ready and willing to help out if you get stuck :) Please check out the project website for examples and help getting started

A CSV editor written in Java 1.6 Developed using NetBeans IDE 6.0.1

This tool is a small tool to upload a csv file to a database. This tool can analyse a CSV file and it can determine the field lenght and the column name.

Simple tool for converting CSV file. You can easily change file encoding, escaping or separator character. You can split the file into more smaller files as well.

"Database to CSV" allows to back-up data from database(Oracle, MySQL, SQL Server) in the form of CSV files. Each table data is stored in a separate CSV file. It also allows to load data from CSV files into the database. Program can be run from UI or from command line. There's one more advanced feature which allows merging of data from CSV file to Database. It is only available from command line. (It will take foreign keys and unique keys into consideration and then try to insert data with minimum change as possible). Note: 1) If tables do not exist, this program will not automatically create table while loading data from CSV.

Library for parsing of csv files. The project's focus is the flexibility to parser the csv files based at SAX and DOM methods on XML.

OSM XML to CSV conversion. POI only, polygons (and polylines, but not recommended) are approximated by centroid. Result is a 3-column table with lon, lat and value (for a particular key to be chosen beforehand).

This converter bridges from the .ahn file format into GEDCOM 5.5.1, It's a command-line tool written in Java. AhnConvert allows family data, laboriously grabbed decades ago surviving into state-of-the art genealogy software products. The software "Familien Chronik" by Reiner W. Dudde was a genealogy software published by Data Becker as part of the "Goldene Serie" series, back in the 1990's. Especially in Germany this tool penetrated the market to some extent. Generating a project and filling in all relatives and ancestors resulted in an .ahn file. Unfortunatelly, this format cannot be imported by any of the current genealogy software. On the other side, GEDCOM can be read without problems by most of today's programs.

Still struggling with Excel to setup your pick and place machine ? Cad2Board reads component mounting information from Eagle, Altium Designer and Mentor Expedition PCB designs. Component or component groups can be assigned to feeder slots by drag and drop. Any modifications for PCB population can be defined to generate PCB variants, consider rotations from unusual tape and reel packaging or to account in advance for CAD library or PCB design bugs. Generated setup data is stored in a seperate project file. Succeeding PCB revisions what contain redesign changes can be merged with existing project setup data. Inconsistencies are highlighted to solve them by new assignements and unused feeders can be cleaned up with a single push. Finally a machine program is generated in Heeb HE50 format and downloaded to the machine interface.

You have been struggling with SPSS databases when you needed to use excel? Well, this file (or the VBA module attached to it) will help you: you paste your CVS file format into one sheet, and the bulky strings will all your values will gently be split into one value per column by a custom excel function, The function takes into account that some values might be strings with comas that should not be split into different variables. The custom function should be usable for other types of files, it basically disaggregare a string into values separated by a standard character (by default the coma, but can be changed) and ignores separation characters that are within "string identifier" characters (by default the " ). It is a very simple excel file, you need to allow the macros to use it.

A CSV mass editor for advanced users, written in PHP. Its purpose is not to edit the data, but to mass manipulate it: re-arrange, join and delete columns, join rows, search and replace using regexes and a bit more.

Map CSV records to Java Objects and back again (a la hibernate).

Convert/manipulate csv files, Java / GUI Swing; GPL3. Uses Ostermiller Utils (CSV Java, http://ostermiller.org/utils/CSV.html) Alows to define rules for the conversion (copy or replace the contents). Useful eg. for serial mail.

CSVChecker is a python utility designed to check CSV file for field length and format. Configuration is made on a field basis through YAML configuration file.