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

learn more… | top users | synonyms (1)

0
votes
1answer
16 views

CSV File saving as Creo Pro Versioned File

This is an odd one, I'm saving an Excel file as a CSV file, which is the required format I have to send this data in as. However when I save the file, it shows in the Directory as a Creo Pro Versioned ...
2
votes
0answers
22 views

Newlines in description of imported csv in Outlook Calander

I have exported a list of birthdays from excel to csv. Now I want to import them in Outlook as calander items. Everything works fine exept I can't do newlines in the desciption. I've already tried to ...
0
votes
0answers
8 views

xls2csv skipping bool values when converting

I'm attempting to use catdoc -> xls2csv on an Ubuntu 14.04.1 OS to convert and .xls file to a .csv file. All of the values are converting correctly except in the last column which contain TRUE/FALSE ...
1
vote
3answers
31 views

Excel: How to skip specific rows when importing a CSV

I want to skip the header and last rows when importing a CSV into Excel, just like I can skip specific columns. Is there a way to do this?
0
votes
1answer
27 views

Postbox/Outlook 2013: Strange Contact Import Behaviour

I'm experiencing a very strange error with regards to importing contacts that were exported from the Postbox 3 address book. The CSV file itself is fine - everything maps out nicely in Excel, but ...
0
votes
0answers
8 views

Birt report export to csv

I am trying to export a CSV report by running a simple classic cars example in BIRT 4.4.0. I gave the column Names as Name, Phone, City, Country in the report where as the exported report has the ...
1
vote
2answers
30 views

Changing DateTime format in multiple CSV files

I've got multiple csv files with this structure: text, text, 01/27/2001 01:00:00 PM I need to update ALL csv files with this datetime format: text, text, 27-Jan-2001 13:00:00 Is there a known ...
2
votes
2answers
35 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
14 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
28 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
40 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
10 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
82 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
20 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
23 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
53 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
28 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
27 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
84 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
3answers
55 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
19 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
86 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
36 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
41 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
40 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
102 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
72 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
389 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
81 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
57 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
107 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
197 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
51 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
35 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
54 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
72 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
105 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
230 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
382 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
128 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
41 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
510 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
277 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
148 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
106 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
40 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
56 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 ...