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

learn more… | top users | synonyms (1)

3
votes
1answer
1k 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 ...
3
votes
1answer
197 views

What is the “sep=” metadata you can add 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 ...
2
votes
1answer
733 views

Excel and tab delimited files, using Carriage return and Line Field

How do you introduce a CR and LF into a cell so when it is saved as a Tab delimited text file, the importing program will recognize the CR and LF?
3
votes
0answers
176 views

Default font and cell padding when opening files in LibreOffice/OpenOffice Calc

I've seen solutions for setting a default font when creating new files. What about a default font (and cellpadding) when opening an existing CSV file? LibreOffice seems to always default to Liberation ...
2
votes
0answers
36 views

How to output a CSV file from a matrix of Excel formulas using multiple files?

I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...
2
votes
0answers
45 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 ...
2
votes
0answers
78 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 ...
2
votes
0answers
579 views

I'm exporting contacts from Outlook 2007 to CSV file and getting question marks instead of characters

I need to create a CSV file that includes my Outlook 2007 contacts. The contacts include English and Hebrew (UTF-8) characters as well. When I export the contacts into a CSV file (Windows - with ...
2
votes
0answers
225 views

How to setup a CSV web datasource

In Excel, I can import a CSV from the web as text by simply pasting in the URL as a file name, but when I ask Excel to update, it has stripped the URL and tries to find a file on the local hard drive ...
1
vote
0answers
15 views

How do I suppress the “file format and extension of MyFile.csv” do not match."?

I'm opening a lot of csv files using Excel recently and am repeatedly receiving the warning:- The file format and extension of MyFile.csv do not match. The file could be corrupted or unsafe. ...
1
vote
0answers
41 views

Properly extracting from an array

I have a CSV with one column, numbers formatted as 111-0000, that I'm reading in to process one at a time. I'm trying to import the column of information from the CSV, but I'm having trouble figuring ...
1
vote
0answers
62 views

Excel 2010 - Merge multiple connections into single worksheet

I have an Excel workbook containing several worksheets. Each worksheet has an external connection to a unique .csv file that is updated several times a day from different PCs. This is done so that ...
1
vote
0answers
25 views

Right click a csv file to read in RStudio?

I would like the ability to right click on a .csv file and read it in RStudio (an IDE for the statistical language R). When I say "read it in RStudio" I mean open up RStudio with the line ...
1
vote
0answers
84 views

How to fix botched Outlook CSV data export 2013

When I exported contacts from outlook into a CSV file (to later upload it to Insightly database), it placed company names as part of the email address, it looks like this: Column named "E-mail" ...
1
vote
0answers
205 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”> ...
1
vote
0answers
169 views

Why is libre office calc inserting a ' at the beginning of the cell?

This is the most ridiculous thing i've encountered.. I've imported a csv, I end up with nice neat clean rows of numbers, no formatting, nothing weird, no " or ' left over, just numbers. When I go to ...
1
vote
0answers
168 views

How to restore Eclipse shortcut keys from exported .CSV?

You can simply export your shortcuts settings in Eclipse going to Window > Preferences > General > Keys > button Export CSV... But how to restore shortcuts from this csv?
1
vote
0answers
125 views

Disable prompt when opening a CSV file in LibreOffice/OpenOffice Calc

Every time I open a CSV file, LibreOffice presents me with a prompt asking to confirm Character Set, Language, and Separator options (tab, comma, semicolon etc). This prompt is not present in ...
1
vote
0answers
128 views

I want to be able to have a daily task run showing the times users log on and off

GOAL: I want to be able to have a daily task run showing the times users log on and off ENVIRONMENT: Windows 2008R2 domain ACTIONS SO FAR: I have enabled Account Auditing via: start -> ...
1
vote
0answers
400 views

Get rid of warning for external data connection

In Excel 2011 for Mac, I'm using an external data link to collect data from a CSV file generated by a third party application. The CSV is continuously filled, so I want to update the data every time I ...
1
vote
0answers
184 views

How to export Excel with Hindi script to CSV file?

I would like to know how to export an excel spreadsheet which contains, say a table of Hindi(for that matter any non-english) script words into a CSV file? I tried 'Save As' --> comma delimited, but ...
1
vote
0answers
23 views

Spreadsheet to MySQL

I need to export spreadsheet data for import into a MySQL database. Data must be in quotes to import properly. The problem is with numbers. Is there a formula or other quick method other than copy and ...
1
vote
0answers
560 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 ...
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 ...
1
vote
0answers
679 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 ...
1
vote
0answers
257 views

When I try to export Outlook 2010 tasks, Outlook crashes

When I try to export tasks from the Tasks folder of Outlook 2010 to either a tab-delimited or a comma-separated file, Outlook starts to export and then crashes with the options of trying to find a ...
1
vote
0answers
90 views

Creating a script to make a CSV dump usable

So, let's say I have a raw CSV dump. And I want to make a spreadsheet/script to take said CSV dump, take a certain username, and the calls they made, and pipe those calls to a mathematical formula, to ...
1
vote
0answers
196 views

Use one csv file to delete duplicates in another one

Basically the title says it all. I have a csv list that includes one e-mail address per line (and some other stuff). I want to seek those email addresses in a different csv file (also with 1 mail ...
0
votes
0answers
36 views

MySQL csv excel greek characters

I developed an application using Bottle web framework and Python, to import some data into MySQL database. Most of the data where in Greek characters. On my application side, i didn't any further ...
0
votes
0answers
19 views

Anki fails to import from .csv file

I have created an custom note type containing 3 fields: Character, Pinyin and Definition. I have a .csv file containing a few entries. The fields are comma-delimited. Here's what I am presented when ...
0
votes
0answers
30 views

Excel formula returning different results on different machines

For a piece of work I'm doing, I use a formula that calculates the difference between two dates for each row in the report that the system generates. Essentially, the software I'm using generates the ...
0
votes
0answers
31 views

Create Xbox Music Playlist from excel list (csv)

I created a few playlists in Excel (just the artist & song title) that I wanted to Import into Xbox Music. Unfortunately the only way I could find was to search for each song indivdually and then ...
0
votes
0answers
13 views

Export specific results of Access 2010 query determined by checkbox

I am working on a planning tool which provides information about how long particular tasks should take. Everything was working as expected but I have just been informed that the user would like to ...
0
votes
0answers
23 views

phpmyadmin wordpress export only showing postmeta columns

Trying to export - and the import - a Wordpress MySQL DB using phpmyadmin. I've done this quit a bit in the past and I'm completely perplexed at this point! I have a fairly standard Wordpress DB with ...
0
votes
0answers
24 views

LibCurl: FTP, wildcard file inside wildcard directory

I am using LibCurl looking to download one file. The problem is that the server will regularly updating new directory, and inside that directory, I am looking to download SINGLE file end with *.CSV ...
0
votes
0answers
51 views

Convert CSV to an MP3 Playlist, then merge the MP3 into a single audio file based on playlist order

I have a Japanese language learning app, which contains several MP3s. I'd like to merge these MP3s into a single file, so I can take the course without using the app (as the App has a terrible ...
0
votes
0answers
55 views

Excel 2013 keeps removing commas from CSV at save

I'm working with data exports in CSV format. Excel originally opens the files correctly. However, I've been merging in some missing data that my original queries missed (adding four rows of additional ...
0
votes
0answers
36 views

How to swap two columns in specific rows in LibreOffice Calc?

I have a few hundred contacts stored in Google Contacts, and I would like to sort them. I exported them in CSV and opened them with LibreOffice Calc. Some of my contacts have first and last name ...
0
votes
0answers
214 views

Excel VBA Script How to Open a File and Insert character into Cell

I'm hoping this is an easy one. I am importing a directory of CSV files with long numbers (16 digits plus 4 leading zeroes). I need Excel to preserve the number data instead of applying scientific ...
0
votes
0answers
112 views

Import multi-line CSV records into spreadsheet as column data

Any standard fixes to convert multi-line CSV records into column data (as CSV or LibreOffice)? I'm using ArchLinux and I have LibreOffice (and Python, for what that's worth). I have a CSV file with ...
0
votes
0answers
35 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 ...
0
votes
0answers
112 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 ...
0
votes
0answers
205 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
0answers
55 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
0answers
154 views

OpenOffice Calc with csv file produces Err:520

I'm loading a csv file into OpenOffice Calc (version 4.0.1) and in only 1 column I get 'Err:520' as the cell value. I checked under Tools->Options->OpenOffice Calc->View->Display to check whether ...
0
votes
0answers
103 views

Is there a text file format that Excel supports opening and saving directly?

I want to edit simple table data in Excel 2010, which is to be stored only in a flat text format (i.e. not a binary format like XLS or XSLX) which is viewable with notepad and can be read by a simple ...
0
votes
0answers
68 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 ...
0
votes
0answers
369 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 ...
0
votes
0answers
317 views

replace comma with colon in csv file

In CSV file all other delimiters are comma except for 1 colon. While saving this CSV, excel replaces this colon to comma. How can I overcome this? or Later how can I replace those particular comma ...
0
votes
0answers
106 views

Getting Access 2000 to output CSV with quote “only where needed”

Does anyone know how to get Access 2000 to output a comma-delimited file in this format: Good> Cat, "John, Doe", 32, $3.44, "Denver, CO", 1234 NOT like this: Bad> "Cat", "John, Doe", "32", ...