Questions tagged [csvsimple]

{csvsimple} provides a simple LaTeX interface for the processing of files with comma separated values (CSV).

Filter by
Sorted by
Tagged with
46
votes
3answers
65k views

How to plot data from a CSV file using tikz and csvsimple?

Here is a minimal example : \begin{filecontents*}{data.csv} a,b,c,d 1,4,5,1 2,3,1,5 3,5,6,1 4,1,4,9 5,3,4,7 \end{filecontents*} \documentclass{article} \usepackage[utf8]{inputenc} \usepackage{...
9
votes
2answers
8k views

Importing CSV file as a table in Latex but file too long

I am trying to import a CSV file but the data in the table is too long it goes down till the end of the page and disappears without continuing on the next page. Here's the file: \begin{filecontents*}...
6
votes
3answers
4k views

Bold one cell in table using CSV reader

Is it possible to bold a single desired cell (or number of cells) using csvreader (besides the head)? Here is an example of making the table. \documentclass{article} \usepackage{csvsimple} % Make ...
4
votes
2answers
8k views

Csvsimple \csvautotabular and \csvautobooktabular with centered columns' content

I'm using csvsimple for making tables, and csvautotabular and csvautobooktabular are working great. However, I'd like the content of each column to be centered instead of aligned to the left. An ...
2
votes
1answer
961 views

Ignore UTF-8 BOM with csvsimple?

I am currently using csvsimple to include some external data in a document processed with pdfLaTeX. The entire project uses UTF-8 as encoding. The original data is maintained in an Excel 2010 file, ...
2
votes
2answers
766 views

csvsimple Vertical Header

I'm trying to create a table from .csv files using csvsimple. Here are the contents of my file: Degrees,10,20,30,40,50,60,70,80,90 Time,1.33,0.90,0.72,0.63,0.50,0.43,0.41,0.40,0.38 This is a table ...
6
votes
1answer
3k views

Display top border of table using csvreader

I am using csvreader from the csvsimple package to generate a table in my document. I am struggling to get a top border on the table. Here is the code, including writing the .csv \documentclass{...
5
votes
2answers
663 views

csvsimple and siunitx

I'm trying to import data from a csv file and using the S column type from siunitx to format the numbers with this code: \documentclass{article} \usepackage{siunitx} \usepackage{csvsimple} \begin{...
3
votes
1answer
68 views

Possible Bug in passing variables from CSV

I think there's a bug in calling decimal numbers from CSV files. Have a look. Create a Folder. Add a CSV file called texDemo.CSV with the following in it. UniqueID,Name,DecimalPercentageComplete,...
3
votes
1answer
294 views

How to import data from excel and format it as text in LaTeX?

I have a big database spreadsheet on Excel which is a list of products and I want to use its data to write formatted text in LaTeX. The table looks like this: Year / Name product / Details 2000 / ...
2
votes
1answer
961 views

separator line (horizontal and vertical) for a table imported using \csvautobooklongtable

I have been trying to fix the column width of my table so that the text would automatically get warped to the next line and not shoot outside the page. After searching for a few days, being a total ...
2
votes
1answer
142 views

raster plot with tikz in latex from csv file

I am trying to plot neuron's spikes which are stored in a csv file the following way: time, neuron1, neuron2, neuron3,... 1,1,0,1,... 2,1,0,0,... 3,0,0,1,... and so on... Therefore the data ...
1
vote
3answers
2k views

csvreader and respect all (special characters in the csv file)

I'm trying to use csvsimple to read in a file with elements that contain special characters (underscores in this example) and create a table that only has a some of the columns. I can read in the file ...
1
vote
1answer
339 views

Underfull \hbox warning about alignement in a csvsimple table

The following csvsimple table keeps returning warnings of the type: Underfull \hbox (badness 10000) in paragraph at lines: \csvreader[no head, longtable=|p{\dimexpr 0.2\linewidth-2\tabcolsep}|p{\...
11
votes
3answers
2k views

How can CSV files be put into LaTeX without having to adjust much?

I would like to have a TeX-Snippet that takes a filename as an argument and outputs a table with toprule and bottomrule: \begin{tabular}{lrr} \toprule Fach & Dauer & Einkommen\\ ...
7
votes
1answer
2k views

Math mode for csvsimple Import

I am currently struggling when I try to import a CSV file which contains math code using the following code: \documentclass{article} \usepackage{csvsimple} \usepackage{amssymb} % Math symbols \...
6
votes
1answer
1k views

csvsimple handles underscores wrong

I try to print a .csv file using csvsimple. The column headers of that CSV file contain underscores. Within the csvsimple documentation, I found the option respect underscore=true option that is ...
6
votes
1answer
2k views

How to deal with csv file whoese fields are enclosed by quote?

I have a csv file whose fields contain text. As fields can contains newlines, they are enclosed by double quotes. Editing these file works well with my favourite spreadsheet (libreoffice). I want to ...
5
votes
2answers
2k views

using csvreader to read from csv giving invalid output

I am trying to output a *.csv file to LaTeX, but I keep on getting invalid output. I am using mactex on a yosemite environment. code.csv: code,subcd CITY,LIMA CITY,PUEBLOLIBRE CITY,JESUSMARIA CITY,...
4
votes
1answer
843 views

Recreating formatting of an Excel table using simplecsv

I'm trying to recreate a wholesale price list in LaTeX so that the data can be updated automatically from CSV files. I'm able to import data using \csvautolongtable but I'm struggling with the ...
3
votes
1answer
906 views

CsvSimple with tabular: set specific number of rows

For a tabular environment with csvsimple I would like to set the number of rows specifically. This example is an attempt to show only the first two rows: \documentclass{article} \usepackage{...
3
votes
2answers
192 views

Unable to print without quotes in csvsimple

I am trying to print a table from .csv file which is generated by libreoffice in such a way one of the column has a value comma separated e.g John,Terang i want to print John, Terang without any ...
2
votes
1answer
268 views

Auto generate list-items within table from string with delimiter

This is a follow-up on this question: Creating bullet-list from string with delimiters I have a CSV file where I genereate some tables from. Some of those table cells will have items that should be ...
2
votes
1answer
39 views

Strange csvsimple output when the line starts with an accented character

The code example below produces an undesirable result, where an Omega appears on the 5th line and all data from the 6th line appears glued to the last cell in the 5th line. Does anyone knows what ...
2
votes
1answer
44 views

Adding/subtracting to the /thecsvrow number in csvsimple

Assume a simple example centered on the csvsimple package. \documentclass{standalone} \usepackage{csvsimple} \usepackage{fp} \usepackage[table]{xcolor} \begin{filecontents*}{input.csv} Foo,...
2
votes
1answer
131 views

csvsimple command csvreader changes national letter å to a

I have just began to use the csvsimple package, where I noticed a problem with national letters. The problems occurs with the danish letter å (\aa) and Å (\AA). Before the table these letters are ...
2
votes
1answer
672 views

Reading and (custom) formatting a CSV (not \csvautotabular)

Suppose I have a really long, really boring list of data in - let's say CSV, but converting to other formats is an option, when this can be done automatically - and I want to prepare a section in my ...
2
votes
1answer
693 views

Automatic line breaks in csvautobooklongtable

I have automatically generated CSV (pipe-separated) Data, that I want to print as Latex \csvautobooklongtable. I do not know the the amount of columns (they are variable in number from one set of data ...
2
votes
2answers
686 views

Build PGF/TikZ matrix from CSV file

I want to automatically build a PGF/TikZ based drawing based on some external data that is read using csvsimple. My main issue at the moment is that most of the nodes are part of a matrix, mainly to ...
1
vote
1answer
605 views

csvreader longtable caption repeated on every page

I am using csvreader with longtable and I added a caption in table head below is my code: \csvreader[ longtable=ccc, table head=\caption{Caption goes here. }\label{tab:sometab} \\ \toprule\...
1
vote
2answers
1k views

how to import CSV table with header containing spaces

The header column names in my CSV contain spaces. Is there a way to still import it using csvsimple or maybe some other package? That way I would be able to specify data in CSV, import it and render ...
1
vote
1answer
1k views

“Undefined control sequence” while creating a tabular from a csv file

This issue is to say the least, very weird. I have a 12 columns csv file about several macroeconomics indicators: n,pibreal,pibnom,deflactor,c,isr,trc,tdeflactado,trcdeflactado,I,x,m 2000,...
1
vote
1answer
256 views

package incompatibility: csvsimple & etextools

The following code fails to compile: \documentclass{beamer} \usepackage{csvsimple} \usepackage{etextools} \begin{document} Hello! \end{document} The error message is ! LaTeX Error: Command \...
1
vote
1answer
485 views

csvsimple table going off of page

I have the following CSV dow_distribution.csv file: dow,ANZ Volume,BHP Volume,CBA Volume,MQG Volume,NAB Volume,QAN Volume,RHC Volume,TLS Volume,WBC Volume,WOW Volume,AORD Volume,Total Volume Monday,3....