Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.

learn more… | top users | synonyms (1)

0
votes
1answer
412 views

Export an entire Access (accdb) database to csv/txt

There is no option to export the whole db, rather Access only allows export of one table at a time. I'm not familiar with any VB scripting so how would I go about doing this? CSV must be exported ...
1
vote
1answer
2k views

How to apply a 'comma separated list' as a filter in Excel?

I have a stock-list of books and would like to filter the stock data only with selected publishers. Is there a way I can provide a 'comma separated list' in the filter? I tried the 'Advanced ...
1
vote
2answers
258 views

How to import this data set into excel? (column headings on each row delimited by a colon)

I'm trying to import the following data set into Excel. I've had no luck with the text import wizard. I'd like Excel to make id, name, street, etc the column names and insert each record onto a new ...
1
vote
0answers
418 views

Converting a DWG/DXF to CSV or Excel

I'm using ZWcad and i need to get the coordinates of hundreds of blocks into a excel sheet or .CSV file so i can import that into the GPS hardware. I know there are plenty of tools for autocad, i ...
3
votes
1answer
3k views

CSV files cant store special characters?

I have read several other questions on this subject but none have an answer which fixes my problem. I have an execel file which is in russian and I need to convert it to CSV without it losing any of ...
1
vote
0answers
139 views

What is the best way for inexperienced users to browse and filter data in large CSVs?

I'm looking for a way to browse through some CSV unicode-encoded files. These files have relatively large number of rows (2-3 millions) and 10 columns tops, with columns being numerical, small text ...
1
vote
0answers
38 views

How to make just one text column be unquoted in final CSV?

I'm using OO calc and i have one column with phone numbers that have leading 0s, which are vital for the number to be valid. I can format the cell as text but i do not want the numbers to be quoted ...
0
votes
2answers
2k views

excel: merging to data sets based on a common field

I have two excel .csv files that have a single numerical field in common, FIELD_A. What I'd like to be able to do is to leverage this common field in order to merge data between the two, so that I ...
0
votes
1answer
530 views

How to automatically update Google Calendar from shared csv file

I am creating a regular snapshot csv file from a proprietary calendar program. The CSV file is formatted so that it can be imported into Google Calendar. I'm wondering if there is a way to put this ...
2
votes
1answer
1k views

Merge CSV files to one Excel file in different sheets

I want to merge CSV files to one Excel workbook in different sheets. I want each file in one sheet with the CSV file name as sheet name.
0
votes
0answers
62 views

export windows file structure into .csv with date parameters

My real goal is to get a list of the files in my windows file structure into Access, but as there are over 500k files the various bits of VB code I've tried all take a very long time and is not ...
1
vote
1answer
326 views

Macro to import CSV file into Excel 2010 without losing leading zeroes or cell formatting

We have a UI based application that exports data out of a form into a CSV file. The data entered may have leading zeroes in some numeric fields and/or text with line feeds in other fields. ...
1
vote
1answer
1k views

Excel puts a comma-separated set of values in one column

I have a file which is clearly comma separated but when I open it in Excel 2007 it puts all the data in a single column. I think the problem is with my Windows localization (set to Dutch) but I am not ...
8
votes
2answers
35k views

How to get Excel to interpret the comma as a default delimiter in CSV files?

I have a number of .csv files. Some of them are comma delimited, some are tab delimited (maybe they should be called .tsv ...) The csv extension gets associated with Excel when Excel is installed. ...
3
votes
3answers
303 views

regex help - ignore a char if it's in quotes

We have a web-based app at work where you can enter a regex into a search box and it returns the matches from a database Here's a sample of what the database entries might look like. They're comma ...
1
vote
1answer
174 views

Generate CSV/TXT file from named zone file

I am in need of generating a csv/txt file from a zone file on a named DNS server. For examples I would like to generate a list of the hostname and IP from the zone file From this monkey A ...
0
votes
1answer
846 views

Having formatting problems when exporting table from phpMyAdmin

I'm having some trouble in exporting some data directly from phpMyAdmin. I'm selecting a table in phpMyAdmin, from a specific database, and then I'm exporting that table in Excel based CSV format. ...
2
votes
1answer
146 views

Any way to have Excel 2010 treat a quoted value “08540” as text not number when opening a CSV

I have a CSV with data like this: "08540",1,"PRINCETON","NJ" I know that it is possible to specify "Text" when using the Import Wizard and defining columns. But is there a way to tell Excel to ...
0
votes
1answer
134 views

Unintelligible result opening csv in excel

When I open a .csv file in excel this is what is showing up: Maxtor Encryption ver 2.0.1.1.0 ³§o rkDV’)cÿA®T7B‡LôŠì£\% i¼r1 ØÕë—„×½é¿wjd ´Íâ¿…Öö?HÐ)vM!W«Va<žÒ LåRpµI©ô ...
0
votes
1answer
416 views

Using Command Prompt to create Retina Vulnerability Report CSV

I have scanned several computers on my network which have been flagged as needing certain fixes. I am able to generate reports in Retina fine using the GUI report view, however, I would like to be ...
1
vote
1answer
131 views

Database workflow advice? [closed]

I've got a product database that I need to update a couple of times a week and am looking for some advice on what workflow I should setup. I can export my database from my online store as a CSV, I ...
2
votes
2answers
186 views

Split view of a CSV in Bash

I'm trying to view large CSV files in a terminal (not huge; simply more than can be displayed in the terminal window at once). The best solution I've currently got is this: column -s, -t -n < ...
1
vote
3answers
113 views

Generate an alphabetic index from a spreadsheet

I have a text file of lecture topics from my physics class that looks like this: 1/14,Galilean relativity,Einsteinian relativity,Minkowski space,Henri Poincare,, 1/16,Lorentz transformations,Velocity ...
2
votes
1answer
11k views

How can I convert a .txt file to .csv format without using Excel?

I have a .txt file consisting of very long paragraphs, with a single newline character separating each paragraph. I would like to convert this to a .csv format so that the file effectively has one ...
-3
votes
1answer
363 views

Deleting the first column of csv via batch commands [duplicate]

Is there a way to delete the first column of a csv using a batch command file? I have data in this first column but I want to get rid of it and output a new file starting at the 2nd column. Thanks!
1
vote
0answers
588 views

Import a CSV File in a database w/ powershell jobs

I am trying to import a CSV file into a database with PowerShell but so far I have no luck. This is my code (based on this source): Start-job -Name 'ImportingData' ` -InitializationScript ...
0
votes
2answers
2k views

How a batch file overwrite contents of output each time?

Basically I have this batch file below, which will return the first x rows from the input .csv file parameter. However, the only issue now is that this batch file will be called several times to ...
2
votes
3answers
5k views

Excel CSV import treating quoted strings of numbers as numeric values, not strings

I've got a web application that is exporting its data to a CSV file. Here's one example row of the CSV file in question: 28,"65154",02/21/2013 00:00,"false","0316295","8316012,8315844","MALE" ...
1
vote
1answer
736 views

Adding Multiple users from .CSV via batch file

I wrote the following in a batch file start cmd.exe /k net user test1 1qaz2wsx!QAZ@WSX /add /y But I have to add a large number of users and passwords. I have them all in an excel file, is there ...
1
vote
4answers
4k views

Can I use a batch file to remove blank columns in a .csv

I have nine columns in my current .csv file, however, the 2nd and 3rd columns are blank and I want to get rid of them. Is there a way to use batch commands to remove these empty columns from my .csv ...
2
votes
2answers
602 views

Import-CSV with powershell using a variable path

I am trying to import a CSV file with powershell in a database, with the path defined in a variable. But it doesn't seem to work. $path = "C:\Users\Admin\Desktop\TestFolder\file.txt" Import-CSV ...
0
votes
1answer
691 views

Export the first three rows of a .csv into another .csv using batch commands

I have a .csv file with a number of rows but I only want the first three rows and none of the rest. How can I use a batch file to export those top 3 rows of my .csv file into another file .csv file? I ...
0
votes
1answer
247 views

Get unique comma separated values from list of comma seperated values

I have a list of csv in a single cell, and I need to get the unique values from that list and put them in another cell. For example, in one cell I would have: DIV-154, FOD-371, UDL-913, DIV-154 And ...
2
votes
1answer
537 views

How to display/monitor the tail of a growing CSV file in tabular format?

I am looking for a way to display an open, "live" CSV file under Windows 7. For example, I have a proprietary program running that is generating log data in CSV format. I'd like to keep an eye on what ...
3
votes
2answers
9k views

Import CSV file into Exchange Mail Contacts using powershell without duplicates

The Problem: A good number of people's info was added to my "Mail Contact" list in Exchange Management Console, but not all. Summary: I'm attempting to add a list of several hundred people from a ...
2
votes
6answers
7k views

Editing CSV files in Ubuntu

What is a good way to edit CSV files in Ubuntu? The files look something like this: This,is,data,with,a,header 2,2,3,4,, 1,,3,,6,6 ,5,3,5,5,6 1,2,,,, 1,2,3,4,8,6 1,,9,,5,9 -1,,3,4,5,6 1,2,0,4,5,6 ...
0
votes
2answers
3k views

How to configure Windows to open CSV files directly in the browser?

How can I configure Windows and/or Internet Explorer so it opens online CSV files (files on the internet) directly in the browser without asking to download them? I want the same behavior of TXT ...
-5
votes
1answer
876 views

How can I upload my CSV file and keep fonts and bold lettering [closed]

Every time I save my CSV file it deletes the fonts / underlines etc. In my website I would like to have bold lettering, underlines preserved. I'm using CSV Import PRO and all the options i have are: ...
0
votes
0answers
325 views

Excel csv encoding default

Ok here's the deal I exported a csv in UTF-16 format via PHP and open it in excel...All the encoding works perfectly. My question is, suppose I edit this csv and then just hit save in excel and ...
4
votes
3answers
4k views

Increase size limit of data import from csv into Excel

I have a load of data in a csv file that I'm importing into Excel, most of it is fine, but one of my columns contains up to 1000 characters of data. Unfortunately, Excel has taken it upon itself to ...
3
votes
1answer
3k views

Export Office Excel table to csv using a macro

I'm using Excel Tables in Excel 2010. I would like to quickly export the contents of these tables to *.csv. My current workflow: 1. Select table manually 2. Copy the contents into a new workbook ...
0
votes
2answers
421 views

windows text editor that allows csv/tsv data column sorting

I thought I remember reading that there is a text editor that exists for windows that allows the sorting of data, treating the csv/tsv similar to how it is treating when one sorts in excel. Any ...
1
vote
2answers
2k views

Edit csv file with Excel without reformatting

I have some csv data file that looks like this 1,2,3 5,6,7 I open it with Excel 2010, do some change (change some value, delete a column, or anything), and then re-save the file still as csv. But ...
2
votes
1answer
250 views

Print from CSV file, row by row

I have a CSV file. I need to print this file row by row. For example, each row contains name, surname, email, profession and so on, many columns. First row contains the column titles. I would like to ...
0
votes
3answers
2k views

Batch script to append record to csv files

I have a bunch of stock data in csv's that I am backtesting trading strategies on. The problem is that my strategy buys the open market price if a signal was found yesterday, unfortunately my data is ...
1
vote
2answers
4k views

Open a .csv file in Excel and have it update whenever .csv file changes

Hi I'm working with some web scrapping and the data on my csv files will be constantly changing. I want to open these files on Excel to view and also have it refresh whenever the csv source changes ...
0
votes
5answers
6k views

How to prevent the number increase in the excel for Autofill?

I want my column to look like number 30/31/32/33/34 30/31/32/33/34 30/31/32/33/34 30/31/32/33/34 ...... eg: The content in each cell is 30/31/32/33/34. I want to fill all of the cells in the column ...
0
votes
1answer
129 views

universal text data format converter

I'm looking for a bidirectional file serialization format converter: xml, json, csv, sql table, excel, html, etc. I've only found tools that performs unidirectional conversion from one format to ...
3
votes
1answer
215 views

Outlook 2007 export contacts including list info

I want to export all contacts in outlook 2007 for import to gmail. Many of the contacts are members of various distribution lists, but there are no info in the exported csv-file as to which ...
0
votes
2answers
136 views

Is there any way of preventing .csv files being converted into excel format

I'm trying to work with an automated testing tool which can use .csv files as its data sourse. After saving a notepad file containing a number of fields and data seperated by commas as .csv it ...