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
0answers
735 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”> ...
3
votes
0answers
336 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?
2
votes
0answers
211 views

PowerShell Script to Rename - Copy - Move

I am trying to write a PowerShell script to do the following. step 1 Rename files in source (FTP folders) directories with it's "current_name_datetime.csv" as per a source file "Source_list.csv" ...
2
votes
0answers
2k 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. ...
2
votes
0answers
54 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
130 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
222 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 ...
2
votes
0answers
754 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 ...
2
votes
0answers
711 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
433 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
12 views

text qualifier of csv missing in excel

I have created a csv file with semicolon as delimiter and double quote ad text qualifier. But when I open in excel, the first double quote of the rows disappear. When I use text to column wizard ...
1
vote
0answers
24 views

Notepad++ multi line copy paste in different lines

I have a csv file with: David,33,Virginia John,45,Alabama Tina,33, Texas Another file which contains: <Person> <Name>name1</Name> <Age>xx</Age> ...
1
vote
0answers
32 views

Excel 2010 - Get CSV wizard to open by default

I'd like to set Excel 2010 to open the import wizard each time I double click on a CSV file rather than have Excel open the file without the wizard. Previous versions of Excel did this but 2010 ...
1
vote
0answers
103 views

What's the most convenient way to edit multi-card vcard files (.vcf)?

I have my contacts exported to a VCF file (a vCard) file. But they're partially messed up for reasons I won't go into. I'd like to edit them, making some changes to individual entries and some changes ...
1
vote
0answers
29 views

Locked between MailChimp and European Windows for CSV export?

I have a CSV export for our application that is being used by end users (not tech-savvy). For some European regional settings Excel expects a semicolon ; for delimiting (comma is used for decimals). ...
1
vote
0answers
84 views

Regex to find commas, excluding commas inside a string demarcated by double quotes

I would like to manipulate a closed .csv file without opening it through a button on an Excel AddIn. I am able to complete all the steps but am having a problem with finding a regex that would ...
1
vote
0answers
218 views

Properly import all fields from 'Windows Contacts' to Thunderbird

I want to migrate/import ALL information of my contacts to Thunderbird. On my Windows 7 system I carefully managed my contacts including birthday, gender, spouses and children. But I'm having trouble ...
1
vote
0answers
263 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 ...
1
vote
0answers
147 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
269 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
185 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
258 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
147 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
379 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
30 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
1k 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
47 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
902 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
401 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
93 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
205 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
20 views

ping results exported to .csv to multiple rows and columns

I have a script that I run to ping multiple Ip addresses. It works just fine with everything that I have in it the way I want it. The problem is the export. I need "Router" to Start in Column "A" ...
0
votes
0answers
17 views

Matching 3 or more words from fields in seperate csv files.

I have two csv files: This is csv1: 11, The Sun Still Shines in Reading, 64312, 464566 13, You and Me Together Again London, 564564, 131355 12, What's the Story Now Your Gone, 4545646, 1124545 17, ...
0
votes
0answers
34 views

Default character encoding for Excel Text Wizard?

A large part of my job is to run an SQL query, save the results as a UFT-8 encoded csv file then import it into Excel for further manipulation and distribution. When I import the csv file into Excel ...
0
votes
0answers
29 views

How to sanely export CSV in Microsoft Excel 2010

I need to export a sheet that has data in columns A:N but if I open it in Excel it has columns O:XFD that are just blank. When exporting to CSV Excel exports everything in those columns, thus the ...
0
votes
0answers
12 views

How to migrate artifacts fom a project to another

I am the scrum master of a project. As a newbie to Tuleap, I created a sandbox project. After experimenting in my sandbox, I want to feed my true project with artifacts like user stories or epics. I ...
0
votes
0answers
109 views

Exporting Outlook contacts to Unicode CSV

Background So I've been looking for this to work for some time now. I'm sure there must be a solution as I can't believe that no one in China or Japan have ever tried exporting contacts. What I've ...
0
votes
0answers
40 views

Importing Variable data sets with UTF 8 BOM japanese characters

I have an image template and have a xlsx file with Japanese characters wit two columns(PFA). I need to create images with this information by importing the CSV into variable data sets. When I convert ...
0
votes
0answers
46 views

Excel Data Connection Always Has 1 Extra Row

I have an Excel file with a data connection to another Excel workbook. Every time that I refresh the connection, there seems to be one extra blank row in the table (with formulas, but there is no ...
0
votes
0answers
154 views

Convert a txt file into csv using powershell

The document that I am trying to convert is Formatted like so: 2012/12/09 REPORT OF USERS PAGE 1 HRS RG POSITION OPTIONAL ADDITIONAL USER # ...
0
votes
0answers
100 views

I can't import contacts into Outlook 2013 using vcf file and csv file

Help! I've backed up my phone with an app called "My Contacts Backup" emailed them to myself in vcf format. I tried to import it into my Outlook contacts but keep getting a permissions error. " We ...
0
votes
0answers
19 views

Have Excel search CSV's and mark where he finds names

Sorry about the confusing question title, it's kinda confusing me to explain in the right way, so hopefully this text will do a better job with it. My company has multiple CSV files pertaining the ...
0
votes
0answers
44 views

Pasting Paragraphs into Excel cells with Automatic HTML line breaks

Hello All Excel masters, Using Microsoft Excel I'm Working with Magento & creating large product lists in a .CSV format. The Problem I'm having is when I Paste Ex. paragraph LEGO movie ...
0
votes
0answers
9 views

Export CSV list of reverse links in Tuleap

I'd like to export the reverse links for my artefacts in CSV (i.e. having a list of all artefacts linking to the artefact I'm exporting the data from). Is it doable without having to trick it manually ...
0
votes
0answers
70 views

Libre Office Calc Issue: Summarizing columns with too many rows

I'm writing a script that reads data taken from a database. THe data is modified (de-duplicated) and put into a .csv file I have a problem as I want to find the sum of a particular column in excel. ...
0
votes
0answers
88 views

Capturing the MAC addresses of associated clients of a specific access point

I am trying to capture the MAC addresses of associated clients of specific access points as an experiment to see which type of device (by way of OUI lookup) most commonly connects to different access ...
0
votes
0answers
33 views

Spline drawing to CSV

I am trying to generate a csv file for a spline curve drawn on LibreCAD. I see that the drawing can be saved as dxf/dwg, but not as point data. I was wondering if anyone has managed to export into csv....
0
votes
0answers
42 views

Most reliable or widely used standard for CSV file formatting

I'm wondering what are the most common standards for CSV file, and is there any OFFICIAL one ? I just did several searches on google, SO and other sources, and the best I found is Wikipedia : No ...
0
votes
0answers
351 views

Losing decimal places when exporting to csv

I am exporting data from oracle table into a csv file. I have a column of varchar2 datatype and it has values like 1.1 and 1.10. When I export these to a csv file the value 1.10 becomes 1.1 and thus ...
0
votes
0answers
97 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 ...