Comma-separated values: a rudimentary plain-text spreadsheet.

learn more… | top users | synonyms (1)

2
votes
2answers
26 views

Best way to search for a string (text) in >10 large CSV files (250mb each)

I am wondering what's the best way or tool to search for a specific text or string in more than 10 large .csv files. Each file is 250mb in size. My idea was to write a powershell script, since I ...
0
votes
1answer
7 views

Open .csv file with template from XLSTART

I'm testing the program which would create a large .csv file and need to open it with minimum clicks (saving my hands) during testing. The file contains 20+ columns of counters, no formatting ...
0
votes
1answer
23 views

Comma delimited import issues in SQL Server

I am having a problem with SQL Server. I have a table with 42 columns to which there is frequent monthly imports. These imports are from a flat file using the import and export wizard. My problem is ...
0
votes
1answer
35 views

How can i make changes to this file Encoding?

I have these 3 files 21/08/2014 07:15 PM 122 Tw2AWK.csv 21/08/2014 07:15 PM 125 Tw2Notepad.csv 21/08/2014 07:15 PM 119 Tw2REPL.csv C:\myfiles>file ...
0
votes
0answers
8 views

How to customize default CSV format in LibreOffice?

Every time I export my data to CSV (and I do it often) I have tick the "Edit filter settings" checkbox, choose UTF-8 for the encoding, and semicolon for the fields separator manually. I do this ...
0
votes
1answer
42 views

Convert a JSON file to CSV or XLS (Excel) format

I have a number of JSON files which my old charting system will not accept as a data format for import. Is there an easy way to convert these to CSV or XLS?
1
vote
1answer
17 views

excel grid to columns

I have data in an array/grid like this: Name | Group | A1 | A2 | A3 name1 | Group1 | 14.95 | 19.95 | 0.00 name2 | Group2 | 4.95 | 9.95 | 12.95 name3 | Group2 | 49.95 | 0.00 | 0.00 And I need a way ...
0
votes
0answers
14 views

Images in CSV file don't show up in Anki

I'm trying to import a CSV set of notes that include image references into Anki. I have a file with Cloze substitutions and in one note I am using an image in the text: <img src=”duck.jpg”> ...
0
votes
0answers
43 views

How to make my loop omit empty Excel cells while converting to .csv - Powershell

I have some empty cells in my Excel worksheets.How to make a proper statement to make my loop omit them? I tried to do a if(){}else{} loop but it doesnt work properly.I have a powershell v2 so I ...
0
votes
1answer
25 views

CSV compabtility issue in excel

I download a .csv from database and use the file to generate a PDF using a PDF conversion service. However, for specific files, the conversion fails and the request times out. I checked the file type ...
0
votes
1answer
25 views

Excel 2010- long number corruption

I have a set of data, received in .csv format, in which I have a set of long UPRN numbers. I am involved in data matching processes related to new IER voting regulations. When I open the .csv file the ...
0
votes
1answer
18 views

excel 2010 is appending a space to the end of currency field when saving a csv file

Create an Excel spreadsheet with one cell. Put "$1,234.56" (WITHOUT the quotes) in the first cell. Save it as test.csv. Open test.csv file in a text editor, Notepad.exe will work. The file contains ...
1
vote
2answers
51 views

Excel save-as CSV options — possible to change comma to pipe or tab instead?

Is there a way to tell Excel which delimiter to use when producing a CSV, e.g. tab or pipe?
0
votes
2answers
43 views

Excel - take two csv files and map them

I have two csv files. 1 has a list of emails, another has a longer list of emails with first names, last names, address, etc. What I am looking to do is take both of these files and map the emails ...
0
votes
0answers
15 views

How do I change the EOL character when importing a CSV file into Open Office Calc?

I've got a CSV file that has enclosed newline (\n and \r, mixed) characters in its data. Because the consumer of that file is not able to handle that correctly (out of my control) we decided to use ...
0
votes
1answer
60 views

Using multiple data sources in a scatter graph

I have a script that runs something in a loop and writes its duration into a .csv file on a share. The file looks basically like this: "timestamp","duration","ComputerName" "7/8/2014 2:56:03 ...
1
vote
1answer
35 views

Excel column headers export to csv

Just wandering how I can export excel files to csv while retaining the multicolumn headers? I realize that csv does not support this however, I'm hoping that I can have the header name duplicated for ...
1
vote
2answers
39 views

How to convert a Excel row to a single csv text cell (inverse of "Text to Columns)

I have a POS program that allows me to import stock items from a csv file. The problem is that it only accepts a certain csv format. I have a Excel spreadsheet that saves my stock in different ...
0
votes
1answer
33 views

What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?

I have a .csv file which was exported from a proprietary electronic health records database system. I was a subscriber to their service but upon ending my subscription this is how I get to keep my ...
3
votes
1answer
87 views

What's the quickest way to parse and display a `.csv` file?

I am currently using python with matplotlib to display a 440+ k lines .csv but it takes 11 sec to display only one column. My .csv has always the same format. Is there a way to parse it quicker ? I ...
0
votes
2answers
45 views

Exporting CSV file to VCF

I got a CSV file on Excel/Open Office and would like to import them on my iPhone but is proving an almost impossible task. Some people suggested to send the file to myself via e.mail but, when ...
2
votes
0answers
232 views

IE9 not prompting to save downloaded CSV file, opens in Excel

I am accessing a website that generates CSV files when I click a "download" link. Instead of prompting to "save or open", IE 9 is going right ahead and trying to open the returned file in Excel. Since ...
2
votes
1answer
71 views

What is the “sep=” metadata you can adds to CSVs?

While trying to find out how to get CSVs to open correctly in Excel on a Spanish PC (belonging to a customer) I found many answers recommending using sep=, at the top of the file: Easiest way to ...
0
votes
2answers
50 views

Make a formula column for a column in an external data (csv) sheet - How to extend to proper number of rows?

I have an excel file that relies on an external CSV file which I reload from time to time. The csv is loaded into a sheet and a different sheet is used to perform calculations. My question is - How ...
1
vote
2answers
90 views

Shortcut to convert multiple lines to comma seperated values in Sublime

I am using sublime 3 in Mac OS. I want to convert 1 2 3 to 1,2,3 using keyboard shortcuts. or any plugin which can convert vice versa with keyboard shortcut. I don't want to press 10 keys to make ...
-5
votes
2answers
126 views

How do I convert a .csv file to a database?

I have an 8GB .csv file with 6 columns and 202,176,000 rows. How would I convert that to an OpenOffice database(.db) file?
0
votes
1answer
42 views

How to add a prefix to every row of a particular column in a csv file via command line on linux

So basically i am trying to achieve the following.    File before editing.  column-1,   column-2,  column-3,  column-4,  column-5 Row-1-c1, ...
-1
votes
1answer
31 views

Extract chart data from Word document to CSV files automatically

I have lots of charts in a Word document in docx format. If I click on Edit data, I get an Excel window which displays the data. From there, it's easy to export it to CSV. How is it possible to ...
1
vote
0answers
14 views

How can I tell the creation date and creator of a file inserted into a MS Word document? [duplicate]

If I have a Word document and a CSV file was inserted inside the Word document, how can I tell the creation date of the CSV file and the person who created it when I open the CSV file up from within ...
0
votes
2answers
46 views

How to open CSV file with Russian Excel?

Comma is used as decimal separator in Russian locale. This is probably the reason, why Russian Excel is unable to open CSV files: As you see, all data went to first column.
1
vote
1answer
55 views

batch converting from XLS to windows CSV on a mac

I'm using OS X and have lots of these XLS files that I need to format as a batch operation. I need them in "Windows CSV" format, but I can only seem to get them batch converted to Mac CSV... I am ...
0
votes
2answers
50 views

Change number in last row in data seperated with commas in NotePad++

I have rows of data all separated with commas. How can I replace the last numbers after the last commas with the number 5 in NotePad++? For example: How do I replace 9, 17 and 124 with 5 in the below ...
0
votes
1answer
78 views

How to get plain text, colon separated file into spreadsheet with data separated into columns

I received a digest of registrations for events. The fields are separated by colons and in plain text. Can I copy and paste this info into libreoffice spead and get it displayed in columns?
0
votes
3answers
154 views

Splitting a 7 million row CSV by a specific column

How would I go about splitting a very large (7 million rows) CSV file into several different sheets/files by a specific numerical column. It should split into about 10 different files.
1
vote
1answer
269 views

Data Validation of a Comma Delimited List

I need a simple way of taking a comma seperated list in a cell, and providing a drop down box to select one of them. For Example, the cell could contain: 24, 32, 40, 48, 56, 64 And in a further ...
0
votes
1answer
92 views

How to save messages from Gmail to csv file?

I want to know how to save messages from Gmail to one csv file or each message to separate csv file. Txt file is also acceptable. The messages I need have a certain label in Gmail. An example: I ...
0
votes
1answer
37 views

Can I create a cell with enumerated values in a csv file

Can I create a cell with enumerated values in a csv file? For example, I want a cell that can only get the values: a) "value1" b) "value2" c) "value3" Is this possible? PS: I have used this ...
0
votes
2answers
392 views

Delete empty column from csv file with bash script

Looking for some way to look at a csv file and delete columns including the header that have no values in the subsequent lines that follow. Perhaps if I wanted to delete column Test03 from below ...
0
votes
1answer
209 views

Batch file to search for and delete lines containing specifc text in a csv

I have a bat file that searches a directory for specific .csv files names, and copies and amends the lines into a new .csv file. However, some of the lines of the original .csv files are not ...
0
votes
2answers
133 views

CSV File Import Error - Question Marks / Brackets Everywhere

I have a few .csv files that were sent to me, but when I try to import them either as .txt files or as .xml files I only get blocks of question marks (?) and brackets (CONTENTS) of the type that would ...
-2
votes
1answer
84 views

How to convert many .csv files into 1 .xlsx file with multiple tabs [closed]

I have multiple .csv files that need to be in a single .xlsx file, each on it's own tab. I know how to do it manually. is there an automated way do do this? I'm going to need to do this on a monthly ...
1
vote
1answer
37 views

Convert tab separated to a human readable aligned column headers

Let's say I have a spreadsheet with the following example data: I need to display this in plain text but still human readable. When saved in a tab separated format (tsv) it will output something ...
0
votes
1answer
52 views

Control CSV import in excel 2010 [duplicate]

I have a csv with values like this: "a very long value, with a comma","387621937291732193" The number, despite being enclosed in quotes gets turned into a number in excel and shows up in scientific ...
0
votes
1answer
74 views

Importing an excel sheet with many empty cells into R

I have a big excel sheet that have lots of empty cells. I'd like to import it in R. I'm fine if in R, all the empty cells are replaced by "NoData". Replacing all empty cells by "NoData" on Excel and ...
1
vote
1answer
48 views

phpmyadmin CSV files import and export

When I try to import CSV files in phpmyadmin, I get message in green that says "0 rows" but it is nevertheless a success message. I know my data is correct, as it importing fine on another computer. ...
0
votes
0answers
44 views

Batch Script related issue

I have written following script which works absolutely fine on my system. @echo off setlocal enabledelayedexpansion FOR /F %%i IN ('wmic /node:%1 computersystem get Name') DO SET A=%%i FOR /F %%i ...
1
vote
4answers
669 views

How to read values in a particular column of a CSV file in Batch?

I am planning to write a batch script wherein I need to scan the values from a particular column of a CSV file one by one and store them in a variable for further processing. Say, following is the ...
0
votes
2answers
107 views

Creating Comma Separated Values in Batch Scripting

I have written a piece of code in Batch script which is somewhat like : ( wmic.exe /node:x.x.x.x computersystem get name wmic.exe /node:x.x.x.x computersystem get domain wmic.exe ...
1
vote
1answer
644 views

Excel How to make Text Qualifier editable or add a new entry in the existing list?

I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote. Example: "col1","col2","col3" ...
2
votes
1answer
622 views

How to import csv file from url into Google Docs (Drive)

I have a CSV file on a server, available via http. I want to import this into Google Docs to analyse it. Is there a way to do it directly? Trying to do it via iPad, no PC. Trying to avoid the ...